Re: pg_autovacuum not doing anything - Mailing list pgsql-general

From Thomas F. O'Connell
Subject Re: pg_autovacuum not doing anything
Date
Msg-id 03298093-2E3E-4C0C-8A59-DCAAC1A5BEC8@sitening.com
Whole thread Raw
In response to pg_autovacuum not doing anything  ("Sim Zacks" <sim@compulab.co.il>)
Responses Re: pg_autovacuum not doing anything
List pgsql-general
How do you know that it is not vacuuming or analyzing anything?

And which version of postgres did you build/acquire pg_autovacuum from?

It seems that in post-8.0 versions, there is almost no output by
default. You could try increasing the debug output using -d 1 or -d 2
on the command line to verify that any activity is occurring.

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)

On Sep 11, 2005, at 4:26 AM, Sim Zacks wrote:

> I have pg_autovacuum running on my gentoo server, the same server
> with the
> postgresql database.
> ps shows that it is running and I have it start automatically with the
> system. It is not vacuuming or analyzing the tables though.
> Am I doing something wrong? Is there a better way to do this?
>
> Thank You
> Sim


pgsql-general by date:

Previous
From: Matthew Peter
Date:
Subject: Re: list manipulation at column level
Next
From: Sim Zacks
Date:
Subject: Re: pg_autovacuum not doing anything