pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedI came here to determine how much storage a boolean variable uses
4+ messages / 4 participants
[nested] [flat]
* I came here to determine how much storage a boolean variable uses
@ 2021-08-30 00:20 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: PG Doc comments form @ 2021-08-30 00:20 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: troy@frericks.us
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. Maybe a note about the amount of space in the
row that a NULL column uses vs a NOT NULL.
Troy.
#
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: I came here to determine how much storage a boolean variable uses
@ 2021-08-30 15:31 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: David G. Johnston @ 2021-08-30 15:31 UTC (permalink / raw)
To: troy@frericks.us, Pg Docs <pgsql-docs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: I came here to determine how much storage a boolean variable uses
@ 2021-08-30 16:16 Jonathan S. Katz <jkatz@postgresql.org>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Jonathan S. Katz @ 2021-08-30 16:16 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; troy@frericks.us, Pg Docs <pgsql-docs@lists.postgresql.org>
On 8/30/21 11:31 AM, David G. Johnston wrote:
> On Sun, Aug 29, 2021 at 11:59 PM PG Doc comments form
> <noreply@postgresql.org <mailto:noreply@postgresql.org>> wrote:
>
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/13/datatype.html
> <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
> <https://www.postgresql.org/docs/current/storage-page-layout.html#STORAGE-TUPLE-LAYOUT;
Well, it is provided one level deeper in the data type docs, e.g.:
https://www.postgresql.org/docs/13/datatype-boolean.html
I think it's a reasonable request to consider. It potentially duplicates
the info in the data types section (i.e. one more thing to maintain),
but it does provide some convenience for scanning it across the
consolidated table.
Jonathan
Attachments:
[application/pgp-signature] OpenPGP_signature (839B, ../../b5b0eb00-ec60-6c25-b465-67ac2603101e@postgresql.org/2-OpenPGP_signature)
download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: I came here to determine how much storage a boolean variable uses
@ 2021-09-01 19:49 Bruce Momjian <bruce@momjian.us>
parent: Jonathan S. Katz <jkatz@postgresql.org>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2021-09-01 19:49 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; troy@frericks.us, Pg Docs <pgsql-docs@lists.postgresql.org>
On Mon, Aug 30, 2021 at 12:16:13PM -0400, Jonathan Katz wrote:
> > https://www.postgresql.org/docs/current/storage-page-layout.html#STORAGE-TUPLE-LAYOUT
> > <https://www.postgresql.org/docs/current/storage-page-layout.html#STORAGE-TUPLE-LAYOUT;
>
> Well, it is provided one level deeper in the data type docs, e.g.:
>
> https://www.postgresql.org/docs/13/datatype-boolean.html
>
> I think it's a reasonable request to consider. It potentially duplicates
> the info in the data types section (i.e. one more thing to maintain),
> but it does provide some convenience for scanning it across the
> consolidated table.
FYI, I usually use psql's \dTS+.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2021-09-01 19:49 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-08-30 00:20 I came here to determine how much storage a boolean variable uses PG Doc comments form <noreply@postgresql.org>
2021-08-30 15:31 ` David G. Johnston <david.g.johnston@gmail.com>
2021-08-30 16:16 ` Jonathan S. Katz <jkatz@postgresql.org>
2021-09-01 19:49 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox