From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Subject: Re: Question about VACUUM
Date: Tue, 06 Dec 2011 23:13:54 -0500
Message-ID: <4EDEE802.1040202@agliodbs.com> (raw)
In-Reply-To: <4EDCBAD2020000250004384F@gw.wicourts.gov>
References: <4ED9F32A02000025000437EC@gw.wicourts.gov>
<CAMB2kH73WpbY+E8bBjU9_Yopmo3PdLaGwhMT5tZ3fQ_nvHODLQ@mail.gmail.com>
<4EDCBAD2020000250004384F@gw.wicourts.gov>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com
Subject: Re: Question about VACUUM
In-Reply-To: <4EDEE802.1040202@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox