I verified that it was not doing anything by erasing the pg_statistics table and it did not fill it within 24 hours. When I 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"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
