Re: [7.0.2] INDEX' TUPLES != HEAP' ..

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [7.0.2] INDEX' TUPLES != HEAP' ..
Date: 2000-07-12 23:17:51
Message-ID: Pine.BSF.4.21.0007122016520.1325-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 12 Jul 2000, Tom Lane wrote:

> The Hermit Hacker <scrappy(at)hub(dot)org> writes:
> > Odd .. why is heap reporting 5899, when count() only reports 2951?
>
> Open transactions preventing recently-dead tuples from being reaped?

nope ... I've tried recreating the indices, no change ... and no change in
number of tuples ... actually, since this database is up, there would have
been zero additions or deletions, as that ability is yet to be re-written,
so other then SELECTs, that table is static/read-only

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tim Perdue 2000-07-12 23:28:31 Some Improvement
Previous Message Tom Lane 2000-07-12 23:13:51 Re: [7.0.2] INDEX' TUPLES != HEAP' ..