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
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
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