Performance Evaluation of PostgreSQL vs. Distributed DBMSs
1–10 of 10 posts
Re: Performance Evaluation of PostgreSQL vs. Distributed DBMSs
#2Nice 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.
Re: Performance Evaluation of PostgreSQL vs. Distributed DBMSs
#3[dead]
Re: Performance Evaluation of PostgreSQL vs. Distributed DBMSs
#4Nice 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.
[dead]
Re: Performance Evaluation of PostgreSQL vs. Distributed DBMSs
#5Nice and timely study, very important when you start having serious performance and reliability requirements for you database
Re: Performance Evaluation of PostgreSQL vs. Distributed DBMSs
#6Nice and timely study, very important when you start having serious performance and reliability requirements for you database
Thank you! Any chance you have a list of favourite benchmarks? Now, we are open for suggestions.
Re: Performance Evaluation of PostgreSQL vs. Distributed DBMSs
#7Nice 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.
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?
Re: Performance Evaluation of PostgreSQL vs. Distributed DBMSs
#8Nice 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.
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?
Absolutely. Both CockroachDB and YDB have replication factor equal to 3. So it's similar to Postgres with 2 sync replicas.
Re: Performance Evaluation of PostgreSQL vs. Distributed DBMSs
#9Nice comparison. Do you have any plans to include yugabyte in your next benchmarking posts?
Re: Performance Evaluation of PostgreSQL vs. Distributed DBMSs
#10Nice comparison. Do you have any plans to include yugabyte in your next benchmarking posts?
We plan, but currently we are blocked by this issue: https://github.com/yugabyte/tpcc/issues/147
Thus, we consider either waiting for the improvement or trying running DBMSs in containers.