pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jonathan S. Katz <jkatz@postgresql.org>
To: David G. Johnston <david.g.johnston@gmail.com>
To: troy@frericks.us, Pg Docs <pgsql-docs@lists.postgresql.org>
Subject: Re: I came here to determine how much storage a boolean variable uses
Date: Mon, 30 Aug 2021 12:16:13 -0400
Message-ID: <b5b0eb00-ec60-6c25-b465-67ac2603101e@postgresql.org> (raw)
In-Reply-To: <CAKFQuwbjzdq6X0LSPva6GS2PYiBchDdr-bJeOXyuWb87j+7uLw@mail.gmail.com>
References: <163028282061.699.18102158472748913223@wrigleys.postgresql.org>
	<CAKFQuwbjzdq6X0LSPva6GS2PYiBchDdr-bJeOXyuWb87j+7uLw@mail.gmail.com>

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

view thread (4+ messages)  latest in thread

Message-ID: <b5b0eb00-ec60-6c25-b465-67ac2603101e@postgresql.org>
Permalink:  ../b5b0eb00-ec60-6c25-b465-67ac2603101e@postgresql.org/
Also on:    postgresql.org/message-id/b5b0eb00-ec60-6c25-b465-67ac2603101e@postgresql.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: jkatz@postgresql.org, david.g.johnston@gmail.com, pgsql-docs@lists.postgresql.org
  Subject: Re: I came here to determine how much storage a boolean variable uses
  In-Reply-To: <b5b0eb00-ec60-6c25-b465-67ac2603101e@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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