Postgres Pro
Downloads
Home   >   mailing lists

Re: controlling autovacuum during the day. - Mailing list pgsql-admin

From Tom Lane
Subject Re: controlling autovacuum during the day.
Date
Msg-id 28510.1229525243@sss.pgh.pa.us
Whole thread Raw
In response to Re: controlling autovacuum during the day.  ("John Lister" <john.lister-ps@kickstone.com>)
Responses Re: controlling autovacuum during the day.  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
Tree view 
"John Lister" <john.lister-ps@kickstone.com> writes:
> Cheers for the quick reply. I've tweaked them quite a bit, but we have quite
> a few heavily updated tables that i'd like vacuuming to keep them in check.
> Unfortunately the autovacuum does a FULL vacuum every so often locking the
> tables for quite a long time, i'd like to move these to the evening if
> possible.

Huh?  Autovacuum *never* does VACUUM FULL.

            regards, tom lane

pgsql-admin by date:

Previous
From: "John Lister"
Date:
Subject: Re: controlling autovacuum during the day.
Next
From: "John Lister"
Date:
Subject: Re: controlling autovacuum during the day.