Message-ID: <46700888.3080506@commandprompt.com>
Date: Wed, 13 Jun 2007 08:08:56 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
User-Agent: Thunderbird 1.5.0.12 (X11/20070604)
MIME-Version: 1.0
To: Bill Moran <wmoran@collaborativefusion.com>
CC: Sabin Coanda <sabin.coanda@deuromedia.ro>,
 pgsql-performance@postgresql.org
Subject: Re: VACUUM vs auto-vacuum daemon
References: <f4mfin$1vjf$1@news.hub.org>
	<20070612122555.2b0f4fa0.wmoran@collaborativefusion.com>
	<f4micm$1cq6$1@news.hub.org>
	<20070613104610.d9d06914.wmoran@collaborativefusion.com>
In-Reply-To: <20070613104610.d9d06914.wmoran@collaborativefusion.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Bill Moran wrote:
> In response to "Sabin Coanda" <sabin.coanda@deuromedia.ro>:
> 
>> Hi Bill,
>>
>> ...
>>> However, you can get some measure of tracking my running VACUUM VERBOSE
>>> on a regular basis to see how well autovacuum is keeping up.  There's
>>> no problem with running manual vacuum and autovacuum together, and you'll
>>> be able to gather _some_ information about how well autovacuum is
>>> keeping up.
>> Well, I think it is useful just if I am able to synchronize the autovacuum 
>> to run always after I run vacuum verbose. But I don't know how to do that. 
>> Do you ?
> 
> No, I don't.  Why would you want to do that?
> 
> Personally, I'd be more interested in whether autovacuum, running whenever
> it wants without me knowing, is keeping the table bloat under control.

analyze verbose.

> 
> If this were a concern for me (which it was during initial testing of
> our DB) I would run vacuum verbose once a day to watch sizes and what
> not.  After a while, I'd switch to once a week, then probably settle on
> once a month to ensure nothing ever gets out of hand.  Put it in a cron
> job and have the output mailed.
> 


-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/