Re: Autovacuum stopped running

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Benjamin Krajmalnik <kraj(at)illumen(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Autovacuum stopped running
Date: 2010-05-03 13:47:38
Message-ID: 20100503134738.GA2986@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-05-03 13:52:06 Re: Autovacuum stopped running
Previous Message Kevin Grittner 2010-05-03 13:43:37 Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets