Re:Using PostgreSQL as a Data Warehouse
by rad_gruchalski on Monday May 10, 2021 @07:23PM
(#27112163)
The Jepsen tests do not inspire confidence but they're also pretty aged by now. 1.3.1 under test and the most recent appears to be 2.7.0.
Cockroach is a no go for me because of the licensing restrictions. For example, password authentication only in the BSL licensed code. Backups in enterprise.
Re:Using PostgreSQL as a Data Warehouse
by jordanlewis on Monday May 10, 2021 @11:05PM
(#27113791)
Backups are available without a license in CockroachDB as of 20.2, FWIW.
https://www.cockroachlabs.com/blog/distributed-backup-restor... https://www.cockroachlabs.com/docs/v20.2/backup.html
Yugabyte uses actual Postgres code for the query parsing top layer and then translates that into to operates on it's key/value store which handles replication and distributed. CockroachDB is similar but has built everything from scratch in Go. There are similar examples like TiDB and Vitesse for MySQL as well.