Re: pg_class.reltuples not reset by VACUUM?

Jeff Boes <jboes@nexcerpt.com> writes:
> On Tue, 2003-04-08 at 15:10, Tom Lane wrote:
>> 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.

> It's even weirder than that:  note in the following how VACUUM sets the
> tuple count high, and ANALYZE sets it low.

That doesn't surprise me, given what they count.

> This appears to happen even if there are no transactions open.

You have open transactions.  Go find 'em...

            regards, tom lane