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
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