Re: AW: how long should Archive logs be retained - Mailing list pgsql-novice

On Fri, 2025-11-28 at 05:28 +0000, Subramanian,Ramachandran wrote:
> Each transaction has it's own private copy of the data it is interested in,
> and each private copy of the data has it's unique transaction number associated
> with it.

A snapshot is not a copy of the data.  It is the list of transaction IDs that
are visible and the ones that are not.  That snapshot determines which of the
data in the database you can see.

Yours,
Laurenz Albe