Re: relfilenode - Mailing list pgsql-hackers

From elein
Subject Re: relfilenode
Date
Msg-id 20051028014847.GE26501@varlena.com
Whole thread Raw
In response to relfilenode  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On Thu, Oct 27, 2005 at 09:12:15PM -0400, Andrew Dunstan wrote:
> 
> The docs have this description for pg_class::relfilenode: "Name of the 
> on-disk file of this relation; 0 if none". However, Elein just pointed 
> out to me that there are no entries with 0, so this description seems 
> incorrect. What should we say? It appears that in at least some of these 
> cases the value is the same as the oid.
> 
> cheers
> 
> andrew
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
> 

I found that in my test db only pg_xactlock has a relfilenode == 0.
The sequences, tables and primary keys seem to have files in 
PGDATA/base/* which correspond to the relfilenode.
However, views seem to have an oid I cannot correlate to anything.

So we need to say what 0 means and what the oid is for the views.

--elein
elein@varlena.com


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: enums
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: SOLVED Re: _penalty gist method invoked with one key