Search

Top 60 Oracle Blogs

Recent comments

Home

NewSQL

ysql_bench: the YugaByteDB version of pgbench

Submitted by Franck Pachot on Mon, 2020-03-09 08:00

By Franck Pachot

.
This follows the previous post on testing YugaByteDB 2.1 performance with pgbench: https://blog.dbi-services.com/yugabytedb-2-1/
A distributed database needs to reduce inter-node synchronization latency and then replaces two-phase pessimistic locking by optimistic concurrency control in many places. This means more serialization errors where a transaction may have to be re-tried. But the PostgreSQL pgbench does not have this possibility and this makes benchmarking distributed database very hard. For example when CERN tested CoackroachDB the conclusion was: “comparative benchmarking of CockroachDB was not possible with the current tools used”.

YugaByteDB 2.1: the Open Source multi-region distributed database with PostgreSQL API is in GA with huge performance improvement

Submitted by Franck Pachot on Sun, 2020-03-08 14:48

By Franck Pachot

.