|< < 33 > >|

Postgres MVCC

Version information

Every row in Postgres has the following data:

  • xmin: The id of the transaction that created this row.

  • xmax: The id of the transaction that deleted this row. (0 if the row is not deleted.)

  • next ctid: The location of the version of the superceding version of the row.

|< < 33 > >|