On Mar 31, 2006, at 5:45 PM, Matthew T. O'Connor wrote:
I think the closest approximation of disabling autovacuum on a
per database basis is to connect to the database in question and
perform:
update pg_autovacuum set enabled = 'false';
This will prevent autovacuum from vacuuming or analyzing any of
the tables in the database, but will still check for XID wraparound.
Problem with that is any time you add a table you'd need to re-run
that
command. Wouldn't be so bad if we had DDL triggers, but...
Probably a dumb comment, but can you set a default value for the
enabled column?
As Tom pointed out, that wouldn't help because rows aren't
automatically added to pg_autovacuum.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
