News for hackers. Stuff that matters.

A comment on Tips for a Healthier Postgres Database. Parent comment

Re:Tips for a Healthier Postgres Database by jeltz on Sunday January 09, 2022 @07:37AM (#29862718)
Have you looked into tuning autovacuum? Autovacuum should handle it and even it does not you should look at why it failed to run often enough.
[ Parent | on HN ]
Re:Tips for a Healthier Postgres Database by nicoburns on Sunday January 09, 2022 @10:55AM (#29864319)
We could. But seeing as we have pretty much no query volume overnight it seemed simpler just to use the hammer and vacuum everything overnight.
[ Parent | on HN ]