> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > ... Maybe he has coded that in there.
>
> Maybe so, but he didn't say. That's why I was asking for exact
> documentation.
As you can see from the source code, it just use
HeapTupleSatisfiesNow(). I wrote this function for the admin
use. He/she sho
> Tatsuo Ishii <[EMAIL PROTECTED]> 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 direct
Bruce Momjian <[EMAIL PROTECTED]> writes:
> ... Maybe he has coded that in there.
Maybe so, but he didn't say. That's why I was asking for exact
documentation.
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/r
> Tatsuo Ishii <[EMAIL PROTECTED]> 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...
You can know if the tuple is visible to other backe
Tatsuo Ishii <[EMAIL PROTECTED]> 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 ob
> Hi,
>
> I have written a small function that show how many tuples are dead
> etc. in a specified table. Example output is:
>
> test=# select pgstattuple('tellers');
> NOTICE: physical length: 0.02MB live tuples: 200 (0.01MB, 58.59%) dead tuples: 100
>(0.00MB, 29.30%) overhead: 12.11%
> pgst
Hi,
I have written a small function that show how many tuples are dead
etc. in a specified table. Example output is:
test=# select pgstattuple('tellers');
NOTICE: physical length: 0.02MB live tuples: 200 (0.01MB, 58.59%) dead tuples: 100
(0.00MB, 29.30%) overhead: 12.11%
pgstattuple