snapshot question - Mailing list pgsql-general

From qihua wu
Subject snapshot question
Date
Msg-id CAPoYto+ouSQoXmLEaXh0VdVV8Y1w54FDcsR4CcE-vBX8Zbgc2A@mail.gmail.com
Whole thread Raw
Responses Re: snapshot question  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
To get a snapshot we need to know xmin, xmax and xip. my question is why do we need them? Since every tuple in a page has t_xmin and t_xmax based on the page layout(https://www.postgresql.org/docs/current/storage-page-layout.html), if we has a snapshot at xip 12345, couldn't we just check every tuple whose t_xmin is lower than 12345 and already committed?

Thanks,
Qihua

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re[2]: PG 14.5 -- Impossible to restore dump due to interaction/order of views, functions, and generated columns
Next
From: Bruce Momjian
Date:
Subject: Re: snapshot question