Re: relfrozenxid not getting reset even after manual VACUUM

On Mon, Aug 5, 2013 at 9:00 AM, Armand du Plessis <adp(at)bank(dot)io> wrote:

> production=# SELECT relname, age(relfrozenxid) as xid_age FROM pg_class
> WHERE relkind = 'r' ORDER BY age(relfrozenxid) DESC LIMIT 10;

Wow this is still on 9.2? Most likely some toast tables:

SELECT relname, age(relfrozenxid) as xid_age FROM pg_class WHERE relkind in
('r','t') ORDER BY age(relfrozenxid) DESC LIMIT 10;

--

regards