Re: Autovacuum missing tables

Bryan Payne <bpayne@speedfc.com> wrote:

> 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?

For starters, we need to know what version of PostgreSQL this is:

select version();

It wouldn't hurt to see the contents of your postgresql.conf (with
all comments removed) and to know something about the table, and how
it's used.  One way to get that information would be:

VACUUM ANALYZE VERBOSE tablename;

-Kevin