Skip site navigation (1) Skip section navigation (2)

Re: VACUUM vs auto-vacuum daemon

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>, pgsql-performance(at)postgresql(dot)org
Subject: Re: VACUUM vs auto-vacuum daemon
Date: 2007-06-13 15:08:56
Message-ID: 46700888.3080506@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
Bill Moran wrote:
> In response to "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)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/


In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2007-06-13 15:29:19
Subject: Re: WAL shipping and ever expanding pg_xlog
Previous:From: Bill MoranDate: 2007-06-13 14:46:10
Subject: Re: VACUUM vs auto-vacuum daemon

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group