Re: auto vacuuming

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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461