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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
