Re: Question about VACUUM - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Question about VACUUM
Date
Msg-id 4EDEE802.1040202@agliodbs.com
Whole thread Raw
In response to Re: Question about VACUUM  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Question about VACUUM
List pgsql-performance
On 12/5/11 1:36 PM, Kevin Grittner wrote:
> I understand the impulse to run autovacuum less frequently or less
> aggressively.  When we first started running PostgreSQL the default
> configuration was very cautious.

The default settings are deliberately cautious, as default settings
should be.

But yes, anyone with a really large/high-traffic database will often
want to make autovac more aggressive.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Response time increases over time
Next
From: Havasvölgyi Ottó
Date:
Subject: Re: Response time increases over time