Skip site navigation (1) Skip section navigation (2)

Re: 8.1.8 autovacuum missing databases

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ian Westmacott <ianw(at)intellivid(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.1.8 autovacuum missing databases
Date: 2008-04-30 16:19:42
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
Ian Westmacott wrote:
> On Tue, 2008-04-29 at 17:12 -0400, Alvaro Herrera wrote:
> > Can you verify whether age(pg_database.datfrozenxid) is shrinking after
> > vacuuming?  If the age() of a database is higher than the applicable
> > max_freeze_age, then it will always be chosen.
> One of the databases is about 1.5TB, so that could take a while.
> Anything else I could look at in the meantime?  The age of these
> databases right now is about 290039577.  Also, autovacuum doesn't always
> choose the same DB, it alternates between template1 and one of mine --
> going back through a couple of months of logs I don't see it ever
> choosing the same one twice in a row.

Right -- if you have two databases over the wraparound edge, it will
alternate between them.

I still think that the autovac is dying before completing the task.  Did
you investigate whether there are "ERROR" messages coming from
autovacuum?  No PG crashes would happen.

Alvaro Herrera                      
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to


pgsql-admin by date

Next:From: Tom LaneDate: 2008-04-30 16:27:49
Subject: Re: 8.1.8 autovacuum missing databases
Previous:From: Ian WestmacottDate: 2008-04-30 13:02:26
Subject: Re: 8.1.8 autovacuum missing databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group