Re: pg_class.reltuples not reset by VACUUM? - Mailing list pgsql-admin

Jeff Boes <jboes@nexcerpt.com> writes:
> Well, here's the present state of the table, 24 hours later:

> # select count(*) from job_queue;
>  count
> -------
>   2369
> (1 row)

> # vacuum analyze verbose job_queue;

> NOTICE:  --Relation job_queue--
> NOTICE:  Pages 6831: Changed 2, Empty 0; Tup 358441: Vac 0, Keep 356048,
> UnUsed 5.
>     Total CPU 0.00s/0.15u sec elapsed 0.16 sec.

Yup, you definitely have a big problem with dead-but-unreclaimed tuples.
Look for some client that's holding an open transaction for long
periods.

            regards, tom lane