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

Поиск
Список
Период
Сортировка
От Soroosh Sardari
Тема Re: Which table stored in which file in PGDATA/base/[db-oid]
Дата
Msg-id CAFUsPDZyZhDhTTZRKM0xUpk-rgta3b-DLLWG_RiFb2bPZ4T2dA@mail.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]
Список pgsql-hackers
<div dir="ltr"><br /><div class="gmail_extra">Yes, I have some files which is not in pg_class.relfilenode of any table
orindex.<br /></div><div class="gmail_extra">I want to know which table or index stored in such files.<br /></div><div
class="gmail_extra"><br/><div class="gmail_quote"><br /><blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1pxsolid rgb(204,204,204);padding-left:1ex"><div class=""><div class="h5"><br /></div></div>From that
page:<br/><br /> Each table and index is stored in a separate file. For ordinary<br /> relations, these files are named
afterthe table or index's filenode<br /> number, which can be found in pg_class.relfilenode.<br /><br /> Have a nice
day,<br/><span class=""><font color="#888888">--<br /> Martijn van Oosterhout   <<a
href="mailto:kleptog@svana.org">kleptog@svana.org</a>>  <a href="http://svana.org/kleptog/"
target="_blank">http://svana.org/kleptog/</a><br/> > He who writes carelessly confesses thereby at the very outset
thathe does<br /> > not attach much importance to his own thoughts.<br />    -- Arthur Schopenhauer<br
/></font></span><br/>-----BEGIN PGP SIGNATURE-----<br /> Version: GnuPG v1.4.10 (GNU/Linux)<br /><br />
iQIVAwUBUanSAkvt++dL5i1EAQhn6hAAg9eiZEz2eV6Z/5f8ae56MNGwM5L1P6nU<br/>
y2pN49PoSz0FkO3lBwcShH3/O0s+SgNy8kh6Klm1qDlwvX9HFGeRVd9guX7/fFil<br/>
eu+Ueg5nVzXA4fb/NwjS+Hh1B+/NdJQnklddP6K4Pm0VW51wqaaFA3hn/CfNMiO2<br/>
07i8L/NFjlngc5wstQLGcxuE5bl69c1qGhl8RHoOPLRhFgMSzkxSR9TglTDPaniu<br/>
rptpWvHgfRYdorANBaSI3SByw8WeSPbrTHusX4XC5zVkIk7GZQiogQlQVRA7yBT6<br/>
YpdjqB4thWDctR4VLv0yvBRJ5g7M9GkhWSOmpDoRBWCB2EFFPwrBhyrxt/e/aPCn<br/>
+Nt1nFxtKGV4/tPW7cI9b4bv2OZctmOaoDByqAZUuB891eOebVjif9MsQeG5IWFb<br/>
5KOnQcQ+TxlmCkF7zot5Tv8ndMTtJN8eKAkhay+xmLjON/2tGl+ArKbVAqck2oIb<br/>
xGSavSLg6HZ/FmMNkbHVSo6/Z7Nmup2GGYsWWJhHvoO0hbGHCnxobAsWQGPUsC7l<br/>
6osFCcBokvZtIERLttznP1S8RvmLP6EuByxNNQY4MV1GJm55P1PHZeWRGCYMEDil<br/>
Fs73My0YxHBtnjI/LbgJ4GhKzINsQqviHJPFraKq8NdW/+B3Pte6bmtlRFa8Z/t+<br/> J6hjI9Wgky0=<br /> =68cp<br /> -----END PGP
SIGNATURE-----<br/><br /></blockquote></div><br /></div></div> 

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

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