Tech Talk Co-Founder Ben Darnell on Van Halen, brown M&Ms, and isolation. Watch now Here’s a surprising behavior of PostgreSQL you might not know about: under READ COMMITTED isolation, PostgreSQL can sometimes miss rows when performing UPDATE, DELETE, SELECT FOR UPDATE, or SELECT FOR SHARE statements. This is due to the EvalPlanQual recheck PostgreSQL adds to these statements to prevent lost-update anomalies. For CockroachDB’s new implementation of READ COMMITTED isolation, we considered buildin...