Re: snapshot question

2022-12-06 Thread Bruce Momjian
On Wed, Dec 7, 2022 at 10:20:09AM +0800, qihua wu wrote: > Per the following link: https://www.sobyte.net/post/2022-08/postgres-snapshot/ > 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 pag

snapshot question

2022-12-06 Thread qihua wu
Per the following link: https://www.sobyte.net/post/2022-08/postgres-snapshot/ 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-l