Re: Tupple statistics function - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Tupple statistics function
Date
Msg-id 13203.1001135198@sss.pgh.pa.us
Whole thread Raw
In response to Tupple statistics function  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: Tupple statistics function  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Tupple statistics function  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> I have written a small function that show how many tuples are dead
> etc. in a specified table.

Dead according to whose viewpoint?  Under MVCC this seems to be
in the eye of the beholder...

> Shall I add this function into contrib directory?

No real objection, but you should carefully document exactly what
the results mean.

BTW, I'd suggest accounting for free, reusable space separately from
"overhead".
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Tupple statistics function
Next
From: Bruce Momjian
Date:
Subject: Re: Tupple statistics function