Top 60 Oracle Blogs

Recent comments


ysql_bench: the YugaByteDB version of pgbench

By Franck Pachot

This follows the previous post on testing YugaByteDB 2.1 performance with pgbench:
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”.