From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: or kills performance |
Date: | 2005-09-01 06:11:54 |
Message-ID: | 1353010333.20050901081154@compulab.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)compulab(dot)co(dot)il> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Art Fore | 2005-09-01 06:12:09 | syslog message I do not understand |
Previous Message | Casey T. Deccio | 2005-09-01 04:06:23 | Transaction error |