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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: troy(at)frericks(dot)us, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: I came here to determine how much storage a boolean variable uses
Date: 2021-08-30 15:31:04
Message-ID: CAKFQuwbjzdq6X0LSPva6GS2PYiBchDdr-bJeOXyuWb87j+7uLw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Sun, Aug 29, 2021 at 11:59 PM PG Doc comments form <
noreply(at)postgresql(dot)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.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Jonathan S. Katz 2021-08-30 16:16:13 Re: I came here to determine how much storage a boolean variable uses
Previous Message David G. Johnston 2021-08-30 15:21:59 Re: Wrong note in the information schema section?