One of the best things about postgresql is the documentation. They document not only the features, but the constraints and considerations for using it and why t

One of the best things about postgresql is the documentation. They document not only the features, but the constraints and considerations for using it and why they exist. So from reading https://www.postgresql.org/docs/17/transaction-iso.html#XACT-SERIALIZABLE https://www.postgresql.org/docs/17/transaction-iso.html#XACT... we can tell that using serializable transactions only locks data actually used.