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

From Rod Taylor
Subject Re: Autovacuum on by default?
Date
Msg-id 1155833237.65340.96.camel@home
Whole thread Raw
In response to Autovacuum on by default?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Autovacuum on by default?
List pgsql-hackers
On Thu, 2006-08-17 at 18:32 +0200, Peter Eisentraut 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 would say yes.

I use it on 2 databases over the 200GB mark without any difficulties.
One is OLTP and the other acts more like a data warehouse.

The defaults could be a little more aggressive for both vacuum and
analyze scale_factor settings; 10% and 5% respectively.

-- 



pgsql-hackers by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: Autovacuum on by default?
Next
From: "Magnus Hagander"
Date:
Subject: Re: BugTracker (Was: Re: 8.2 features status)