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.

gce-vm-comparisonProcessorMotherboardChipsetMemoryDiskNetworkOSKernelCompilerFile-SystemSystem LayerGCE VM comparisonPersistentDiskn1-standard-16Intel 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.0ext4KVMGoogle Compute Engine n1-standard-1660GBOpenBenchmarking.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- 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-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 comparisonPersistentDiskn1-standard-1615.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.30217.8250.35824.1406.3278.7326.1288.63415.56923.568287.5496.9255.59540.562152.7331073724726697568438249211182134730.0744432.2681277120.3981535050.6521376171.81863678.59693520.108452222.945399630.0182564.0111029470.48687400.1201048490.9841072422.333329715.1763772.7351024180.491OpenBenchmarking.org

LevelDB

Benchmark: Hot Read

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Hot ReadGCE VM comparisonn1-standard-1648121620SE +/- 0.12, N = 12SE +/- 0.25, N = 1515.0817.831. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Fill Sync

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Fill SyncGCE VM comparisonn1-standard-160.15750.3150.47250.630.7875SE +/- 0.01, N = 13SE +/- 0.00, N = 30.70.31. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Fill Sync

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Fill SyncGCE VM comparisonn1-standard-1612002400360048006000SE +/- 9.53, N = 13SE +/- 48.29, N = 32385.155824.141. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Overwrite

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: OverwriteGCE VM comparisonn1-standard-1648121620SE +/- 0.00, N = 3SE +/- 0.03, N = 315.86.31. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Overwrite

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: OverwriteGCE VM comparisonn1-standard-1660120180240300SE +/- 0.07, N = 3SE +/- 1.19, N = 3112.04278.731. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Random Fill

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Random FillGCE VM comparisonn1-standard-1648121620SE +/- 0.00, N = 3SE +/- 0.03, N = 315.86.11. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Random Fill

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random FillGCE VM comparisonn1-standard-1660120180240300SE +/- 0.14, N = 3SE +/- 1.47, N = 3111.92288.631. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Random Read

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random ReadGCE VM comparisonn1-standard-1648121620SE +/- 0.13, N = 3SE +/- 0.03, N = 315.4515.571. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Seek Random

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Seek RandomGCE VM comparisonn1-standard-16612182430SE +/- 0.09, N = 3SE +/- 0.29, N = 1219.1023.571. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Random Delete

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random DeleteGCE VM comparisonn1-standard-1660120180240300SE +/- 0.17, N = 3SE +/- 2.15, N = 3110.88287.551. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Sequential Fill

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Sequential FillGCE VM comparisonn1-standard-1648121620SE +/- 0.00, N = 3SE +/- 0.09, N = 315.86.91. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Sequential Fill

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Sequential FillGCE VM comparisonn1-standard-1660120180240300SE +/- 0.09, N = 3SE +/- 3.35, N = 3111.95255.601. (CXX) g++ options: -O3 -lsnappy -lpthread

SQLite

