Re: Measuring relation free space

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Measuring relation free space
Дата
Msg-id 4EB764D4.8040702@catalyst.net.nz
обсуждение исходный текст
Ответ на Re: Measuring relation free space  (Bernd Helmle <mailings@oopsware.de>)
Ответы Re: Measuring relation free space  (Greg Smith <greg@2ndQuadrant.com>)
Список pgsql-hackers
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> 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: J Smith
Дата:
Сообщение: Re: unaccent extension missing some accents
Следующее
От: Jan Kundrát
Дата:
Сообщение: [patch] Include detailed information about a row failing a CHECK constraint into the error message