Postgres Pro
Downloads
Home   >   mailing lists

Re: Are we really using 23 bytes on most machines? - Mailing list pgsql-docs

From Daniel Westermann (DWE)
Subject Re: Are we really using 23 bytes on most machines?
Date
Msg-id GV0P278MB0419E576B4007AFA9E6CB50CD24C9@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Are we really using 23 bytes on most machines?  (Simon Riggs <simon.riggs@enterprisedb.com>)
List pgsql-docs
Tree view
Thank you

Send from my Mobile
From: Simon Riggs <simon.riggs@enterprisedb.com>
Sent: Tuesday, September 20, 2022 3:48:02 PM
To: Daniel Westermann (DWE) <daniel.westermann@dbi-services.com>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: Are we really using 23 bytes on most machines?
 
On Tue, 20 Sept 2022 at 13:24, Daniel Westermann (DWE)
<daniel.westermann@dbi-services.com> wrote:
>
> Hi,
>
> https://www.postgresql.org/docs/current/storage-page-layout.html
> "(occupying 23 bytes on most machines)"
>
> Is this still true? At least on Linux it is 24 bytes:
>
> postgres=# select pg_column_size( row() );
>
>  pg_column_size
> ----------------
>
>              24

Yes, but it is MAXALIGNED, which is documented. So the value you see
is correct and matches the docs.

--
Simon Riggs                http://www.EnterpriseDB.com/

pgsql-docs by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Are we really using 23 bytes on most machines?
Next
From: PG Doc comments form
Date:
Subject: Extension-specific version release notes?