public inbox for pgsql-novice@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Subramanian, Ramachandran <ramachandran.subramanian@alte-leipziger.de>
Cc: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Subject: Re: Trying to understand Tuple Header
Date: Sun, 03 May 2026 18:50:23 -0400
Message-ID: <97767.1777848623@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwbRKbjk4JPefgT6s64hN-i47a1nZO6O4j-+h48er6uyvw@mail.gmail.com>
References: <0f8e5544ae8a412bb637fcc3d15f8aaa@alte-leipziger.de>
<CAKFQuwawOYYR=Dfa3tWsKOd-baJ-hV7SKMj9FHiMnd9f-=vNAg@mail.gmail.com>
<b2202bde6eb145bb814806b5606d131a@alte-leipziger.de>
<CAKFQuwbRKbjk4JPefgT6s64hN-i47a1nZO6O4j-+h48er6uyvw@mail.gmail.com>
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Sun, May 3, 2026 at 12:25 PM Subramanian,Ramachandran <
> ramachandran.subramanian@alte-leipziger.de> wrote:
>> The binary value of t_infomask for both the tuples are identical, but they
>> produce different column values for xmin_commited, xmin_aborted …. in the
>> SQL !!!.
> You didn't re-check the infomask data after running the select query,
> instead assuming the bits didn't change. They did. SELECT is not a
> read-only operation, it participates in optimizations. Called "writing
> hint bits".
Well, it *might* update the hint bits, but it can only do that after
the tuple is visible to all live transactions. So it matters what
else is happening within the database. In any case, pg_xact is the
ultimate source of truth about whether a tuple is committed or not.
regards, tom lane
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-novice@postgresql.org
Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, ramachandran.subramanian@alte-leipziger.de, pgsql-novice@lists.postgresql.org
Subject: Re: Trying to understand Tuple Header
In-Reply-To: <97767.1777848623@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox