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&sro&grs .
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 leveldb: Rand Delete leveldb: Rand Fill leveldb: Rand Fill leveldb: Overwrite leveldb: Overwrite leveldb: Fill Sync sqlite: 1 pgbench: 1 - 50 - Read Write pgbench: 1 - 50 - Read Write - Average Latency leveldb: Fill Sync leveldb: Seq Fill leveldb: Seq Fill mysqlslap: 64 pgbench: 100 - 50 - Read Only - Average Latency pgbench: 100 - 50 - Read Only pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Only pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 250 - Read Only couchdb: 100 - 1000 - 24 pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 250 - Read Only pgbench: 1 - 100 - Read Only pgbench: 1 - 100 - Read Only - Average Latency mysqlslap: 512 mysqlslap: 128 mysqlslap: 256 leveldb: Seek Rand leveldb: Hot Read pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write leveldb: Rand Read pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 1 - Read Write 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: 100 - 1 - Read Only - Average Latency pgbench: 100 - 1 - Read Only pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 50 - Read Only pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write mysqlslap: 32 mysqlslap: 16 mysqlslap: 8 mysqlslap: 4 mysqlslap: 1 GCE VM comparison PersistentDisk n1-standard-16 110.879 15.8 111.921 15.8 112.041 2385.147 16.724 1514 33.040 0.7 15.8 111.946 972 0.288 173439 0.045 22019 1.160 215591 97.714 1.505 166151 226079 0.443 261 352 295 19.103 15.083 14.905 3356 15.450 0.302 165375 0.856 1168 0.548 182659 0.058 17252 1.170 878 203.469 1229 69.899 1431 0.053 18754 0.233 214289 0.816 1225 1347 1675 1814 1934 2982 287.549 6.1 288.634 6.3 278.732 5824.140 40.562 636 78.596 0.3 6.9 255.595 438 0.486 102947 0.074 13473 1.818 137617 152.733 2.333 107242 153505 0.652 182 249 211 23.568 17.825 15.176 3297 15.569 0.491 102418 2.735 377 0.984 104849 0.120 8740 4.011 256 630.018 399 222.945 452 0.108 9352 0.398 127712 2.268 443 568 697 726 724 1073 OpenBenchmarking.org
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: 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: 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: 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: 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: 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
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
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: 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
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
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
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
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
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: 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
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
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: 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: 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
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
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: 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
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
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
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: 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
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
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 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
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
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: 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: 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: 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
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
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: 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
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: 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
Phoronix Test Suite v10.8.4