Re: pg_freespacemap question

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: pg_freespacemap question
Дата
Msg-id 440E61F6.6020205@paradise.net.nz
обсуждение исходный текст
Ответ на Re: pg_freespacemap question  (Mark Kirkwood <markir@paradise.net.nz>)
Ответы Re: pg_freespacemap question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Mark Kirkwood wrote:
> Tatsuo Ishii wrote:
>
>> BTW, I found the answer to my question myself by reading the source
>> code: if that's an index, then blockfreebytes is explicitly set to 0.
>> I suggest that this should be noted in the README and in this case
>> blockfreebytes is better to set to NULL, rather than 0.
>>
> 
> Good points! I had not noticed this test case. Probably NULL is better 
> than zero.
>

Would setting it to 'BLCKSZ - (fixed index header stuff)' be better, 
since the btree page is empty? (I'll have to read up on how to calculate 
the header stuff!).

regards

Mark




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

Предыдущее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Merge algorithms for large numbers of "tapes"
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Merge algorithms for large numbers of "tapes"