On 25-Aug-08, at 10:43 AM, Alvaro Herrera wrote:
Dave Cramer wrote:
Well, I go the extra mile and kill any remaing autovac procs
Here are the logs
2008-08-25 04:00:01 EDT [32276] LOG: autovacuum launcher shutting
down
2008-08-25 04:00:01 EDT [20526] LOG: autovacuum launcher started
What did you SIGHUP, the launcher or postmaster? You need the latter.
The launcher should exit automatically at that time.
No, I am HUP'ing the postmaster then subsequently killing any
autovacuums still around, which may be the problem.
I may be killing the launcher prematurely. I'll try again tonight.
Dave
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers