Re: I came here to determine how much storage a boolean variable uses

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: I came here to determine how much storage a boolean variable uses
Дата
Msg-id CAKFQuwbjzdq6X0LSPva6GS2PYiBchDdr-bJeOXyuWb87j+7uLw@mail.gmail.com
обсуждение исходный текст
Ответ на I came here to determine how much storage a boolean variable uses  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: I came here to determine how much storage a boolean variable uses  ("Jonathan S. Katz" <jkatz@postgresql.org>)
Список pgsql-docs
Дерево обсуждения
On Sun, Aug 29, 2021 at 11:59 PM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/datatype.html
Description:

I'd like to see a fourth column added to Table 8-1 that contains the size or
size range of the data type.

I would argue this is sufficiently provided by the pg_attribute catalog's attlen and attalign fields, as pointed to on the same page linked below.

Maybe a note about the amount of space in the
row that a NULL column uses vs a NOT NULL.


Implementation detail that is covered in the internals section:

https://www.postgresql.org/docs/current/storage-page-layout.html#STORAGE-TUPLE-LAYOUT

David J.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Wrong note in the information schema section?
Следующее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: I came here to determine how much storage a boolean variable uses