Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Erik Jones <erik(at)myemma(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Date: 2007-06-01 16:08:58
Message-ID: 1180714138.15569.117.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> select age(datfrozenxid) from pg_database where datname = 'your database'
>
> 2 billions and you are screwed. Autovacuum starts panicking way before
> that, to have enough slack.

dbname=# select age(datfrozenxid) from pg_database where datname = 'dbname';
age
------------
1648762992
(1 row)

Sooo... looks like time to quickly upgrade to 8.1 head.

Thanks for the help,
Csaba.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2007-06-01 16:16:19 multimaster (was: Slightly OT.)
Previous Message Robert Fitzpatrick 2007-06-01 16:02:20 Restoring 8.2 to 8.0