Re: [GENERAL] Autovacuum keeps vacuuming a table disabled in pg_autovacuum

[Csaba Nagy]

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



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend