Re: pg_freespacemap question

Mark Kirkwood <markir@paradise.net.nz>

From: Mark Kirkwood <markir@paradise.net.nz>
To: Tatsuo Ishii <ishii@sraoss.co.jp>
Cc: alvherre@commandprompt.com, peter_e@gmx.net, pgsql-hackers@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2006-03-08T04:47:50Z
Lists: 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