Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: pg_class.reltuples not reset by VACUUM?
Date
Msg-id 15397.1049824333@sss.pgh.pa.us
Whole thread Raw
In response to pg_class.reltuples not reset by VACUUM?  (Jeff Boes <jboes@nexcerpt.com>)
Responses Re: pg_class.reltuples not reset by VACUUM?  (Jeff Boes <jboes@nexcerpt.com>)
List pgsql-admin
Tree view 
Jeff Boes <jboes@nexcerpt.com> writes:
> I thought that VACUUM ANALYZE would always restore some sense of reality
> to the internal statistics for a table.  However ...

Could we see the output of VACUUM VERBOSE for that table?

I suspect you have lots of dead-but-not-yet-reclaimable tuples in the
table, presumably because there is some very old transaction lurking
in the background.

            regards, tom lane

pgsql-admin by date:

Previous
From: Jeff Boes
Date:
Subject: VACUUM slow on small table
Next
From: Jeff Boes
Date:
Subject: Re: pg_class.reltuples not reset by VACUUM?