Re: Measuring relation free space

On 07/11/11 10:20, Bernd Helmle wrote: <blockquote cite="mid:40A2936D14C5D6398B14DA83@apophis.local" type="cite"><br
/><br/> --On 6. November 2011 01:08:11 -0200 Greg Smith <a class="moz-txt-link-rfc2396E"
href="mailto:greg@2ndQuadrant.com"><greg@2ndQuadrant.com></a>wrote: <br /><br /><blockquote type="cite">Attached
patchadds a new function to the pageinspect extension for measuring <br /> total free space, in either tables or
indexes.<br /></blockquote><br /> I wonder if that should be done in the pgstattuple module, which output some similar
numbers.<br /><br /></blockquote><font size="-1"><font face="Helvetica"><br /> Not meaning to disparage Greg's effort
inany way, but I was thinking the same thing about pg_freespacemap. I have not checked what - if any differences there
arein output, but it would be interesting to compare which of the various (3 at present) extensions with slightly
overlappingareas of functionality should perhaps be merged.<br /><br /> I am guessing (at this point very much
guessing)that pg_freespace map may return its data faster, as pageinspect is gonna have to grovel through all the pages
foritself (whereas pg_freespacemap relies on using info from the ... free space map fork).<br /><br /> regards<br /><br
/>Mark<br /><br /><br /></font></font>