pg

KVM testing on CentOS Linux 7 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2101103-TY-PG955133016.

pgProcessorMotherboardMemoryDiskGraphicsOSKernelCompilerFile-SystemScreen ResolutionSystem LayerIntel Xeon Gold 6278C - cirrusdrmfb - OpenStackIntel Xeon Gold 6278C @ 2.60GHz (4 Cores)OpenStack Foundation Nova1 x 8192 MB RAM QEMU40GBcirrusdrmfbCentOS Linux 73.10.0-1160.11.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 6278C - cirrusdrmfb - OpenStack59743882OpenBenchmarking.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 6278C - cirrusdrmfb - OpenStack13002600390052006500SE +/- 66.71, N = 359741. (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 6278C - cirrusdrmfb - OpenStack48121620SE +/- 0.19, N = 316.751. (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 6278C - cirrusdrmfb - OpenStack8001600240032004000SE +/- 74.25, N = 338821. (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 6278C - cirrusdrmfb - OpenStack612182430SE +/- 0.49, N = 325.781. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4