[sitharus]

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... we can tell that using serializable transactions only locks data actually used.

[magicalhippo]

Yea that's much, much better. I also note that it goes for the retry instead of locking.