Content Deep Dive
Why CockroachDB doesn't use EvalPlanQual
Blog post from Cockroach Labs
Post Details
Company
Date Published
Author
Michael Erickson
Word Count
1,707
Language
English
Hacker News Points
135
Summary
PostgreSQL can sometimes miss rows when performing UPDATE, DELETE, SELECT FOR UPDATE, or SELECT FOR SHARE statements under READ COMMITTED isolation due to the EvalPlanQual recheck. This behavior can cause anomalies and may require application-level retries. CockroachDB's new implementation of READ COMMITTED isolation uses a different technique that does not miss rows, thus alleviating the need for application-level retries.