i watched severance tonight and the  first thing that popped into
my head when it was over was the realization that traditional row level locking could be paired with serializable snapshot isolation to increase write throughput in situations where high contention on a specific rows causes frequent rollbacks

Building @warpcast and @farcaster / dad / like to read, cook, ski, code

BDFL of Quilibrium, Eng @ Farcaster, ex-Coinbase, always opinionated, never hydrated

/quilibrium

thinking is that having concurrent statements you know would conflict sequence themselves with the row level lock rather is more efficient than having them all going through execute / rollback / retry until they all succeed

haven’t had a chance to test it out though

I have yet to see severance, but I don't follow how this improves throughput?

You had me at “serializable”. Guess I should go watch it now 🤓

🤔 Damn did we watch the same episode?!

I haven’t seen but not that it would. ELI5 please :)