Re: How are postgreSQL database files structured? - Mailing list pgsql-admin

From Tom Lane
Subject Re: How are postgreSQL database files structured?
Date
Msg-id 6424.1038072424@sss.pgh.pa.us
Whole thread Raw
In response to Re: How are postgreSQL database files structured?  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-admin
Oliver Elphick <olly@lfix.co.uk> writes:
> pg_class has a column, relfilenode, which almost invariably has the same
> value as the oid; I'm not sure whether, should they differ, the file
> would be named relfilenode or oid, though I would presume the former.

relfilenode is the thing to look at, not oid.  AFAIR, only REINDEX and
CLUSTER assign new relfilenodes at present, so relfilenode will often
match oid --- but you'll eventually regret it if you write code that
assumes that.

            regards, tom lane

pgsql-admin by date:

Previous
From: Hugh Esco
Date:
Subject: Re: Troubles at Startup
Next
From: Chris Bowlby
Date:
Subject: Re: Inquiry From Form [pgsql]