[HACKERS] pgstattuple documentation clarification - Mailing list pgsql-hackers

From Andrew Dunstan
Subject [HACKERS] pgstattuple documentation clarification
Date
Msg-id 57de30e7-5aa2-df7d-6db3-fdfbd0fda05b@dunslane.net
Whole thread Raw
Responses Re: [HACKERS] pgstattuple documentation clarification  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Recently a client was confused because there was a substantial 
difference between the reported table_len of a table and the sum of the 
corresponding tuple_len, dead_tuple_len and free_space. The docs are 
fairly silent on this point, and I agree that in the absence of 
explanation it is confusing, so I propose that we add a clarification 
note along the lines of:

   The table_len will always be greater than the sum of the tuple_len,   dead_tuple_len and free_space. The difference
isaccounted for by   page overhead and space that is not free but cannot be attributed to   any particular tuple.
 


Or perhaps we should be more explicit and refer to the item pointers on 
the page.


Thoughts?


cheers


andrew




pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS] Hash Indexes
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Time to drop old-style (V0) functions?