Re: pg_freespacemap question

> Peter Eisentraut wrote:
> > Am Dienstag, 7. März 2006 15:09 schrieb Tatsuo Ishii:
> > > test=# select * from pg_freespacemap where blockfreebytes = 0;
> > >  blockid | relfilenode | reltablespace | reldatabase | relblocknumber | blockfreebytes
> > > ---------+-------------+---------------+-------------+----------------+---------------- 
> > >       25 |        2619 |          1663 |       16403 |              0 |              0
> > >       63 |        2619 |          1663 |       16384 |             10 |              0
> > > (2 rows) 
> > 
> > I've never heard of this thing before but is this column order supposed to make sense?
> 
> I have another question -- why is the view showing relfilenode and
> reltablespace?  I imagine it should be showing the relation Oid instead.

I guess that's because FSM keeps those info, not relation oid.

> And what is this "blockid" thing?

from README.pg_freespacemap:

   blockid        |                      | Id, 1.. max_fsm_pages

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.
--
Tatsuo Ishii
SRA OSS, Inc. Japan