Postgres Pro
Downloads
Home   >   mailing lists

Re: Defn of pg_class.reltuples in 7.2.1? - Mailing list pgsql-general

From Tom Lane
Subject Re: Defn of pg_class.reltuples in 7.2.1?
Date
Msg-id 16118.1018715644@sss.pgh.pa.us
Whole thread Raw
In response to Defn of pg_class.reltuples in 7.2.1?  (Ed Loehr <pggeneral@bluepolka.net>)
List pgsql-general
Tree view 
Ed Loehr <pggeneral@bluepolka.net> writes:
> Does pg_class.reltuples include "dead" tuples awaiting vacuuming?

No, at least not when it's been updated by VACUUM; since the VACUUM
will have removed said tuples.

I think it probably does count zombie tuples (ones that are committed
dead, but are still visible to some open transaction so VACUUM couldn't
remove 'em).

            regards, tom lane

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: Re: which perl dbd module?
Next
From: Ma Siva Kumar
Date:
Subject: PostgreSQL - regularly sync.ing remote and local data