what's hsitoric MVCC Snapshot?

From: "jacktby(at)gmail(dot)com" <jacktby(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: what's hsitoric MVCC Snapshot?
Date: 2023-03-05 14:49:13
Message-ID: 202303052249108283258@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-03-05 15:58:47 Re: what's hsitoric MVCC Snapshot?
Previous Message David G. Johnston 2023-03-05 05:15:32 Re: psql \set variables in crosstab queries?