what's hsitoric MVCC Snapshot? - Mailing list pgsql-general

From jacktby@gmail.com
Subject what's hsitoric MVCC Snapshot?
Date
Msg-id 202303052249108283258@gmail.com
Whole thread Raw
Responses Re: what's hsitoric MVCC Snapshot?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Here are the comments in src/include/utils/snapshot.h.
        /*
* For normal MVCC snapshot this contains the all xact IDs that are in
* progress, unless the snapshot was taken during recovery in which case
* it's empty. For historic MVCC snapshots, the meaning is inverted, i.e.
* it contains *committed* transactions between xmin and xmax.
*
* note: all ids in xip[] satisfy xmin <= xip[i] < xmax
*/
TransactionId *xip;
I can't understand the historic MVCC snapshots? can you give me a scenario
to describe this?

jacktby@gmail.com

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: psql \set variables in crosstab queries?
Next
From: Adrian Klaver
Date:
Subject: Re: what's hsitoric MVCC Snapshot?