Re: Tupple statistics function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tupple statistics function
Date: 2001-09-22 05:06:38
Message-ID: 13203.1001135198@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-09-22 05:26:02 Re: Tupple statistics function
Previous Message Bruce Momjian 2001-09-22 04:58:41 Re: Tupple statistics function

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-09-22 05:26:02 Re: Tupple statistics function
Previous Message Bruce Momjian 2001-09-22 04:58:41 Re: Tupple statistics function