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