KVM testing on Ubuntu 20.04 via the Phoronix Test Suite.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2104069-HA-2104025HA73 gce-vm-comparison - Phoronix Test Suite gce-vm-comparison KVM testing on Ubuntu 20.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2104069-HA-2104025HA73&grr&sro .
gce-vm-comparison Processor Motherboard Chipset Memory Disk Network OS Kernel Compiler File-System System Layer GCE VM comparison PersistentDisk n1-standard-16 Intel Xeon (8 Cores / 16 Threads) Google Compute Engine c2-standard-16 Intel 440FX 82441FX PMC 64GB 161GB PersistentDisk Red Hat Virtio device Ubuntu 20.04 5.4.0-1040-gcp (x86_64) GCC 9.3.0 ext4 KVM Google Compute Engine n1-standard-16 60GB OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler Details - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Disk Details - NONE / relatime,rw / Block Size: 4096 Processor Details - CPU Microcode: 0x1 Java Details - GCE VM comparison, PersistentDisk: OpenJDK Runtime Environment (build 11.0.10+9-Ubuntu-0ubuntu1.20.04) Security Details - GCE VM comparison: itlb_multihit: Not affected + l1tf: Not affected + mds: Mitigation of Clear buffers; SMT Host state unknown + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT Host state unknown - PersistentDisk: itlb_multihit: Not affected + l1tf: Not affected + mds: Mitigation of Clear buffers; SMT Host state unknown + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT Host state unknown - n1-standard-16: itlb_multihit: Not affected + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; SMT Host state unknown + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected
gce-vm-comparison mysqlslap: 128 pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write mysqlslap: 512 mysqlslap: 64 mysqlslap: 256 mysqlslap: 4 mysqlslap: 32 mysqlslap: 16 mysqlslap: 1 mysqlslap: 8 pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 100 - Read Only couchdb: 100 - 1000 - 24 pgbench: 100 - 1 - Read Only - Average Latency pgbench: 100 - 1 - Read Only sqlite: 1 leveldb: Rand Delete leveldb: Seq Fill leveldb: Seq Fill pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Only leveldb: Hot Read pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 250 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 50 - Read Only pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write leveldb: Seek Rand pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 250 - Read Only pgbench: 100 - 50 - Read Only - Average Latency pgbench: 100 - 50 - Read Only pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 250 - Read Only pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 100 - Read Only leveldb: Rand Fill leveldb: Rand Fill leveldb: Overwrite leveldb: Overwrite leveldb: Rand Read leveldb: Fill Sync leveldb: Fill Sync GCE VM comparison PersistentDisk n1-standard-16 352 0.302 165375 0.058 17252 0.856 1168 261 972 295 1934 1347 1675 2982 1814 1.170 878 0.548 182659 97.714 0.053 18754 16.724 110.879 111.946 15.8 0.045 22019 15.083 203.469 1229 69.899 1431 0.233 214289 0.816 1225 19.103 14.905 3356 1.505 166151 0.288 173439 1.160 215591 33.040 1514 0.443 226079 111.921 15.8 112.041 15.8 15.450 2385.147 0.7 249 0.491 102418 0.120 8740 2.735 377 182 438 211 724 568 697 1073 726 4.011 256 0.984 104849 152.733 0.108 9352 40.562 287.549 255.595 6.9 0.074 13473 17.825 630.018 399 222.945 452 0.398 127712 2.268 443 23.568 15.176 3297 2.333 107242 0.486 102947 1.818 137617 78.596 636 0.652 153505 288.634 6.1 278.732 6.3 15.569 5824.140 0.3 OpenBenchmarking.org
MariaDB Clients: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 128 GCE VM comparison n1-standard-16 80 160 240 320 400 SE +/- 4.54, N = 3 SE +/- 2.34, N = 9 352 249 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency GCE VM comparison n1-standard-16 0.1105 0.221 0.3315 0.442 0.5525 SE +/- 0.002, N = 3 SE +/- 0.013, N = 9 0.302 0.491 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only GCE VM comparison n1-standard-16 40K 80K 120K 160K 200K SE +/- 1045.49, N = 3 SE +/- 2705.85, N = 9 165375 102418 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency GCE VM comparison n1-standard-16 0.027 0.054 0.081 0.108 0.135 SE +/- 0.001, N = 3 SE +/- 0.011, N = 8 0.058 0.120 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only GCE VM comparison n1-standard-16 4K 8K 12K 16K 20K SE +/- 236.08, N = 3 SE +/- 623.11, N = 8 17252 8740 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency GCE VM comparison n1-standard-16 0.6154 1.2308 1.8462 2.4616 3.077 SE +/- 0.003, N = 3 SE +/- 0.206, N = 7 0.856 2.735 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write GCE VM comparison n1-standard-16 300 600 900 1200 1500 SE +/- 4.20, N = 3 SE +/- 24.53, N = 7 1168 377 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
MariaDB Clients: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 512 GCE VM comparison n1-standard-16 60 120 180 240 300 SE +/- 2.22, N = 3 SE +/- 0.17, N = 3 261 182 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 64 GCE VM comparison n1-standard-16 200 400 600 800 1000 SE +/- 10.98, N = 3 SE +/- 7.56, N = 9 972 438 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 256 GCE VM comparison n1-standard-16 60 120 180 240 300 SE +/- 3.49, N = 3 SE +/- 2.78, N = 3 295 211 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 4 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 4 GCE VM comparison n1-standard-16 400 800 1200 1600 2000 SE +/- 27.37, N = 15 SE +/- 21.12, N = 9 1934 724 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 32 GCE VM comparison n1-standard-16 300 600 900 1200 1500 SE +/- 3.37, N = 3 SE +/- 14.09, N = 8 1347 568 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 16 GCE VM comparison n1-standard-16 400 800 1200 1600 2000 SE +/- 5.63, N = 3 SE +/- 18.42, N = 9 1675 697 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 1 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 1 GCE VM comparison n1-standard-16 600 1200 1800 2400 3000 SE +/- 7.83, N = 3 SE +/- 32.77, N = 12 2982 1073 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 8 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 8 GCE VM comparison n1-standard-16 400 800 1200 1600 2000 SE +/- 7.88, N = 3 SE +/- 19.41, N = 7 1814 726 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency GCE VM comparison n1-standard-16 0.9025 1.805 2.7075 3.61 4.5125 SE +/- 0.053, N = 15 SE +/- 0.181, N = 15 1.170 4.011 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write GCE VM comparison n1-standard-16 200 400 600 800 1000 SE +/- 38.28, N = 15 SE +/- 11.37, N = 15 878 256 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency GCE VM comparison n1-standard-16 0.2214 0.4428 0.6642 0.8856 1.107 SE +/- 0.001, N = 3 SE +/- 0.051, N = 15 0.548 0.984 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only GCE VM comparison n1-standard-16 40K 80K 120K 160K 200K SE +/- 189.06, N = 3 SE +/- 4338.69, N = 15 182659 104849 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Apache CouchDB Bulk Size: 100 - Inserts: 1000 - Rounds: 24 OpenBenchmarking.org Seconds, Fewer Is Better Apache CouchDB 3.1.1 Bulk Size: 100 - Inserts: 1000 - Rounds: 24 GCE VM comparison n1-standard-16 30 60 90 120 150 SE +/- 0.21, N = 3 SE +/- 0.48, N = 3 97.71 152.73
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency GCE VM comparison n1-standard-16 0.0243 0.0486 0.0729 0.0972 0.1215 SE +/- 0.000, N = 3 SE +/- 0.004, N = 12 0.053 0.108 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only GCE VM comparison n1-standard-16 4K 8K 12K 16K 20K SE +/- 66.76, N = 3 SE +/- 289.13, N = 12 18754 9352 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
SQLite Threads / Copies: 1 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 1 GCE VM comparison n1-standard-16 9 18 27 36 45 SE +/- 0.09, N = 3 SE +/- 0.57, N = 14 16.72 40.56 1. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
LevelDB Benchmark: Random Delete OpenBenchmarking.org Microseconds Per Op, Fewer Is Better LevelDB 1.22 Benchmark: Random Delete GCE VM comparison n1-standard-16 60 120 180 240 300 SE +/- 0.17, N = 3 SE +/- 2.15, N = 3 110.88 287.55 1. (CXX) g++ options: -O3 -lsnappy -lpthread
LevelDB Benchmark: Sequential Fill OpenBenchmarking.org Microseconds Per Op, Fewer Is Better LevelDB 1.22 Benchmark: Sequential Fill GCE VM comparison n1-standard-16 60 120 180 240 300 SE +/- 0.09, N = 3 SE +/- 3.35, N = 3 111.95 255.60 1. (CXX) g++ options: -O3 -lsnappy -lpthread
LevelDB Benchmark: Sequential Fill OpenBenchmarking.org MB/s, More Is Better LevelDB 1.22 Benchmark: Sequential Fill GCE VM comparison n1-standard-16 4 8 12 16 20 SE +/- 0.00, N = 3 SE +/- 0.09, N = 3 15.8 6.9 1. (CXX) g++ options: -O3 -lsnappy -lpthread
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency GCE VM comparison n1-standard-16 0.0167 0.0334 0.0501 0.0668 0.0835 SE +/- 0.000, N = 3 SE +/- 0.001, N = 15 0.045 0.074 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only GCE VM comparison n1-standard-16 5K 10K 15K 20K 25K SE +/- 97.18, N = 3 SE +/- 125.37, N = 15 22019 13473 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
LevelDB Benchmark: Hot Read OpenBenchmarking.org Microseconds Per Op, Fewer Is Better LevelDB 1.22 Benchmark: Hot Read GCE VM comparison n1-standard-16 4 8 12 16 20 SE +/- 0.12, N = 12 SE +/- 0.25, N = 15 15.08 17.83 1. (CXX) g++ options: -O3 -lsnappy -lpthread
PostgreSQL pgbench Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency GCE VM comparison n1-standard-16 140 280 420 560 700 SE +/- 1.26, N = 3 SE +/- 12.61, N = 12 203.47 630.02 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write GCE VM comparison n1-standard-16 300 600 900 1200 1500 SE +/- 7.63, N = 3 SE +/- 8.18, N = 12 1229 399 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency GCE VM comparison n1-standard-16 50 100 150 200 250 SE +/- 0.46, N = 3 SE +/- 5.86, N = 12 69.90 222.95 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write GCE VM comparison n1-standard-16 300 600 900 1200 1500 SE +/- 9.46, N = 3 SE +/- 11.94, N = 12 1431 452 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency GCE VM comparison n1-standard-16 0.0896 0.1792 0.2688 0.3584 0.448 SE +/- 0.000, N = 3 SE +/- 0.015, N = 12 0.233 0.398 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only GCE VM comparison n1-standard-16 50K 100K 150K 200K 250K SE +/- 122.97, N = 3 SE +/- 4821.33, N = 12 214289 127712 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency GCE VM comparison n1-standard-16 0.5103 1.0206 1.5309 2.0412 2.5515 SE +/- 0.004, N = 3 SE +/- 0.043, N = 12 0.816 2.268 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write GCE VM comparison n1-standard-16 300 600 900 1200 1500 SE +/- 5.60, N = 3 SE +/- 8.21, N = 12 1225 443 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
LevelDB Benchmark: Seek Random OpenBenchmarking.org Microseconds Per Op, Fewer Is Better LevelDB 1.22 Benchmark: Seek Random GCE VM comparison n1-standard-16 6 12 18 24 30 SE +/- 0.09, N = 3 SE +/- 0.29, N = 12 19.10 23.57 1. (CXX) g++ options: -O3 -lsnappy -lpthread
PostgreSQL pgbench Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency GCE VM comparison n1-standard-16 4 8 12 16 20 SE +/- 0.21, N = 3 SE +/- 0.18, N = 3 14.91 15.18 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write GCE VM comparison n1-standard-16 700 1400 2100 2800 3500 SE +/- 47.44, N = 3 SE +/- 39.30, N = 3 3356 3297 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency GCE VM comparison n1-standard-16 0.5249 1.0498 1.5747 2.0996 2.6245 SE +/- 0.004, N = 3 SE +/- 0.003, N = 3 1.505 2.333 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only GCE VM comparison n1-standard-16 40K 80K 120K 160K 200K SE +/- 459.20, N = 3 SE +/- 151.18, N = 3 166151 107242 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency GCE VM comparison n1-standard-16 0.1094 0.2188 0.3282 0.4376 0.547 SE +/- 0.001, N = 3 SE +/- 0.005, N = 3 0.288 0.486 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only GCE VM comparison n1-standard-16 40K 80K 120K 160K 200K SE +/- 430.51, N = 3 SE +/- 981.93, N = 3 173439 102947 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency GCE VM comparison n1-standard-16 0.4091 0.8182 1.2273 1.6364 2.0455 SE +/- 0.002, N = 3 SE +/- 0.010, N = 3 1.160 1.818 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only GCE VM comparison n1-standard-16 50K 100K 150K 200K 250K SE +/- 337.36, N = 3 SE +/- 775.69, N = 3 215591 137617 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency GCE VM comparison n1-standard-16 20 40 60 80 100 SE +/- 0.34, N = 3 SE +/- 0.58, N = 3 33.04 78.60 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write GCE VM comparison n1-standard-16 300 600 900 1200 1500 SE +/- 15.59, N = 3 SE +/- 4.70, N = 3 1514 636 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency GCE VM comparison n1-standard-16 0.1467 0.2934 0.4401 0.5868 0.7335 SE +/- 0.002, N = 3 SE +/- 0.001, N = 3 0.443 0.652 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only GCE VM comparison n1-standard-16 50K 100K 150K 200K 250K SE +/- 1123.14, N = 3 SE +/- 161.20, N = 3 226079 153505 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
LevelDB Benchmark: Random Fill OpenBenchmarking.org Microseconds Per Op, Fewer Is Better LevelDB 1.22 Benchmark: Random Fill GCE VM comparison n1-standard-16 60 120 180 240 300 SE +/- 0.14, N = 3 SE +/- 1.47, N = 3 111.92 288.63 1. (CXX) g++ options: -O3 -lsnappy -lpthread
LevelDB Benchmark: Random Fill OpenBenchmarking.org MB/s, More Is Better LevelDB 1.22 Benchmark: Random Fill GCE VM comparison n1-standard-16 4 8 12 16 20 SE +/- 0.00, N = 3 SE +/- 0.03, N = 3 15.8 6.1 1. (CXX) g++ options: -O3 -lsnappy -lpthread
LevelDB Benchmark: Overwrite OpenBenchmarking.org Microseconds Per Op, Fewer Is Better LevelDB 1.22 Benchmark: Overwrite GCE VM comparison n1-standard-16 60 120 180 240 300 SE +/- 0.07, N = 3 SE +/- 1.19, N = 3 112.04 278.73 1. (CXX) g++ options: -O3 -lsnappy -lpthread
LevelDB Benchmark: Overwrite OpenBenchmarking.org MB/s, More Is Better LevelDB 1.22 Benchmark: Overwrite GCE VM comparison n1-standard-16 4 8 12 16 20 SE +/- 0.00, N = 3 SE +/- 0.03, N = 3 15.8 6.3 1. (CXX) g++ options: -O3 -lsnappy -lpthread
LevelDB Benchmark: Random Read OpenBenchmarking.org Microseconds Per Op, Fewer Is Better LevelDB 1.22 Benchmark: Random Read GCE VM comparison n1-standard-16 4 8 12 16 20 SE +/- 0.13, N = 3 SE +/- 0.03, N = 3 15.45 15.57 1. (CXX) g++ options: -O3 -lsnappy -lpthread
LevelDB Benchmark: Fill Sync OpenBenchmarking.org Microseconds Per Op, Fewer Is Better LevelDB 1.22 Benchmark: Fill Sync GCE VM comparison n1-standard-16 1200 2400 3600 4800 6000 SE +/- 9.53, N = 13 SE +/- 48.29, N = 3 2385.15 5824.14 1. (CXX) g++ options: -O3 -lsnappy -lpthread
LevelDB Benchmark: Fill Sync OpenBenchmarking.org MB/s, More Is Better LevelDB 1.22 Benchmark: Fill Sync GCE VM comparison n1-standard-16 0.1575 0.315 0.4725 0.63 0.7875 SE +/- 0.01, N = 13 SE +/- 0.00, N = 3 0.7 0.3 1. (CXX) g++ options: -O3 -lsnappy -lpthread
Phoronix Test Suite v10.8.4