Home > mailing lists

Which table stored in which file in PGDATA/base/[db-oid] - Mailing list pgsql-hackers

From	Soroosh Sardari
Subject	Which table stored in which file in PGDATA/base/[db-oid]
Date	June 1, 2013 10:42:15
Msg-id	CAFUsPDYVEX8HunpgByN8xrO3QCtXoXHz6jiKiUKZdKTo=UksZg@mail.gmail.com Whole thread Raw
Responses	Re: Which table stored in which file in PGDATA/base/[db-oid]
List	pgsql-hackers

Dear Hackers

I've created a new DB, and a bunch of files created in base/12054, 12054 is oid of the new DB.

I want to find what table stored in each file.

I have 156 files with numerical names, vm and fsm file are ignored.

107 files are same as pg_class.reltoastrelid,so I have 49 files that I do not know what tables stored in them.

Any idea to find ?

Thanks,

Soroosh

From: Christoph Moench-Tegeder
Date: 01 June 2013, 09:43:46
Subject: Re: detecting binary backup in progress

From: Martijn van Oosterhout
Date: 01 June 2013, 10:50:49
Subject: Re: Which table stored in which file in PGDATA/base/[db-oid]