Horton
Menu

Re: pg_freespacemap question

Tatsuo Ishii <ishii@sraoss.co.jp>

View thread
From: Tatsuo Ishii <ishii@sraoss.co.jp>
To: markir@paradise.net.nz
Cc: ishii@sraoss.co.jp, alvherre@commandprompt.com, peter_e@gmx.net, pgsql-hackers@postgresql.org, tgl@sss.pgh.pa.us
Date: 2006-03-07T23:42:13Z
Lists: pgsql-hackers 
> > 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.

Just for curiousity, why FSM gathers info for indexes? I thought FSM
is only good for tables.
--
Tatsuo Ishii
SRA OSS, Inc. Japan