Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum - Mailing list pgsql-general

From Csaba Nagy
Subject Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Date
Msg-id 1180714138.15569.117.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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.



pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: SQL Manager 2007 for PostgreSQL released
Next
From: Andrew Sullivan
Date:
Subject: multimaster (was: Slightly OT.)