Re: How are postgreSQL database files structured?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How are postgreSQL database files structured?
Дата
Msg-id 6424.1038072424@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How are postgreSQL database files structured?  (Oliver Elphick <olly@lfix.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Hugh Esco
Дата:
Сообщение: Re: Troubles at Startup
Следующее
От: Chris Bowlby
Дата:
Сообщение: Re: Inquiry From Form [pgsql]