Re: Question about VACUUM

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Question about VACUUM
Date: 2011-12-07 04:13:54
Message-ID: 4EDEE802.1040202@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Havasvölgyi Ottó 2011-12-07 08:23:39 Re: Response time increases over time
Previous Message Josh Berkus 2011-12-07 04:11:45 Re: Response time increases over time