gce-vm-comparison

KVM testing on Ubuntu 20.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2104060-JANA-210405301&sor.

gce-vm-comparisonProcessorMotherboardChipsetMemoryDiskNetworkOSKernelCompilerFile-SystemSystem LayerDisplay ServerGCE VM comparisonPersistentDiskc2-standard-16c2-standard-16 2Intel Xeon (8 Cores / 16 Threads)Google Compute Engine c2-standard-16Intel 440FX 82441FX PMC64GB161GB PersistentDiskRed Hat Virtio deviceUbuntu 20.045.4.0-1040-gcp (x86_64)GCC 9.3.0ext4KVMX Server 1.20.9OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler 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: 4096Processor Details- CPU Microcode: 0x1Java Details- GCE VM comparison, PersistentDisk: OpenJDK Runtime Environment (build 11.0.10+9-Ubuntu-0ubuntu1.20.04) Security Details- 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

gce-vm-comparisonleveldb: Hot Readleveldb: Fill Syncleveldb: Fill Syncleveldb: Overwriteleveldb: Overwriteleveldb: Rand Fillleveldb: Rand Fillleveldb: Rand Readleveldb: Seek Randleveldb: Rand Deleteleveldb: Seq Fillleveldb: Seq Fillsqlite: 1couchdb: 100 - 1000 - 24mysqlslap: 1mysqlslap: 4mysqlslap: 8mysqlslap: 16mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256mysqlslap: 512pgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average LatencyGCE VM comparisonPersistentDiskc2-standard-16c2-standard-16 215.0830.72385.14715.8112.04115.8111.92115.45019.103110.87915.8111.94616.72497.71429821934181416751347972352295261220190.04512250.8162142890.2332260790.4432155911.160151433.040187540.053143169.8991229203.4698781.1701734390.288172520.0581826590.5481661511.505335614.90511680.8561653750.30214.4490.82318.08515.9111.54815.8111.62615.10818.792111.05915.8112.15916.925122.96030491922179616201334100535829025415.1590.82319.44215.8111.94415.7112.12615.63719.220110.99815.8111.59316.906119.776298818671811167213641007358303267221560.04512480.8022214230.2262329210.4302152421.162151533.017186500.053139971.5551230203.5529711.0461774640.282175420.0571849860.5411678591.490344014.54911260.8881694370.295OpenBenchmarking.org

LevelDB

Benchmark: Hot Read

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Hot Readc2-standard-16GCE VM comparisonc2-standard-16 248121620SE +/- 0.11, N = 3SE +/- 0.12, N = 12SE +/- 0.15, N = 514.4515.0815.161. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Fill Sync

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Fill Syncc2-standard-16 2c2-standard-16GCE VM comparison0.180.360.540.720.9SE +/- 0.00, N = 3SE +/- 0.01, N = 12SE +/- 0.01, N = 130.80.80.71. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Fill Sync

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Fill Syncc2-standard-16c2-standard-16 2GCE VM comparison5001000150020002500SE +/- 7.31, N = 12SE +/- 13.05, N = 3SE +/- 9.53, N = 132318.092319.442385.151. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Overwrite

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Overwritec2-standard-16c2-standard-16 2GCE VM comparison48121620SE +/- 0.07, N = 3SE +/- 0.03, N = 3SE +/- 0.00, N = 315.915.815.81. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Overwrite

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Overwritec2-standard-16c2-standard-16 2GCE VM comparison306090120150SE +/- 0.41, N = 3SE +/- 0.24, N = 3SE +/- 0.07, N = 3111.55111.94112.041. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Random Fill

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Random Fillc2-standard-16GCE VM comparisonc2-standard-16 248121620SE +/- 0.03, N = 3SE +/- 0.00, N = 3SE +/- 0.03, N = 315.815.815.71. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Random Fill

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random Fillc2-standard-16GCE VM comparisonc2-standard-16 2306090120150SE +/- 0.19, N = 3SE +/- 0.14, N = 3SE +/- 0.21, N = 3111.63111.92112.131. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Random Read

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random Readc2-standard-16GCE VM comparisonc2-standard-16 248121620SE +/- 0.15, N = 3SE +/- 0.13, N = 3SE +/- 0.01, N = 315.1115.4515.641. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Seek Random

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Seek Randomc2-standard-16GCE VM comparisonc2-standard-16 2510152025SE +/- 0.18, N = 3SE +/- 0.09, N = 3SE +/- 0.03, N = 318.7919.1019.221. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Random Delete

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random DeleteGCE VM comparisonc2-standard-16 2c2-standard-1620406080100SE +/- 0.17, N = 3SE +/- 0.05, N = 3SE +/- 0.06, N = 3110.88111.00111.061. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Sequential Fill

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Sequential Fillc2-standard-16 2c2-standard-16GCE VM comparison48121620SE +/- 0.03, N = 3SE +/- 0.03, N = 3SE +/- 0.00, N = 315.815.815.81. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Sequential Fill

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Sequential Fillc2-standard-16 2GCE VM comparisonc2-standard-16306090120150SE +/- 0.16, N = 3SE +/- 0.09, N = 3SE +/- 0.36, N = 3111.59111.95112.161. (CXX) g++ options: -O3 -lsnappy -lpthread

SQLite

Threads / Copies: 1

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1GCE VM comparisonc2-standard-16 2c2-standard-1648121620SE +/- 0.09, N = 3SE +/- 0.08, N = 3SE +/- 0.20, N = 416.7216.9116.931. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

Apache CouchDB

Bulk Size: 100 - Inserts: 1000 - Rounds: 24

OpenBenchmarking.orgSeconds, Fewer Is BetterApache CouchDB 3.1.1Bulk Size: 100 - Inserts: 1000 - Rounds: 24GCE VM comparisonc2-standard-16 2c2-standard-16306090120150SE +/- 0.21, N = 3SE +/- 0.23, N = 3SE +/- 0.67, N = 397.71119.78122.961. (CXX) g++ options: -std=c++14 -lmozjs-68 -lm -lerl_interface -lei -fPIC -MMD

MariaDB

Clients: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 1c2-standard-16c2-standard-16 2GCE VM comparison7001400210028003500SE +/- 16.10, N = 3SE +/- 19.40, N = 3SE +/- 7.83, N = 33049298829821. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 4

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 4GCE VM comparisonc2-standard-16c2-standard-16 2400800120016002000SE +/- 27.37, N = 15SE +/- 6.53, N = 3SE +/- 47.75, N = 121934192218671. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 8

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 8GCE VM comparisonc2-standard-16 2c2-standard-16400800120016002000SE +/- 7.88, N = 3SE +/- 22.20, N = 3SE +/- 5.68, N = 31814181117961. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 16

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 16GCE VM comparisonc2-standard-16 2c2-standard-16400800120016002000SE +/- 5.63, N = 3SE +/- 6.46, N = 3SE +/- 0.87, N = 31675167216201. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 32c2-standard-16 2GCE VM comparisonc2-standard-1630060090012001500SE +/- 1.86, N = 3SE +/- 3.37, N = 3SE +/- 4.29, N = 31364134713341. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 64

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 64c2-standard-16 2c2-standard-16GCE VM comparison2004006008001000SE +/- 2.34, N = 3SE +/- 1.21, N = 3SE +/- 10.98, N = 3100710059721. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 128c2-standard-16 2c2-standard-16GCE VM comparison80160240320400SE +/- 4.10, N = 4SE +/- 2.11, N = 3SE +/- 4.54, N = 33583583521. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 256

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 256c2-standard-16 2GCE VM comparisonc2-standard-1670140210280350SE +/- 1.49, N = 3SE +/- 3.49, N = 3SE +/- 1.23, N = 33032952901. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lsnappy -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 512

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 512c2-standard-16 2GCE VM comparisonc2-standard-1660120180240300SE +/- 0.79, N = 3SE +/- 2.22, N = 3SE +/- 2.04, N = 32672612541. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Onlyc2-standard-16 2GCE VM comparison5K10K15K20K25KSE +/- 138.94, N = 3SE +/- 97.18, N = 322156220191. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyGCE VM comparisonc2-standard-16 20.01010.02020.03030.04040.0505SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0450.0451. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Writec2-standard-16 2GCE VM comparison30060090012001500SE +/- 5.34, N = 3SE +/- 5.60, N = 3124812251. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latencyc2-standard-16 2GCE VM comparison0.18360.36720.55080.73440.918SE +/- 0.003, N = 3SE +/- 0.004, N = 30.8020.8161. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Onlyc2-standard-16 2GCE VM comparison50K100K150K200K250KSE +/- 692.05, N = 3SE +/- 122.97, N = 32214232142891. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latencyc2-standard-16 2GCE VM comparison0.05240.10480.15720.20960.262SE +/- 0.001, N = 3SE +/- 0.000, N = 30.2260.2331. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Onlyc2-standard-16 2GCE VM comparison50K100K150K200K250KSE +/- 560.73, N = 3SE +/- 1123.14, N = 32329212260791. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latencyc2-standard-16 2GCE VM comparison0.09970.19940.29910.39880.4985SE +/- 0.001, N = 3SE +/- 0.002, N = 30.4300.4431. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyGCE VM comparisonc2-standard-16 250K100K150K200K250KSE +/- 337.36, N = 3SE +/- 2245.88, N = 32155912152421. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average LatencyGCE VM comparisonc2-standard-16 20.26150.5230.78451.0461.3075SE +/- 0.002, N = 3SE +/- 0.012, N = 31.1601.1621. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Writec2-standard-16 2GCE VM comparison30060090012001500SE +/- 19.63, N = 3SE +/- 15.59, N = 3151515141. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latencyc2-standard-16 2GCE VM comparison816243240SE +/- 0.43, N = 3SE +/- 0.34, N = 333.0233.041. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyGCE VM comparisonc2-standard-16 24K8K12K16K20KSE +/- 66.76, N = 3SE +/- 125.20, N = 318754186501. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyGCE VM comparisonc2-standard-16 20.01190.02380.03570.04760.0595SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0530.0531. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read WriteGCE VM comparisonc2-standard-16 230060090012001500SE +/- 9.46, N = 3SE +/- 17.24, N = 3143113991. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyGCE VM comparisonc2-standard-16 21632486480SE +/- 0.46, N = 3SE +/- 0.90, N = 369.9071.561. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 250 - Mode: Read Writec2-standard-16 2GCE VM comparison30060090012001500SE +/- 9.63, N = 15SE +/- 7.63, N = 3123012291. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average LatencyGCE VM comparisonc2-standard-16 24080120160200SE +/- 1.26, N = 3SE +/- 1.60, N = 15203.47203.551. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read Writec2-standard-16 2GCE VM comparison2004006008001000SE +/- 29.34, N = 14SE +/- 38.28, N = 159718781. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latencyc2-standard-16 2GCE VM comparison0.26330.52660.78991.05321.3165SE +/- 0.039, N = 14SE +/- 0.053, N = 151.0461.1701. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Onlyc2-standard-16 2GCE VM comparison40K80K120K160K200KSE +/- 393.03, N = 3SE +/- 430.51, N = 31774641734391. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latencyc2-standard-16 2GCE VM comparison0.06480.12960.19440.25920.324SE +/- 0.001, N = 3SE +/- 0.001, N = 30.2820.2881. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Onlyc2-standard-16 2GCE VM comparison4K8K12K16K20KSE +/- 97.76, N = 3SE +/- 236.08, N = 317542172521. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latencyc2-standard-16 2GCE VM comparison0.01310.02620.03930.05240.0655SE +/- 0.000, N = 3SE +/- 0.001, N = 30.0570.0581. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read Onlyc2-standard-16 2GCE VM comparison40K80K120K160K200KSE +/- 82.80, N = 3SE +/- 189.06, N = 31849861826591. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencyc2-standard-16 2GCE VM comparison0.12330.24660.36990.49320.6165SE +/- 0.000, N = 3SE +/- 0.001, N = 30.5410.5481. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 250 - Mode: Read Onlyc2-standard-16 2GCE VM comparison40K80K120K160K200KSE +/- 267.29, N = 3SE +/- 459.20, N = 31678591661511. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencyc2-standard-16 2GCE VM comparison0.33860.67721.01581.35441.693SE +/- 0.002, N = 3SE +/- 0.004, N = 31.4901.5051. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Writec2-standard-16 2GCE VM comparison7001400210028003500SE +/- 27.58, N = 15SE +/- 47.44, N = 3344033561. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latencyc2-standard-16 2GCE VM comparison48121620SE +/- 0.12, N = 15SE +/- 0.21, N = 314.5514.911. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read WriteGCE VM comparisonc2-standard-16 230060090012001500SE +/- 4.20, N = 3SE +/- 3.37, N = 3116811261. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyGCE VM comparisonc2-standard-16 20.19980.39960.59940.79920.999SE +/- 0.003, N = 3SE +/- 0.003, N = 30.8560.8881. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Onlyc2-standard-16 2GCE VM comparison40K80K120K160K200KSE +/- 196.98, N = 3SE +/- 1045.49, N = 31694371653751. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latencyc2-standard-16 2GCE VM comparison0.0680.1360.2040.2720.34SE +/- 0.000, N = 3SE +/- 0.002, N = 30.2950.3021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4