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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
