Jeff Boes <jboes(at)nexcerpt(dot)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