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

From Soroosh Sardari
Subject Re: Which table stored in which file in PGDATA/base/[db-oid]
Date
Msg-id CAFUsPDZyZhDhTTZRKM0xUpk-rgta3b-DLLWG_RiFb2bPZ4T2dA@mail.gmail.com
Whole thread Raw
In response to Re: Which table stored in which file in PGDATA/base/[db-oid]  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Which table stored in which file in PGDATA/base/[db-oid]
List pgsql-hackers

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.



From that page:

Each table and index is stored in a separate file. For ordinary
relations, these files are named after the table or index's filenode
number, which can be found in pg_class.relfilenode.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
   -- Arthur Schopenhauer

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iQIVAwUBUanSAkvt++dL5i1EAQhn6hAAg9eiZEz2eV6Z/5f8ae56MNGwM5L1P6nU
y2pN49PoSz0FkO3lBwcShH3/O0s+SgNy8kh6Klm1qDlwvX9HFGeRVd9guX7/fFil
eu+Ueg5nVzXA4fb/NwjS+Hh1B+/NdJQnklddP6K4Pm0VW51wqaaFA3hn/CfNMiO2
07i8L/NFjlngc5wstQLGcxuE5bl69c1qGhl8RHoOPLRhFgMSzkxSR9TglTDPaniu
rptpWvHgfRYdorANBaSI3SByw8WeSPbrTHusX4XC5zVkIk7GZQiogQlQVRA7yBT6
YpdjqB4thWDctR4VLv0yvBRJ5g7M9GkhWSOmpDoRBWCB2EFFPwrBhyrxt/e/aPCn
+Nt1nFxtKGV4/tPW7cI9b4bv2OZctmOaoDByqAZUuB891eOebVjif9MsQeG5IWFb
5KOnQcQ+TxlmCkF7zot5Tv8ndMTtJN8eKAkhay+xmLjON/2tGl+ArKbVAqck2oIb
xGSavSLg6HZ/FmMNkbHVSo6/Z7Nmup2GGYsWWJhHvoO0hbGHCnxobAsWQGPUsC7l
6osFCcBokvZtIERLttznP1S8RvmLP6EuByxNNQY4MV1GJm55P1PHZeWRGCYMEDil
Fs73My0YxHBtnjI/LbgJ4GhKzINsQqviHJPFraKq8NdW/+B3Pte6bmtlRFa8Z/t+
J6hjI9Wgky0=
=68cp
-----END PGP SIGNATURE-----


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Which table stored in which file in PGDATA/base/[db-oid]
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Which table stored in which file in PGDATA/base/[db-oid]