[HACKERS] pgstattuple documentation clarification
От
Andrew Dunstan
Тема
[HACKERS] pgstattuple documentation clarification
Дата
Msg-id
57de30e7-5aa2-df7d-6db3-fdfbd0fda05b@dunslane.net
Список
Дерево обсуждения
[HACKERS] pgstattuple documentation clarification Andrew Dunstan <andrew@dunslane.net>
Re: [HACKERS] pgstattuple documentation clarification Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pgstattuple documentation clarification Andrew Dunstan <andrew@dunslane.net>
Re: [HACKERS] pgstattuple documentation clarification Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pgstattuple documentation clarification Andrew Dunstan <andrew@dunslane.net>
Re: [HACKERS] pgstattuple documentation clarification Andrew Dunstan <andrew@dunslane.net>
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 is accounted 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 по дате отправления