Re: Defn of pg_class.reltuples in 7.2.1?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ed Loehr <pggeneral(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Defn of pg_class.reltuples in 7.2.1?
Date: 2002-04-13 16:34:04
Message-ID: 16118.1018715644@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ed Loehr <pggeneral(at)bluepolka(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ma Siva Kumar 2002-04-13 17:10:19 PostgreSQL - regularly sync.ing remote and local data
Previous Message Tom Lane 2002-04-13 16:28:22 Re: A *short* planner question