Re: AW: Trying to understand Tuple Header

On Mon, 2026-05-04 at 04:04 +0000, Subramanian,Ramachandran wrote:
> So the next select to the table cross references the pg_xact file to check if hint bits
> need to be updated or not ?  How deep does the next select look into the pg_xact file ?
> For example if I roll back and never touch this table for 30  Minutes and I come back
> and do a second select…will it look back into 30 mins of history in pg_xact ?

Yes.  It has to, to maintain correctness.

If nobody ever looks at the row, eventually autovacuum will freeze it.  Any pg_xact
segment that only contains transactions older than the oldest unfrozen row will
get reclaimed.

Yours,
Laurenz Albe