Threads / Copies: 1

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1GCE VM comparisonn1-standard-16918273645SE +/- 0.09, N = 3SE +/- 0.57, N = 1416.7240.561. (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 comparisonn1-standard-16306090120150SE +/- 0.21, N = 3SE +/- 0.48, N = 397.71152.73

MariaDB

Clients: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 1GCE VM comparisonn1-standard-166001200180024003000SE +/- 7.83, N = 3SE +/- 32.77, N = 12298210731. (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 comparisonn1-standard-16400800120016002000SE +/- 27.37, N = 15SE +/- 21.12, N = 919347241. (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 comparisonn1-standard-16400800120016002000SE +/- 7.88, N = 3SE +/- 19.41, N = 718147261. (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 comparisonn1-standard-16400800120016002000SE +/- 5.63, N = 3SE +/- 18.42, N = 916756971. (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: 32GCE VM comparisonn1-standard-1630060090012001500SE +/- 3.37, N = 3SE +/- 14.09, N = 813475681. (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: 64GCE VM comparisonn1-standard-162004006008001000SE +/- 10.98, N = 3SE +/- 7.56, N = 99724381. (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: 128GCE VM comparisonn1-standard-1680160240320400SE +/- 4.54, N = 3SE +/- 2.34, N = 93522491. (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: 256GCE VM comparisonn1-standard-1660120180240300SE +/- 3.49, N = 3SE +/- 2.78, N = 32952111. (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: 512GCE VM comparisonn1-standard-1660120180240300SE +/- 2.22, N = 3SE +/- 0.17, N = 32611821. (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 OnlyGCE VM comparisonn1-standard-165K10K15K20K25KSE +/- 97.18, N = 3SE +/- 125.37, N = 1522019134731. (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 comparisonn1-standard-160.01670.03340.05010.06680.0835SE +/- 0.000, N = 3SE +/- 0.001, N = 150.0450.0741. (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 WriteGCE VM comparisonn1-standard-1630060090012001500SE +/- 5.60, N = 3SE +/- 8.21, N = 1212254431. (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 LatencyGCE VM comparisonn1-standard-160.51031.02061.53092.04122.5515SE +/- 0.004, N = 3SE +/- 0.043, N = 120.8162.2681. (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 OnlyGCE VM comparisonn1-standard-1650K100K150K200K250KSE +/- 122.97, N = 3SE +/- 4821.33, N = 122142891277121. (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 LatencyGCE VM comparisonn1-standard-160.08960.17920.26880.35840.448SE +/- 0.000, N = 3SE +/- 0.015, N = 120.2330.3981. (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 OnlyGCE VM comparisonn1-standard-1650K100K150K200K250KSE +/- 1123.14, N = 3SE +/- 161.20, N = 32260791535051. (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 LatencyGCE VM comparisonn1-standard-160.14670.29340.44010.58680.7335SE +/- 0.002, N = 3SE +/- 0.001, N = 30.4430.6521. (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 comparisonn1-standard-1650K100K150K200K250KSE +/- 337.36, N = 3SE +/- 775.69, N = 32155911376171. (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 comparisonn1-standard-160.40910.81821.22731.63642.0455SE +/- 0.002, N = 3SE +/- 0.010, N = 31.1601.8181. (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 WriteGCE VM comparisonn1-standard-1630060090012001500SE +/- 15.59, N = 3SE +/- 4.70, N = 315146361. (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 LatencyGCE VM comparisonn1-standard-1620406080100SE +/- 0.34, N = 3SE +/- 0.58, N = 333.0478.601. (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 comparisonn1-standard-164K8K12K16K20KSE +/- 66.76, N = 3SE +/- 289.13, N = 121875493521. (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 comparisonn1-standard-160.02430.04860.07290.09720.1215SE +/- 0.000, N = 3SE +/- 0.004, N = 120.0530.1081. (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 comparisonn1-standard-1630060090012001500SE +/- 9.46, N = 3SE +/- 11.94, N = 1214314521. (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 comparisonn1-standard-1650100150200250SE +/- 0.46, N = 3SE +/- 5.86, N = 1269.90222.951. (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 WriteGCE VM comparisonn1-standard-1630060090012001500SE +/- 7.63, N = 3SE +/- 8.18, N = 1212293991. (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 comparisonn1-standard-16140280420560700SE +/- 1.26, N = 3SE +/- 12.61, N = 12203.47630.021. (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 WriteGCE VM comparisonn1-standard-162004006008001000SE +/- 38.28, N = 15SE +/- 11.37, N = 158782561. (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 LatencyGCE VM comparisonn1-standard-160.90251.8052.70753.614.5125SE +/- 0.053, N = 15SE +/- 0.181, N = 151.1704.0111. (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 OnlyGCE VM comparisonn1-standard-1640K80K120K160K200KSE +/- 430.51, N = 3SE +/- 981.93, N = 31734391029471. (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 LatencyGCE VM comparisonn1-standard-160.10940.21880.32820.43760.547SE +/- 0.001, N = 3SE +/- 0.005, N = 30.2880.4861. (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 OnlyGCE VM comparisonn1-standard-164K8K12K16K20KSE +/- 236.08, N = 3SE +/- 623.11, N = 81725287401. (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 LatencyGCE VM comparisonn1-standard-160.0270.0540.0810.1080.135SE +/- 0.001, N = 3SE +/- 0.011, N = 80.0580.1201. (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 OnlyGCE VM comparisonn1-standard-1640K80K120K160K200KSE +/- 189.06, N = 3SE +/- 4338.69, N = 151826591048491. (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 LatencyGCE VM comparisonn1-standard-160.22140.44280.66420.88561.107SE +/- 0.001, N = 3SE +/- 0.051, N = 150.5480.9841. (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 OnlyGCE VM comparisonn1-standard-1640K80K120K160K200KSE +/- 459.20, N = 3SE +/- 151.18, N = 31661511072421. (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 LatencyGCE VM comparisonn1-standard-160.52491.04981.57472.09962.6245SE +/- 0.004, N = 3SE +/- 0.003, N = 31.5052.3331. (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 WriteGCE VM comparisonn1-standard-167001400210028003500SE +/- 47.44, N = 3SE +/- 39.30, N = 3335632971. (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 LatencyGCE VM comparisonn1-standard-1648121620SE +/- 0.21, N = 3SE +/- 0.18, N = 314.9115.181. (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 comparisonn1-standard-1630060090012001500SE +/- 4.20, N = 3SE +/- 24.53, N = 711683771. (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 comparisonn1-standard-160.61541.23081.84622.46163.077SE +/- 0.003, N = 3SE +/- 0.206, N = 70.8562.7351. (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 OnlyGCE VM comparisonn1-standard-1640K80K120K160K200KSE +/- 1045.49, N = 3SE +/- 2705.85, N = 91653751024181. (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 LatencyGCE VM comparisonn1-standard-160.11050.2210.33150.4420.5525SE +/- 0.002, N = 3SE +/- 0.013, N = 90.3020.4911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4