8.20. pg_lsn Type

8.20. pg_lsn Type

8.20.pg_lsn类型

The pg_lsn data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the WAL. This type is a representation of XLogRecPtr and an internal system type of PostgreSQL.

pg_lsn数据类型可用于存储LSN（日志序列号）数据，该数据是指向WAL中某个位置的指针。 此类型表示XLogRecPtr和PostgreSQL的内部系统类型。

 

Internally, an LSN is a 64-bit integer, representing a byte position in the write-ahead log stream. It is printed as two hexadecimal numbers of up to 8 digits each, separated by a slash; for example, 16/B374D848. The pg_lsn type supports the standard comparison operators, like = and >. Two LSNs can be subtracted using the - operator; the result is the number of bytes separating those write-ahead log locations.

在内部，LSN是64位整数，代表预写日志流中的字节位置。 它以两个十六进制数字（每个数字最多8位）打印，并用斜杠分隔； 例如16/B374D848。 pg_lsn类型支持标准比较运算符，例如=和>。 可以使用-运算符计算两个LSN的差； 结果是分隔这些预写日志位置的字节数。