Thread: pg_autovacuum not doing anything

pg_autovacuum not doing anything

From
"Sim Zacks"
Date:
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



Re: pg_autovacuum not doing anything

From
"Thomas F. O'Connell"
Date:
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


Re: pg_autovacuum not doing anything

From
Sim Zacks
Date:
I verified that it was not doing anything by erasing the pg_statistics table and it did not fill it within 24 hours.
WhenI ran vacuum analyze manually it filled it in. 
I am using postgresql 8.03 on gentoo which was downloaded with portage and included pg_autovacuum as part of the set
up. 
I will try setting the debug output to see if that gives me any more information.

Thank You
Sim
""Thomas F. O'Connell"" <tfo@sitening.com> wrote in message news:03298093-2E3E-4C0C-8A59-DCAAC1A5BEC8@sitening.com...
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>