postgres-testing

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

HTML result view exported from: https://openbenchmarking.org/result/1907045-HV-1907035HV15.

postgres-testingProcessorMotherboardMemoryDiskGraphicsChipsetNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem Layerpostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbCommon KVM (8 Cores)QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS)1 x 16384 MB RAM QEMU21GB QEMU HDD + 27GB QEMU HDDbochsdrmfbCentOS Linux 73.10.0-957.21.2.el7.x86_64 (x86_64)GCC 4.8.5 20150623xfs1024x768KVM4 x Intel Xeon E5-2697 v4 (8 Cores)Intel 440BX (6.00 BIOS)Intel 440BX/ZX/DX1 x 16384 MB DRAM16GB Virtual disk + 54GB Virtual disk + 11GB Virtual diskVMware SVGA IIVMware VMXNET33.10.0-957.21.3.el7.x86_64 (x86_64)1176x885VMwareOpenBenchmarking.orgCompiler Details- --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 Security Details- postgres-current: l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of Load fences __user pointer sanitization + spectre_v2: Vulnerable: Retpoline without IBPB- postgres-hugepages: l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of Load fences __user pointer sanitization + spectre_v2: Vulnerable: Retpoline without IBPB- postgres-hugepages-noTHP-noCommit: l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of Load fences __user pointer sanitization + spectre_v2: Vulnerable: Retpoline without IBPB- postgres-hugepages-noTHP-noCommit-dirty: l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of Load fences __user pointer sanitization + spectre_v2: Vulnerable: Retpoline without IBPB- postgres-prod-current: SELinux + l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of Load fences __user pointer sanitization + spectre_v2: Vulnerable: Retpoline without IBPB- postgres-prod-HP-noTHP-noOverC-dirty: SELinux + l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of Load fences __user pointer sanitization + spectre_v2: Vulnerable: Retpoline without IBPB- postgres-prod-HP-noTHP-noOverC-dirty-1gb: SELinux + l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of Load fences __user pointer sanitization + spectre_v2: Vulnerable: Retpoline without IBPB

