↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / OID Types

xid8

Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 67.1 for more details.

Reading PG 18·Select a recorded version

Definition PG 18

Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 67.1 for more details.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38

Text language: en · 8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38