postgres-testing

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

HTML result view exported from: https://openbenchmarking.org/result/1907050-HV-1907057HV29&sro.

postgres-testingProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem Layerpostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-HP-noTHP-noOverC-dirty-noMiti4 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 VMXNET3CentOS Linux 73.10.0-957.21.3.el7.x86_64 (x86_64)GCC 4.8.5 20150623xfs1176x885VMware16GB Virtual disk + 64GB Virtual disk + 11GB Virtual diskOpenBenchmarking.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-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-prod-HP-noTHP-noOverC-dirty-256m: 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-noDirty: 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-noMiti: 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

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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-HP-noTHP-noOverC-dirty-noMiti94739971109009483511370514211856581085199885891523296643210058774040221867739724095810971939551037508820805185107799876089731969633929776379511216168539535396310997956161067497520794598108949827589312019724331000318005822137544947339571081993299103752661998471110791995308921214956386995218091922026746935769551073695226111754742129633911036100119897222796152599366801272258788199431965112719722410176556205248631109210249292002149554251007407997822057113OpenBenchmarking.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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current20K40K60K80K100KSE +/- 737.58, N = 3SE +/- 522.40, N = 3SE +/- 673.07, N = 3SE +/- 1265.69, N = 4SE +/- 584.73, N = 3SE +/- 509.30, N = 39724095353947339943193576947391. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current2004006008001000SE +/- 2.12, N = 3SE +/- 1.82, N = 3SE +/- 5.47, N = 3SE +/- 5.03, N = 3SE +/- 2.19, N = 3SE +/- 0.69, N = 39589639579659559711. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current2K4K6K8K10KSE +/- 76.82, N = 3SE +/- 64.04, N = 3SE +/- 166.71, N = 3SE +/- 81.14, N = 3SE +/- 119.56, N = 3SE +/- 71.05, N = 31097110997108191127110736109001. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current20K40K60K80K100KSE +/- 728.14, N = 3SE +/- 87.10, N = 3SE +/- 598.04, N = 3SE +/- 455.24, N = 3SE +/- 438.14, N = 3SE +/- 668.66, N = 39395595616932999722495226948351. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current306090120150SE +/- 1.52, N = 4SE +/- 1.16, N = 9SE +/- 1.15, N = 3SE +/- 1.10, N = 3SE +/- 0.59, N = 3SE +/- 0.22, N = 31031061031011111131. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current16K32K48K64K80KSE +/- 274.89, N = 3SE +/- 248.44, N = 3SE +/- 356.45, N = 3SE +/- 325.99, N = 3SE +/- 294.29, N = 3SE +/- 208.99, N = 37508874975752667655675474705141. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current5001000150020002500SE +/- 2.15, N = 3SE +/- 10.83, N = 3SE +/- 24.45, N = 6SE +/- 1.37, N = 3SE +/- 18.39, N = 3SE +/- 9.22, N = 32080207919982052212921181. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current14002800420056007000SE +/- 64.45, N = 4SE +/- 131.14, N = 15SE +/- 71.24, N = 3SE +/- 92.13, N = 15SE +/- 127.59, N = 12SE +/- 144.65, N = 125185459847114863633956581. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current2K4K6K8K10KSE +/- 64.28, N = 3SE +/- 88.89, N = 3SE +/- 48.23, N = 3SE +/- 79.23, N = 3SE +/- 47.28, N = 3SE +/- 29.97, N = 31077910894107911109211036108511. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current20K40K60K80K100KSE +/- 344.54, N = 3SE +/- 797.07, N = 3SE +/- 268.74, N = 3SE +/- 1052.10, N = 3SE +/- 542.05, N = 3SE +/- 875.03, N = 3987609827599530102492100119998851. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current2K4K6K8K10KSE +/- 53.11, N = 3SE +/- 28.02, N = 3SE +/- 83.01, N = 3SE +/- 27.13, N = 3SE +/- 50.74, N = 3SE +/- 54.96, N = 38973893189219200897289151. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current50100150200250SE +/- 3.07, N = 3SE +/- 4.39, N = 9SE +/- 1.29, N = 3SE +/- 1.09, N = 3SE +/- 3.43, N = 3SE +/- 1.84, N = 31962012142142272321. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current2004006008001000SE +/- 4.93, N = 3SE +/- 1.79, N = 3SE +/- 4.00, N = 3SE +/- 8.50, N = 3SE +/- 12.77, N = 9SE +/- 10.74, N = 39639729569559619661. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current110220330440550SE +/- 6.51, N = 3SE +/- 6.01, N = 3SE +/- 1.47, N = 3SE +/- 4.01, N = 9SE +/- 7.41, N = 3SE +/- 4.92, N = 153924333864255254321. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current20K40K60K80K100KSE +/- 493.53, N = 3SE +/- 514.67, N = 3SE +/- 206.20, N = 3SE +/- 629.92, N = 3SE +/- 342.36, N = 3SE +/- 365.17, N = 39776310003199521100740993661005871. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current20K40K60K80K100KSE +/- 607.26, N = 3SE +/- 146.48, N = 3SE +/- 390.00, N = 3SE +/- 386.83, N = 3SE +/- 223.99, N = 3SE +/- 108.66, N = 37951180058809197997880127740401. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current5001000150020002500SE +/- 26.67, N = 3SE +/- 16.19, N = 3SE +/- 32.55, N = 3SE +/- 32.86, N = 3SE +/- 35.92, N = 3SE +/- 24.18, N = 92161221322022205225822181. (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-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-noMitipostgres-prod-HP-noTHP-noOverC-noDirtypostgres-prod-current2K4K6K8K10KSE +/- 70.13, N = 3SE +/- 79.70, N = 7SE +/- 202.80, N = 14SE +/- 93.49, N = 3SE +/- 54.65, N = 3SE +/- 128.29, N = 136853754467467113788167731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm


Phoronix Test Suite v10.8.4