Re: Tablespace OID, database OID, relfilenode

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Tablespace OID, database OID, relfilenode
Дата
Msg-id 72d26e5f-0b07-a153-14ab-d2795b108f71@aklaver.com
обсуждение исходный текст
Ответ на Re: Tablespace OID, database OID, relfilenode  (Wiwwo Staff <wiwwo@wiwwo.com>)
Список pgsql-general
On 1/17/23 11:49, Wiwwo Staff wrote:
> Thank you Adrian, thank you David!
> So, it turns out, it *is* indeed an arbitrary constant...
> I have been answered many times RTFM, it is actually the first time I 
> have being answered RTF source code.
> (I searched for 1663 in PG docs, it is there, although not really 
> "intuitive").
> 
> Allow me to humbly propose to maybe at least write somewhere in the DOCs 
> in a clear way: "This is a number you should know, and it is arbitrary, 
> and in some functions it will be represented as 'base'  ".
> It is fundamental to know this when one uses pg_waldump, for example.
> 
> Not to start a flame war here, just humbly proposing...

https://www.postgresql.org/docs/current/storage-file-layout.html

"The pg_default tablespace is not accessed through pg_tblspc, but 
corresponds to PGDATA/base. Similarly, the pg_global tablespace is not 
accessed through pg_tblspc, but corresponds to PGDATA/global."

> 
> Thanks all again!
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




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

Предыдущее
От: Ron
Дата:
Сообщение: Re: Maintaining blank lines in psql output?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?