Y
Hacker News
new
|
ask
|
show
|
jobs
by
senderista
257 days ago
Almost all commercial MVCC implementations (including Postgres) use row locks. Very few use OCC even though it's arguably a more natural fit for MVCC. Pessimistic locking is simply more robust over varied workloads.