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