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

Re: 8.1.8 autovacuum missing databases

From: Ian Westmacott <ianw(at)intellivid(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.1.8 autovacuum missing databases
Date: 2008-04-30 13:02:26
Message-ID: 1209560546.5209.12.camel@vega.intellivid.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.

I'll note that I have 5 of these essentially identical systems (same
hardware/software platform, databases, configuration, and load).  Two of
them have this issue (autovacuum processing multiple databases, but not
all) and the other three don't.  A commonality between the two that have
this issue is that template1 is processed but postgres is not.  One of
the two is processing the 1.5TB DB but the other is not.

Thanks,

	--Ian



In response to

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2008-04-30 16:19:42
Subject: Re: 8.1.8 autovacuum missing databases
Previous:From: e tDate: 2008-04-30 12:15:36
Subject: Re: server crash, need to restore DB functionality

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