Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mLWF9-0004xN-Sm for pgsql-docs@arkaria.postgresql.org; Wed, 01 Sep 2021 19:49:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mLWF8-0007oZ-9a for pgsql-docs@arkaria.postgresql.org; Wed, 01 Sep 2021 19:49:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mLWF8-0007kS-3R for pgsql-docs@lists.postgresql.org; Wed, 01 Sep 2021 19:49:54 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mLWF1-0000nX-Pr; Wed, 01 Sep 2021 19:49:53 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1mLWF0-0002ti-HJ; Wed, 01 Sep 2021 15:49:46 -0400 Date: Wed, 1 Sep 2021 15:49:46 -0400 From: Bruce Momjian To: "Jonathan S. Katz" Cc: "David G. Johnston" , troy@frericks.us, Pg Docs Subject: Re: I came here to determine how much storage a boolean variable uses Message-ID: <20210901194946.GA24833@momjian.us> References: <163028282061.699.18102158472748913223@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 > > > > 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 https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.