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)
Список
Дерево обсуждения
Which table stored in which file in PGDATA/base/[db-oid] Soroosh Sardari <soroosh.sardari@gmail.com>
Re: Which table stored in which file in
PGDATA/base/[db-oid] Martijn van Oosterhout <kleptog@svana.org>
Re: Which table stored in which file in PGDATA/base/[db-oid] Soroosh Sardari <soroosh.sardari@gmail.com>
Re: Which table stored in which file in
PGDATA/base/[db-oid] Martijn van Oosterhout <kleptog@svana.org>
Re: Which table stored in which file in
PGDATA/base/[db-oid] Andres Freund <andres@2ndquadrant.com>
Re: Which table stored in which file in PGDATA/base/[db-oid] Soroosh Sardari <soroosh.sardari@gmail.com>
Re: Which table stored in which file in PGDATA/base/[db-oid] David Kerr <dmk@mr-paradox.net>
Re: Which table stored in which file in PGDATA/base/[db-oid] Soroosh Sardari <soroosh.sardari@gmail.com>
Re: Which table stored in which file in PGDATA/base/[db-oid] Victor Yegorov <vyegorov@gmail.com>
2013/6/1 Martijn van Oosterhout <kleptog@svana.org>
--
Victor Y. Yegorov
On Sat, Jun 01, 2013 at 03:27:40PM +0430, Soroosh Sardari wrote:That shouldn't happen. Are you sure you're looking in the right
> 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.
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:
It is recommended to use pg_relation_filenode() function:
Victor Y. Yegorov
В списке pgsql-hackers по дате отправления
От: Martijn van Oosterhout
Дата:
От: Andres Freund
Дата:
