News for hackers. Stuff that matters.
Re:Tips for a Healthier Postgres Database by topicseed on Sunday January 09, 2022 @07:07AM (#29862554)
Agreed, I never faced these issues as our database is relatively small but it's weird to see so many manual commands used for maintenance when these could be built-in PG ongoing process.

Why isn't that so?

Re:Tips for a Healthier Postgres Database by tpetry on Sunday January 09, 2022 @07:29AM (#29862686)
It is built-in. The autovacuum process is doing this. When you have a large database you may need to tune some config parameters, as the default conservative setting for low/mid databases are naturally different.

Running these manual commands is just shifting the config tuning for large databases to periodic „manual“ operations.