I am using autovacuum, and I assumed it was working correctly. Is there a way to tell if it is not doing what it is supposed to?
This is the result of ps for the autovacuum PID.
The docs say that it should automatically analyze.
PID TTY STAT TIME COMMAND
10184 ? Ss 0:32 /usr/bin/pg_autovacuum -D -v 1000 -V 2 -s 300 -S 2 -L /var/lib/postgresql/data/pg_autovacuum.log
My log files show nothing other then an error because I renamed a (different) database and it received a fatal error for a month, but that stopped last week (before I sent this message) when I rebooted the server There has been nothing in the log file since that.
This is running on gentoo and the pg_autovacuum is the default settings that starts automatically when the server boots.
Is there a way to check when the last analyze was done? I don't want to run analyze now until I can check that to see where the problem is coming from.
Thank you
Sim
________________________________________________________________________________
Sim Zacks <sim@xxxxxxxxxxxxxx> writes:
> [ goes back and looks more closely ] The row count estimates in your
> EXPLAINs are so far off that it's a wonder you got an OK plan for either
> query. Have you ANALYZEd these tables recently?
>
>
>
> regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
