New answers tagged maintenance
You can set a time where autovacuum should not run. Here's how to (assuming You're on linux): Create a script to turn off/on autovacuum The script should contain : sed -i 's/autovacuum = on/autovacuum = off/g' postgresql.conf pg_ctl -D PGDATA reload Place the script on cron. Let's say You have cron to turn off autovacuum at 2 PM and then have cron ...
Top 50 recent answers are included