Conversation

Fascinating disconnect I’ve seen on this one: - academic researchers: SERIALIZABLE isn’t the default? But everyone enables it first thing, right? - database users: SERIALIZABLE exists?

Quote Tweet

Brent Ozar

@BrentO

Sep 13

"Why isolation level serializable is not the default?" reddit.com/r/Database/com Oh my.

115

Replying to

SERIALIZABLE may perform quite well on average, but is more prone to pathological performance issues from deadlocks, retries, and so on (as a general rule). So while arguments like "the safest isolation level should be the default" have validity, they also cut both ways.

Replying to

and

In other words, it's not so much a cultural difference around how much correctness is emphasized over other things. More like a difference in how correctness is defined or understood.

3:34 AM · Sep 14, 2022Twitter Web App

Replying to

and

Can you elaborate on what you mean with 'a difference in how correctness is defined and understood'? At first sight this seems like a self-contradiction. What am I missing?

Replying to

and

operations at scale, i think. not the typical definition of "correctness", bit broader of an idea, but the amount of broadening that peter just did seems to be pushing it in my view :)

Show replies