postgres-testingpgbench: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Onlypgbench: Mostly RAM - Normal Load - Read Onlypgbench: On-Disk - Single Thread - Read Writepgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Single Thread - Read Onlypgbench: On-Disk - Heavy Contention - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: Mostly RAM - Single Thread - Read Writepgbench: On-Disk - Heavy Contention - Read Writepgbench: Buffer Test - Single Thread - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - Read Writepostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb6405279871826469697.20499791867581773866801460532017974046909450680179659526510581169566610098.28551151892597769626994464422038144206986658217180362136592880973666455898.23550291883597973786955065052038184137037659392180462106534980074206618997.1255165187465647559687136421202811457709915825818316947947399711090094835113.197051421185658108519988589152329664321005877404022186773972409581097193955102.98750882080518510779987608973196963392977637951121616853953539631099795616106.397497520794598108949827589312019724331000318005822137544OpenBenchmarking.org

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Normal Load - Mode: Read Onlypostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KSE +/- 303.57, N = 3SE +/- 32.79, N = 3SE +/- 346.18, N = 3SE +/- 418.70, N = 3SE +/- 509.30, N = 3SE +/- 737.58, N = 3SE +/- 522.40, N = 3640526510565928653499473997240953531. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Normal Load - Mode: Read Writepostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2004006008001000SE +/- 1.59, N = 3SE +/- 1.53, N = 3SE +/- 3.02, N = 3SE +/- 8.49, N = 3SE +/- 0.69, N = 3SE +/- 2.12, N = 3SE +/- 1.82, N = 37988118098009719589631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Single Thread - Mode: Read Onlypostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2K4K6K8K10KSE +/- 95.98, N = 9SE +/- 69.67, N = 3SE +/- 61.66, N = 3SE +/- 84.35, N = 9SE +/- 71.05, N = 3SE +/- 76.82, N = 3SE +/- 64.04, N = 371826956736674201090010971109971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Onlypostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KSE +/- 274.59, N = 3SE +/- 141.73, N = 3SE +/- 148.38, N = 3SE +/- 302.74, N = 3SE +/- 668.66, N = 3SE +/- 728.14, N = 3SE +/- 87.10, N = 3646966610064558661899483593955956161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Single Thread - Mode: Read Writepostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb306090120150SE +/- 0.37, N = 3SE +/- 0.59, N = 3SE +/- 0.45, N = 3SE +/- 1.08, N = 3SE +/- 0.22, N = 3SE +/- 1.52, N = 4SE +/- 1.16, N = 997.2098.2898.2397.12113.19102.98106.391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Onlypostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb16K32K48K64K80KSE +/- 360.17, N = 3SE +/- 54.15, N = 3SE +/- 110.86, N = 3SE +/- 130.16, N = 3SE +/- 208.99, N = 3SE +/- 274.89, N = 3SE +/- 248.44, N = 3499795511555029551657051475088749751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Writepostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb5001000150020002500SE +/- 0.37, N = 3SE +/- 7.28, N = 3SE +/- 3.77, N = 3SE +/- 3.46, N = 3SE +/- 9.22, N = 3SE +/- 2.15, N = 3SE +/- 10.83, N = 318671892188318742118208020791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Writepostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb14002800420056007000SE +/- 15.73, N = 3SE +/- 30.28, N = 3SE +/- 20.59, N = 3SE +/- 18.49, N = 3SE +/- 144.65, N = 12SE +/- 64.45, N = 4SE +/- 131.14, N = 1558175977597965645658518545981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read Onlypostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2K4K6K8K10KSE +/- 93.75, N = 3SE +/- 97.48, N = 3SE +/- 76.33, N = 3SE +/- 90.74, N = 3SE +/- 29.97, N = 3SE +/- 64.28, N = 3SE +/- 88.89, N = 373866962737875591085110779108941. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Onlypostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KSE +/- 1051.18, N = 3SE +/- 729.80, N = 3SE +/- 1198.08, N = 3SE +/- 618.15, N = 3SE +/- 875.03, N = 3SE +/- 344.54, N = 3SE +/- 797.07, N = 3680146994469550687139988598760982751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read Onlypostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2K4K6K8K10KSE +/- 79.57, N = 4SE +/- 76.22, N = 6SE +/- 14.49, N = 3SE +/- 50.50, N = 3SE +/- 54.96, N = 3SE +/- 53.11, N = 3SE +/- 28.02, N = 360536442650564218915897389311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read Writepostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb50100150200250SE +/- 2.20, N = 3SE +/- 0.15, N = 3SE +/- 2.27, N = 9SE +/- 0.37, N = 3SE +/- 1.84, N = 3SE +/- 3.07, N = 3SE +/- 4.39, N = 92012032032022321962011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Writepostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2004006008001000SE +/- 4.66, N = 3SE +/- 3.11, N = 3SE +/- 2.26, N = 3SE +/- 6.93, N = 3SE +/- 10.74, N = 3SE +/- 4.93, N = 3SE +/- 1.79, N = 37978148188119669639721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read Writepostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb100200300400500SE +/- 5.18, N = 3SE +/- 2.76, N = 3SE +/- 4.80, N = 3SE +/- 2.48, N = 3SE +/- 4.92, N = 15SE +/- 6.51, N = 3SE +/- 6.01, N = 34044204134574323924331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Onlypostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KSE +/- 1040.39, N = 3SE +/- 997.76, N = 3SE +/- 780.38, N = 3SE +/- 917.87, N = 3SE +/- 365.17, N = 3SE +/- 493.53, N = 3SE +/- 514.67, N = 369094698667037670991100587977631000311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Onlypostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KSE +/- 106.35, N = 3SE +/- 688.68, N = 3SE +/- 799.98, N = 3SE +/- 811.04, N = 3SE +/- 108.66, N = 3SE +/- 607.26, N = 3SE +/- 146.48, N = 3506805821759392582587404079511800581. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Writepostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb5001000150020002500SE +/- 23.52, N = 9SE +/- 30.15, N = 3SE +/- 25.78, N = 3SE +/- 10.03, N = 3SE +/- 24.18, N = 9SE +/- 26.67, N = 3SE +/- 16.19, N = 317961803180418312218216122131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Writepostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb16003200480064008000SE +/- 10.27, N = 3SE +/- 76.69, N = 3SE +/- 81.81, N = 5SE +/- 10.15, N = 3SE +/- 128.29, N = 13SE +/- 70.13, N = 3SE +/- 79.70, N = 759526213621069476773685375441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4