News for hackers. Stuff that matters.

A comment on Performance Evaluation of PostgreSQL vs. Distributed DBMSs.

Re:Performance Evaluation of PostgreSQL vs. Distributed DBMSs by eivanov89 on Wednesday March 20, 2024 @10:40AM (#39767285)
Nice to see this link shared on HN. I'm the post author and I'm glad to answer any questions. Also it would be interesting if you share your approach to the benchmarking, when you have to choose between Postgres and any other DB, especially sharded or distributed.
[ Parent | on HN ]
Re:Performance Evaluation of PostgreSQL vs. Distributed DBMSs by ostap-b on Wednesday March 20, 2024 @12:06PM (#39768481)
I understand that using Postgres without WAL is quite fault-INtolerant (although considerably more performant). But what about the setups of YDB and CockroachDB, are they comparable to Postgres' setup in terms of fault tolerance?
[ Parent | on HN ]
Re:Performance Evaluation of PostgreSQL vs. Distributed DBMSs by eivanov89 on Wednesday March 20, 2024 @12:13PM (#39768588)
Absolutely. Both CockroachDB and YDB have replication factor equal to 3. So it's similar to Postgres with 2 sync replicas.
[ Parent | on HN ]