PostgreSQL

1. Autovacuum

1.1. Parameters

1.1.1. maintenance_work_mem

1.1.1.1. determines how much memory that you allocate for autovacuum to use to scan a database table and to hold all the row IDs that are going to be vacuumed

1.1.1.2. Work in conjuntion with autovacuum_max_workers

1.1.1.3. Many small tables, increase autovacuum_max_workers and less maintenance_work_mem

1.1.1.4. Large table (>100GB)

1.1.2. autovacuum_max_workers