3 ms·

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 st

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?

qaq 2y ago
CRDB will be slower than PG on the same hardware.With CRDB you are trading off performance for ability to scale horizontally.
ddorian43 2y ago
This is fixed in YugabyteDB that reuses the PostgreSQL query layer source code but uses it's own storage: https://www.yugabyte.com/blog/improve-postgresql/ https://www.yugabyte.com/blog/improve-postgresql/ (other issues too like XID wraparound etc). It's also apache2 license.
- knowitnone 2y ago
  Thanks for pointing out Yugabyte. I did a search for performance comparisons and there seems (seemed?) to be some performance issues at least back in 2023 https://github.com/yugabyte/yugabyte-db/issues/10108 https://github.com/yugabyte/yugabyte-db/issues/10108 hopeful performance has improved since
  - ddorian43 2y ago
    Yes, performance is much better. But it's a bit apples to oranges comparisons because of distributed/sharding nature (example with bitmap scans https://www.yugabyte.com/blog/bitmap-scans-on-distributed-postgresql/ https://www.yugabyte.com/blog/bitmap-scans-on-distributed-po...), and always synchronous replication (https://www.yugabyte.com/blog/yugabytedb-resiliency-vs-postgresql-ha-solutions/ https://www.yugabyte.com/blog/yugabytedb-resiliency-vs-postg...).