Radim Marek: Row locks at the page level

T2Covered by 1 source · first reported by Planet PostgreSQL at 17 Sept, 05:00 UTC

In PostgreSQL, every tuple starts with 23-byte header, and the first eight bytes are two transaction IDs. t_xmin for the transaction that created the row and t_xmax for the one that deleted or updated it. That is the visibility story covered in PostgreSQL MVCC, Byte by Byte. For now we have…

cloud

Sources

• T2Radim Marek: Row locks at the page levelPlanet PostgreSQL17 Sept, 05:00