Re: Autovacuum on by default? - Mailing list pgsql-hackers

From Matthew T. O'Connor
Subject Re: Autovacuum on by default?
Date
Msg-id 44E4A795.3070403@zeut.net
Whole thread Raw
In response to Re: Autovacuum on by default?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Autovacuum on by default?
List pgsql-hackers
Josh Berkus wrote:
>> Is it time to turn on autovacuum by default in 8.2?  I know we wanted 
>> to be on the side of caution with 8.1, but perhaps we should evaluate 
>> the experiences now.  Comments?
> 
> I'm in favor of this, but do we want to turn on vacuum_delay by default 
> as well?

I thought about this, might be a good idea as it will mitigate the 
impact of vacuums, however it will also slow down vacuums, I'm a bit 
concerned that it won't be able to keep up on really large database, or 
that it'll fall really far behind after vacuuming a big table.

Also, if we do enable it, what is a good default?


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] selecting large result sets in psql using cursors
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Autovacuum on by default?