(www.cs.cmu.edu)

366 points virtualwhys | 1 comments | 20 Oct 24 15:30 UTC | HN request time: 0.259s | source

Show context

WuxiFingerHold ◴[21 Oct 24 04:11 UTC] No.41900626[source]▶

Putting aside the license / closed source issues with CockroachDB (CRDB) and just focus at it technically: CRDB uses MVVM too, but its storage is a key-value store. I know it uses some kind of garbage collection to remove the old versions.

I wonder if CRDB (or other newer designed DBs) has circumvented those issues? Or don't we just hear from those issues as CRDB and the other newer DBs are not that widely used and mainly in the commercial space?

replies(2): >>41901017 #>>41901777 #

1. qaq ◴[21 Oct 24 05:48 UTC] No.41901017[source]▶

>>41900626 #

CRDB will be slower than PG on the same hardware.With CRDB you are trading off performance for ability to scale horizontally.

↑

MVCC – the part of PostgreSQL we hate the most (2023)