The database does not really ‘lock’ but any other mutations to that predicate (field) and value (depending on @noconflict and @upsert flags) that happen between readTS and commitTS will be aborted and need to be retried.
1 Like