Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I wouldn't say it is "obviously" a problem: READ COMMITTED are perfectly reasonable semantics, and are preferable to many applications (e.g. many apps aren't written to retry transactions that abort due to serialization conflicts). Which isolation level ought to be the default is a matter of debate, but I don't think using RC by default is "obviously" wrong -- if an application depends on a particular isolation level for correctness, it should set it explicitly in any case.


Just remember that with read committed isolation, certain access patterns can silently trash your data.

People are afraid of transactions aborting for some reason, as they think that's an error. It's not; you just retry your transaction, which will now be using correct data. "Read committed" opens you up to race conditions in exchange for transactions rarely (never?) aborting themselves.

I think the default should be "never trash my data without telling me".




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: