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