Jeffrey Baker wrote:
Secondly, there really does need to be an autovacuum=off,really,thanks so that my maintenance can proceed without competition for i/o resources. Is there any way to make that happen?
You could bump up autovacuum_freeze_max_age while you run the vacuums manually, and then set it back. It will require a restart, though.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers