Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

BDR Performance

BDR's performance is very impressive. Our own tests using pgbench and (2ndQuadrant benchmarks testing on custom workload with a latency of <2 seconds) reveal BDR's significant advantages:

1. Basic pgbench test: the overhead of BDR is very low and is very close to Hot Standby. 


The small number for Londiste and Burcardo on Standby are the result of setting wal_level=minimal. 

2. Transaction performance: again BDR's performance is very close to Hot Standby

3. Latency:  BDR avoids trigger processing so achieves a low latency per transaction.


Latency measured in milliseconds

4. Custom workload throughput with latency < 2 seconds.

Performance setup: x i2.4xlarge. Intel Xeon E5-2670 v2.122GB RAM. 4x800GB SSDs Raid 0. Minimally tuned setup. pgbench scale 50, -c 32 -j 32

Comments

Popular posts from this blog

PostgreSQL pgBadger

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL Pgbadger Installation On Linux

PostgreSQL Database startup / shutdown /restart