Re: Are we really using 23 bytes on most machines?

From: "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com>
To: Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>
Cc: "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Are we really using 23 bytes on most machines?
Date: 2022-09-20 13:49:09
Message-ID: GV0P278MB0419E576B4007AFA9E6CB50CD24C9@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Thank you

Send from my Mobile
________________________________
From: Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>
Sent: Tuesday, September 20, 2022 3:48:02 PM
To: Daniel Westermann (DWE) <daniel(dot)westermann(at)dbi-services(dot)com>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Are we really using 23 bytes on most machines?

On Tue, 20 Sept 2022 at 13:24, Daniel Westermann (DWE)
<daniel(dot)westermann(at)dbi-services(dot)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/

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2022-09-20 18:32:46 Extension-specific version release notes?
Previous Message Simon Riggs 2022-09-20 13:48:02 Re: Are we really using 23 bytes on most machines?