-
PostgreSQL Deep Dive: maintenance_work_mem and autovacuum_work_mem — the memory parameters that decide how fast your database cleans up after itself
PostgreSQL Deep DivePostgreSQLmaintenance-work-memautovacuummemoryperformancetuningVACUUMCREATE-INDEX -
PostgreSQL Deep dive: Autovacuum internals — how Postgres decides when to clean up
PostgreSQL Deep DivePostgreSQLvacuumautovacuumperformancetuningoperations