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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, 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-09-01 19:49:46
Message-ID: 20210901194946.GA24833@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2021-09-01 20:12:37 Re: Error in sql script
Previous Message Michael Paquier 2021-09-01 13:34:42 Re: Inaccurate usage of "which" instead of "that" in parallel.sgml