Hacker News new | ask | show | jobs
by AznHisoka 3511 days ago
What ive found is that if wih the default settings, if you're running over 150 million inserts/updates/deletes a day, your database is going to halt because of transaction wraparound errors. autovacuum simply cant catch up.

the solution for me was to batch inserts and updates in one transaction.