Re:Transaction ID Wraparound in Postgres
by kuroyi on Thursday July 23, 2015 @01:59PM
(#9937395)
Reducing the autovacuum_vacuum_cost_delay seems to have helped in my case. The autovacuums just run too slow.
[ Parent
| on HN ]
Re:Transaction ID Wraparound in Postgres
by vladsanchez on Thursday July 23, 2015 @06:11PM
(#9938822)
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.