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-30 14:39:40
Message-ID: 4C52E42C.8070701@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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-07-30 14:46:35 Re: Autovacuum missing tables
Previous Message Richard Huxton 2010-07-30 13:51:51 Re: PostgreSQL keepalives help