Reducing the autovacuum_vacuum_cost_delay seems to have helped in my case. The a... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

kuroyi on July 23, 2015 | parent | context | favorite | on: Transaction ID Wraparound in Postgres

Reducing the autovacuum_vacuum_cost_delay seems to have helped in my case. The autovacuums just run too slow.

vladsanchez on July 23, 2015 [–]

They run too slow because they're background processes. Table partitioning, maintenance_work_mem tuning along with table-specific vacuum and autovacuum settings will get you a long way.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact