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.
And what is this "blockid" thing?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support