MIME-Version: 1.0
Date: Fri, 10 Jan 2025 22:04:51 +0700
From: Vladlen Popolitov <v.popolitov@postgrespro.ru>
To: Dominique Devienne <ddevienne@gmail.com>
Cc: Igor Korot <ikorot01@gmail.com>, Christophe Pettus <xof@thebuild.com>,
 "David G. Johnston" <david.g.johnston@gmail.com>, Ron Johnson
 <ronljohnsonjr@gmail.com>, "pgsql-generallists.postgresql.org"
 <pgsql-general@lists.postgresql.org>
Subject: Re: Postgres do not support tinyint?
In-Reply-To: <CAFCRh-87K0kLsXFSYeTj1xZvG-maq0qv4eRVt5iMs2j-6LNBMQ@mail.gmail.com>
References: <CA+FnnTzfvgVdptHcLBFPrq_Q+xPes-Bhjiw_xFiooq4VqhqyrQ@mail.gmail.com>
 <CANzqJaCxZK0j8fL-riZpX+AV+kyo9PcAvgF=H5DgaWK+C+66Vw@mail.gmail.com>
 <CAKFQuwYYgPxUSvo2UzOty5Cd1xw5+2q1bg3+zY-nsXNZyq+_4g@mail.gmail.com>
 <11AA76D0-CAFE-4A17-BCCF-50520CCDF47F@thebuild.com>
 <CA+FnnTxf3VxTPzGFy7q-6ENVcV769F_5_=nbGOvK40qua8XPgg@mail.gmail.com>
 <051EB6AC-2395-4EAD-B30C-069FBC01107F@thebuild.com>
 <CA+FnnTyxnWjjaC4dDo6Y4DeCYAVa3dgGdsMg3sdTOFiyHAG7Ag@mail.gmail.com>
 <59d067bdcf17bd5a624eb7c736779853@postgrespro.ru>
 <CAFCRh-87K0kLsXFSYeTj1xZvG-maq0qv4eRVt5iMs2j-6LNBMQ@mail.gmail.com>
Message-ID: <81bde2a02f6fee0bab8253a3118e19ad@postgrespro.ru>
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/81bde2a02f6fee0bab8253a3118e19ad%40postgrespro.ru>
Precedence: bulk

Dominique Devienne писал(а) 2025-01-10 16:41:
> On Fri, Jan 10, 2025 at 10:13 AM Vladlen Popolitov
> <v.popolitov@postgrespro.ru> wrote:
>> If you really need 1-byte integer, you can use "char" type. Cast it
>> to/from int. See comment at the end of the page
>> https://www.postgresql.org/docs/17/datatype-character.html
> 
> Hi. What would be the best online doc to learn about the physical
> storage / format for rows/pages/btree, etc... To understand alignment,
> packing, varint or not, all those things. I'm quite familiar with the
> [SQLite format][1], having read that doc dozens of times, and I'd like
> a better low-level understanding for PostgreSQL as well. TIA, --DD
> 
> [1]: https://www.sqlite.org/fileformat.html

I would recommend "PostgreSQL Internals" of Egor Rogov (Chapter 3 about 
tuples,
other chapters also great)
Free download from https://postgrespro.com/community/books/internals

Also PostgreSQL source code is officially the part of the documentation.
It is not joke. PostgreSQL source has clear comments in functions code
and in structure declarations. You can compare with other sources, it is 
hard to find better
comments made with love.

Heap tuple information is in source file 
src/include/access/htup_details.h (HeapTupleHeaderData
structure), but I recommend to read above book first, it simplier 
explains many
internal concepts.
-- 
Best regards,

Vladlen Popolitov.