Autovacuum missing tables

From: Bryan Payne <bpayne(at)speedfc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Autovacuum missing tables
Date: 2010-07-29 14:00:00
Message-ID: 4C518960.3040004@speedfc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Autovacuum is sometimes skipping certain tables. The tables in question
are pretty busy. A vacuum analyze works fine when run manually. The
tables in question were successfully autovacuumed this morning, but that
is the first time since the 23rd where it worked. I'm not finding any
logging info regarding the autovacuum. I'm not sure if autovacuum is
seeing table locks or what, but is there a way to run a more aggressive
autovacuum?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kananda 2010-07-29 20:16:44 PostgreSQL keepalives help
Previous Message Craig James 2010-07-28 22:13:57 Connection pooling for a mixture of lightweight and heavyweight jobs?