Re: pg_freespacemap question

Tom Lane wrote:
> Tatsuo Ishii <ishii@sraoss.co.jp> writes:
> 
>>>Peter Eisentraut wrote:
>>>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.
> 
> 
> Right, which is correct because free space is associated with physical
> files not logical relations.  (TRUNCATE, CLUSTER, etc will completely
> change the freespace situation for a rel, but they don't change its OID.)
> 
> I do agree with the comment that the column order seems nonintuitive;
> I'd expect database/tablespace/relfilenode/blocknumber, or possibly
> tablespace first.  The names used for the columns could do with
> reconsideration.  And I don't see the point of the blockid column at
> all.

Tom - agreed, I'll look at making these changes too!

Cheers

Mark