From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_freespacemap question |
Date: | 2006-03-07 14:37:51 |
Message-ID: | 20060307143751.GF4307@surnet.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-07 14:54:33 | Re: FW: PGBuildfarm member snake Branch HEAD Status changed from OK to PLCheck failure |
Previous Message | Peter Eisentraut | 2006-03-07 14:29:58 | Re: pg_freespacemap question |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-07 14:46:17 | Re: CREATE SYNONYM ... |
Previous Message | Peter Eisentraut | 2006-03-07 14:29:58 | Re: pg_freespacemap question |