Company
Date Published
April 5, 2024
Author
Michael Erickson
Word count
1707
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.