Postgres MVCC
Transaction id
Every Postgres transaction has an integer transaction id.
- 4-byte unsigned integer, (~4 billion values).
- The values wrap around.
- The next 2 billion transaction ids are in the future.
- The previous 2 billion transaction ids are in the past.
|