tag:blogger.com,1999:blog-8436330762136344379.post425031739867194514..comments2024-03-26T06:02:24.273-04:00Comments on Metadata: CockroachDB: The Resilient Geo-Distributed SQL DatabaseMurathttp://www.blogger.com/profile/07842046940394980130noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8436330762136344379.post-39202080230895100932022-03-05T13:02:44.817-05:002022-03-05T13:02:44.817-05:00I don't know how the claim that snapshot isola...I don't know how the claim that snapshot isolation requires pessimistic concurrency control ever got through review. There are plenty of MVCC databases that use OCC (I know because I've written one, but there are many others). To claim the contrary is not just inaccurate; it shows a misunderstanding of elementary database principles.<br /><br />There are legitimate reasons to use PCC rather than OCC for an MVCC database (e.g., for reducing wasted work due to aborts in highly contended workloads), but it is not remotely a requirement.Tobin Bakerhttps://www.blogger.com/profile/15252611653182642620noreply@blogger.com