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.
Running these manual commands is just shifting the config tuning for large databases to periodic „manual“ operations.