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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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