Re: pg_class.reltuples not reset by VACUUM?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Boes <jboes(at)nexcerpt(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_class.reltuples not reset by VACUUM?
Date: 2003-04-08 19:19:59
Message-ID: 19573.1049829599@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Josh Berkus 2003-04-08 19:29:47 Re: Problem about Triggers and Function
Previous Message Jeff Boes 2003-04-08 19:19:32 Re: pg_class.reltuples not reset by VACUUM?