On Tue, 26 Aug 2008 12:58:59 -0400 "Dave Cramer" <[EMAIL PROTECTED]> wrote:
> > Well, I'm willing to help debug this, however this is a busy > production database and I need to be able to turn it off for a few > hours a day. Would changing autovacuum_freeze_max_age be a solution ? Populate the table pg_autovacuum with all your relations and the defaults from the postgresql.conf. Then set enabled to FALSE on all the tuples. When you are ready to turn autovacuum back on, set it to TRUE. Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers