pg

KVM testing on CentOS 7.5.1804 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2101125-TY-PG847824016&gru.

pgProcessorMotherboardMemoryDiskGraphicsOSKernelCompilerFile-SystemScreen ResolutionSystem LayerIntel Xeon Gold 6151 - cirrusdrmfb - OpenStackIntel Xeon Gold 6151 @ 3.00GHz (4 Cores)OpenStack Foundation Nova1 x 8192 MB RAM QEMU40GBcirrusdrmfbCentOS 7.5.18043.10.0-1160.6.1.el7.x86_64 (x86_64)GCC 4.8.5 20150623ext41024x768KVMOpenBenchmarking.org- --build=x86_64-redhat-linux --disable-libgcj --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,objc,obj-c++,java,fortran,ada,go,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-linker-hash-style=gnu --with-tune=generic

pgpgbench: 1000 - 100 - Read Onlypgbench: 1000 - 100 - Read WriteIntel Xeon Gold 6151 - cirrusdrmfb - OpenStack70743924OpenBenchmarking.org

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read OnlyIntel Xeon Gold 6151 - cirrusdrmfb - OpenStack15003000450060007500SE +/- 49.84, N = 370741. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read WriteIntel Xeon Gold 6151 - cirrusdrmfb - OpenStack8001600240032004000SE +/- 40.61, N = 339241. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average LatencyIntel Xeon Gold 6151 - cirrusdrmfb - OpenStack48121620SE +/- 0.10, N = 314.141. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyIntel Xeon Gold 6151 - cirrusdrmfb - OpenStack612182430SE +/- 0.26, N = 325.501. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4