Defn of pg_class.reltuples in 7.2.1?

Started by Ed L.almost 24 years ago2 messagesgeneral
Jump to latest
#1Ed L.
pggeneral@bluepolka.net

Does pg_class.reltuples include "dead" tuples awaiting vacuuming?

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Ed L. (#1)
Re: Defn of pg_class.reltuples in 7.2.1?

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