We have a database with production data for a platform and another database with a production database dump for testing queries. We also have a test database but this one has slightly different DDL, because it’s for developing new features. Now Autovacuum is running on this server and keeps vacuuming this test database.
A simple way for stopping Autovacuum from even checking this db at all is adding an entry for every table in pg_autovacuum
:
|
|
This adds a stop entry for every table in your database, even for system tables. If you want the Autovacuum daemon to just ignore tables from a specific schema, add a relnamespace=scheme_oid
in the WHERE
clause.
Categories:
[Postgresql]
[Postgresql-News]