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 19573.1049829599@sss.pgh.pa.us
Whole thread Raw
In response to Re: 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
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


pgsql-admin by date:

Previous
From: SHOBHA HALDONKAR
Date:
Subject: deadlock detection
Next
From: CoL
Date:
Subject: Re: Duplicate primary key and also the OID !!!!