3 ms·
> The example with follower_count shows how to use the +1 technique to do without locking.. Without explicit pessimistic locking. There are always locks. More
by Rapzid 3y ago
> The example with follower_count shows how to use the +1 technique to do without locking..
Without explicit pessimistic locking. There are always locks. More guarantees, more locks.
That issue example can be tackled with optimistic concurrency controls depending on the constraints. The issue can be checked out with an UPDATE .. WHERE .. RETURNING ..