Re: Autovacuum stopped running - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Autovacuum stopped running
Date
Msg-id 20100503134738.GA2986@alvh.no-ip.org
Whole thread Raw
In response to Re: Autovacuum stopped running  ("Benjamin Krajmalnik" <kraj@illumen.com>)
Responses Re: Autovacuum stopped running  ("Benjamin Krajmalnik" <kraj@illumen.com>)
List pgsql-admin
Benjamin Krajmalnik wrote:
> OK.
> This happened again on another server with these same settings.
> I did not see any long running transaction, and the autovacuum launch
> process was running.

Did you check the server log for FATAL or ERROR lines?  Maybe it's dying
trying to vacuum some table and isn't ever able to get to the next ones.


--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets
Next
From: "Kevin Grittner"
Date:
Subject: Re: Autovacuum stopped running