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

Re: VACUUM vs auto-vacuum daemon

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: VACUUM vs auto-vacuum daemon
Date: 2007-06-12 16:42:10
Message-ID: f4micm$1cq6$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-performance
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 ?

Sabin 



In response to

Responses

pgsql-performance by date

Next:From: Christo Du PreezDate: 2007-06-12 16:59:16
Subject: Re: test / live environment, major performance difference
Previous:From: Bill MoranDate: 2007-06-12 16:25:55
Subject: Re: VACUUM vs auto-vacuum daemon

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