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&grt&sro.

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-comparisoncouchdb: 100 - 1000 - 24leveldb: Hot Readleveldb: Fill Syncleveldb: Fill Syncleveldb: Overwriteleveldb: Overwriteleveldb: Rand Fillleveldb: Rand Fillleveldb: Rand Readleveldb: Seek Randleveldb: Rand Deleteleveldb: Seq Fillleveldb: Seq Fillmysqlslap: 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 Latencysqlite: 1GCE VM comparisonPersistentDiskc2-standard-16c2-standard-16 297.71415.0830.72385.14715.8112.04115.8111.92115.45019.103110.87915.8111.94629821934181416751347972352295261220190.04512250.8162142890.2332260790.4432155911.160151433.040187540.053143169.8991229203.4698781.1701734390.288172520.0581826590.5481661511.505335614.90511680.8561653750.30216.724122.96014.4490.82318.08515.9111.54815.8111.62615.10818.792111.05915.8112.15930491922179616201334100535829025416.925119.77615.1590.82319.44215.8111.94415.7112.12615.63719.220110.99815.8111.593298818671811167213641007358303267221560.04512480.8022214230.2262329210.4302152421.162151533.017186500.053139971.5551230203.5529711.0461774640.282175420.0571849860.5411678591.490344014.54911260.8881694370.29516.906OpenBenchmarking.org

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-16c2-standard-16 2306090120150SE +/- 0.21, N = 3SE +/- 0.67, N = 3SE +/- 0.23, N = 397.71122.96119.781. (CXX) g++ options: -std=c++14 -lmozjs-68 -lm -lerl_interface -lei -fPIC -MMD

LevelDB

Benchmark: Hot Read

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

LevelDB

Benchmark: Fill Sync

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Fill SyncGCE VM comparisonc2-standard-16c2-standard-16 20.180.360.540.720.9SE +/- 0.01, N = 13SE +/- 0.01, N = 12SE +/- 0.00, N = 30.70.80.81. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Fill Sync

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Fill SyncGCE VM comparisonc2-standard-16c2-standard-16 25001000150020002500SE +/- 9.53, N = 13SE +/- 7.31, N = 12SE +/- 13.05, N = 32385.152318.092319.441. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Overwrite

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

LevelDB

Benchmark: Overwrite

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: OverwriteGCE VM comparisonc2-standard-16c2-standard-16 2306090120150SE +/- 0.07, N = 3SE +/- 0.41, N = 3SE +/- 0.24, N = 3112.04111.55111.941. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Random Fill

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Random FillGCE VM comparisonc2-standard-16c2-standard-16 248121620SE +/- 0.00, N = 3SE +/- 0.03, 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 FillGCE VM comparisonc2-standard-16c2-standard-16 2306090120150SE +/- 0.14, N = 3SE +/- 0.19, N = 3SE +/- 0.21, N = 3111.92111.63112.131. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Random Read

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

LevelDB

Benchmark: Seek Random

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Seek RandomGCE VM comparisonc2-standard-16c2-standard-16 2510152025SE +/- 0.09, N = 3SE +/- 0.18, N = 3SE +/- 0.03, N = 319.1018.7919.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-16c2-standard-16 220406080100SE +/- 0.17, N = 3SE +/- 0.06, N = 3SE +/- 0.05, N = 3110.88111.06111.001. (CXX) g++ options: -O3 -lsnappy -lpthread

LevelDB

Benchmark: Sequential Fill

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Sequential FillGCE VM comparisonc2-standard-16c2-standard-16 248121620SE +/- 0.00, N = 3SE +/- 0.03, N = 3SE +/- 0.03, 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 FillGCE VM comparisonc2-standard-16c2-standard-16 2306090120150SE +/- 0.09, N = 3SE +/- 0.36, N = 3SE +/- 0.16, N = 3111.95112.16111.591. (CXX) g++ options: -O3 -lsnappy -lpthread

MariaDB

Clients: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 1GCE VM comparisonc2-standard-16c2-standard-16 27001400210028003500SE +/- 7.83, N = 3SE +/- 16.10, N = 3SE +/- 19.40, N = 32982304929881. (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-16c2-standard-16 2400800120016002000SE +/- 7.88, N = 3SE +/- 5.68, N = 3SE +/- 22.20, N = 31814179618111. (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-16c2-standard-16 2400800120016002000SE +/- 5.63, N = 3SE +/- 0.87, N = 3SE +/- 6.46, N = 31675162016721. (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 comparisonc2-standard-16c2-standard-16 230060090012001500SE +/- 3.37, N = 3SE +/- 4.29, N = 3SE +/- 1.86, N = 31347133413641. (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 comparisonc2-standard-16c2-standard-16 22004006008001000SE +/- 10.98, N = 3SE +/- 1.21, N = 3SE +/- 2.34, N = 3972100510071. (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 comparisonc2-standard-16c2-standard-16 280160240320400SE +/- 4.54, N = 3SE +/- 2.11, N = 3SE +/- 4.10, N = 43523583581. (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 comparisonc2-standard-16c2-standard-16 270140210280350SE +/- 3.49, N = 3SE +/- 1.23, N = 3SE +/- 1.49, N = 32952903031. (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 comparisonc2-standard-16c2-standard-16 260120180240300SE +/- 2.22, N = 3SE +/- 2.04, N = 3SE +/- 0.79, N = 32612542671. (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 comparisonc2-standard-16 25K10K15K20K25KSE +/- 97.18, N = 3SE +/- 138.94, N = 322019221561. (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 WriteGCE VM comparisonc2-standard-16 230060090012001500SE +/- 5.60, N = 3SE +/- 5.34, N = 3122512481. (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 comparisonc2-standard-16 20.18360.36720.55080.73440.918SE +/- 0.004, N = 3SE +/- 0.003, N = 30.8160.8021. (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 comparisonc2-standard-16 250K100K150K200K250KSE +/- 122.97, N = 3SE +/- 692.05, N = 32142892214231. (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 comparisonc2-standard-16 20.05240.10480.15720.20960.262SE +/- 0.000, N = 3SE +/- 0.001, N = 30.2330.2261. (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 comparisonc2-standard-16 250K100K150K200K250KSE +/- 1123.14, N = 3SE +/- 560.73, N = 32260792329211. (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 comparisonc2-standard-16 20.09970.19940.29910.39880.4985SE +/- 0.002, N = 3SE +/- 0.001, N = 30.4430.4301. (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 WriteGCE VM comparisonc2-standard-16 230060090012001500SE +/- 15.59, N = 3SE +/- 19.63, N = 3151415151. (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 comparisonc2-standard-16 2816243240SE +/- 0.34, N = 3SE +/- 0.43, N = 333.0433.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 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 WriteGCE VM comparisonc2-standard-16 230060090012001500SE +/- 7.63, N = 3SE +/- 9.63, N = 15122912301. (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 WriteGCE VM comparisonc2-standard-16 22004006008001000SE +/- 38.28, N = 15SE +/- 29.34, N = 148789711. (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 comparisonc2-standard-16 20.26330.52660.78991.05321.3165SE +/- 0.053, N = 15SE +/- 0.039, N = 141.1701.0461. (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 comparisonc2-standard-16 240K80K120K160K200KSE +/- 430.51, N = 3SE +/- 393.03, N = 31734391774641. (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 comparisonc2-standard-16 20.06480.12960.19440.25920.324SE +/- 0.001, N = 3SE +/- 0.001, N = 30.2880.2821. (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 comparisonc2-standard-16 24K8K12K16K20KSE +/- 236.08, N = 3SE +/- 97.76, N = 317252175421. (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 comparisonc2-standard-16 20.01310.02620.03930.05240.0655SE +/- 0.001, N = 3SE +/- 0.000, N = 30.0580.0571. (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 comparisonc2-standard-16 240K80K120K160K200KSE +/- 189.06, N = 3SE +/- 82.80, N = 31826591849861. (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 comparisonc2-standard-16 20.12330.24660.36990.49320.6165SE +/- 0.001, N = 3SE +/- 0.000, N = 30.5480.5411. (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 comparisonc2-standard-16 240K80K120K160K200KSE +/- 459.20, N = 3SE +/- 267.29, N = 31661511678591. (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 comparisonc2-standard-16 20.33860.67721.01581.35441.693SE +/- 0.004, N = 3SE +/- 0.002, N = 31.5051.4901. (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 comparisonc2-standard-16 27001400210028003500SE +/- 47.44, N = 3SE +/- 27.58, N = 15335634401. (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 comparisonc2-standard-16 248121620SE +/- 0.21, N = 3SE +/- 0.12, N = 1514.9114.551. (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 OnlyGCE VM comparisonc2-standard-16 240K80K120K160K200KSE +/- 1045.49, N = 3SE +/- 196.98, N = 31653751694371. (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 comparisonc2-standard-16 20.0680.1360.2040.2720.34SE +/- 0.002, N = 3SE +/- 0.000, N = 30.3020.2951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

SQLite

Threads / Copies: 1

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

Phoronix Test Suite v10.8.4