Re: Which table stored in which file in PGDATA/base/[db-oid]

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: Which table stored in which file in PGDATA/base/[db-oid]
Дата
Msg-id CAGnEbogGUo-w1iyqK_2LYxQjfz61FRTZ8qF=K_kWddcROvn7sg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Which table stored in which file in PGDATA/base/[db-oid]  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-hackers
Дерево обсуждения
2013/6/1 Martijn van Oosterhout <kleptog@svana.org>
On Sat, Jun 01, 2013 at 03:27:40PM +0430, Soroosh Sardari wrote:
> Yes, I have some files which is not in pg_class.relfilenode of any table or
> index.
> I want to know which table or index stored in such files.

That shouldn't happen. Are you sure you're looking in the right
database? Kan you list the filenames?

According to the docs, it is possible if there had been
operations on the table that change filenode, like TRUNCATE.
Also, some some relations has relfilenode being 0, like pg_class catalogue table.

Check more here:
http://www.postgresql.org/docs/current/interactive/storage-file-layout.html

It is recommended to use pg_relation_filenode() function:
http://www.postgresql.org/docs/current/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBLOCATION


--
Victor Y. Yegorov

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Which table stored in which file in PGDATA/base/[db-oid]
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Which table stored in which file in PGDATA/base/[db-oid]