postgres-testing

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

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1907035-HV-1907029HV33
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
postgres-current
June 13 2019
  12 Hours, 6 Minutes
postgres-hugepages
June 14 2019
  9 Hours, 9 Minutes
postgres-hugepages-noTHP-noCommit
June 19 2019
  10 Hours, 24 Minutes
postgres-hugepages-noTHP-noCommit-dirty
June 20 2019
  11 Hours, 6 Minutes
postgres-prod-current
July 01 2019
  5 Hours, 42 Minutes
postgres-prod-HP-noTHP-noOverC-dirty
July 02 2019
  6 Hours, 1 Minute
Invert Hiding All Results Option
  9 Hours, 5 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

postgres-current

Compiler Notes: --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 Notes: 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

postgres-hugepages-noTHP-noCommit

postgres-hugepages-noTHP-noCommit-dirty

Processor: Common KVM (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Memory: 1 x 16384 MB RAM QEMU, Disk: 21GB QEMU HDD + 27GB QEMU HDD, Graphics: bochsdrmfb

OS: CentOS Linux 7, Kernel: 3.10.0-957.21.2.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM

postgres-prod-current

Compiler Notes: --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 Notes: 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

Processor: 4 x Intel Xeon E5-2697 v4 (8 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 1 x 16384 MB DRAM, Disk: 16GB Virtual disk + 54GB Virtual disk + 11GB Virtual disk, Graphics: VMware SVGA II, Network: VMware VMXNET3

OS: CentOS Linux 7, Kernel: 3.10.0-957.21.3.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1176x885, System Layer: VMware

postgres-testingProcessorMotherboardMemoryDiskGraphicsChipsetNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem Layerpostgres-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtyCommon 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-currentpostgres-hugepagespostgres-hugepages-noTHP-noCommitpostgres-hugepages-noTHP-noCommit-dirtypostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtyResult OverviewPhoronix Test Suite100%114%129%143%158%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchOn-Disk - Single Thread - Read OnlyBuffer Test - Heavy Contention - Read OnlyMostly RAM - Single Thread - Read OnlyOn-Disk - Normal Load - Read OnlyBuffer Test - Normal Load - Read OnlyBuffer Test - Single Thread - Read OnlyMostly RAM - Normal Load - Read OnlyOn-Disk - Heavy Contention - Read OnlyMostly RAM - Heavy Contention - Read OnlyBuffer Test - Normal Load - Read WriteMostly RAM - Heavy Contention - Read WriteOn-Disk - Normal Load - Read WriteOn-Disk - Heavy Contention - Read WriteMostly RAM - Single Thread - Read WriteBuffer Test - Heavy Contention - Read WriteBuffer Test - Single Thread - Read WriteOn-Disk - Single Thread - Read WriteMostly RAM - Normal Load - Read Write

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-dirty6405279871826469697.20499791867581773866801460532017974046909450680179659526510581169566610098.28551151892597769626994464422038144206986658217180362136592880973666455898.23550291883597973786955065052038184137037659392180462106534980074206618997.1255165187465647559687136421202811457709915825818316947947399711090094835113.197051421185658108519988589152329664321005877404022186773972409581097193955102.98750882080518510779987608973196963392977637951121616853OpenBenchmarking.org

PostgreSQL pgbench

This is a simple benchmark of PostgreSQL using pgbench. Learn more via the OpenBenchmarking.org test page.

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-dirty20K40K60K80K100KSE +/- 303.57, N = 3SE +/- 32.79, N = 3SE +/- 346.18, N = 3SE +/- 418.70, N = 3SE +/- 509.30, N = 3SE +/- 737.58, N = 36405265105659286534994739972401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty20K40K60K80K100KMin: 63449.43 / Avg: 64051.54 / Max: 64420.18Min: 65040.53 / Avg: 65105.03 / Max: 65147.48Min: 65388.46 / Avg: 65927.77 / Max: 66573.43Min: 64608.18 / Avg: 65349.08 / Max: 66057.52Min: 93884.56 / Avg: 94739.41 / Max: 95646.51Min: 95844.47 / Avg: 97239.52 / Max: 98352.311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty2004006008001000SE +/- 1.59, N = 3SE +/- 1.53, N = 3SE +/- 3.02, N = 3SE +/- 8.49, N = 3SE +/- 0.69, N = 3SE +/- 2.12, N = 37988118098009719581. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty2004006008001000Min: 796.1 / Avg: 797.94 / Max: 801.11Min: 808.47 / Avg: 811.05 / Max: 813.78Min: 803.65 / Avg: 809.26 / Max: 813.99Min: 783.06 / Avg: 800.04 / Max: 808.74Min: 969.76 / Avg: 971.13 / Max: 971.96Min: 954.78 / Avg: 958.34 / Max: 962.111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty2K4K6K8K10KSE +/- 95.98, N = 9SE +/- 69.67, N = 3SE +/- 61.66, N = 3SE +/- 84.35, N = 9SE +/- 71.05, N = 3SE +/- 76.82, N = 3718269567366742010900109711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty2K4K6K8K10KMin: 6622.45 / Avg: 7181.66 / Max: 7504.42Min: 6884.6 / Avg: 6956.3 / Max: 7095.63Min: 7269.13 / Avg: 7366.2 / Max: 7480.6Min: 6917.72 / Avg: 7420.46 / Max: 7682.37Min: 10766.76 / Avg: 10900.15 / Max: 11009.24Min: 10838.78 / Avg: 10971.02 / Max: 11104.891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty20K40K60K80K100KSE +/- 274.59, N = 3SE +/- 141.73, N = 3SE +/- 148.38, N = 3SE +/- 302.74, N = 3SE +/- 668.66, N = 3SE +/- 728.14, N = 36469666100645586618994835939551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty16K32K48K64K80KMin: 64146.93 / Avg: 64696.1 / Max: 64971.08Min: 65925.37 / Avg: 66100.17 / Max: 66380.83Min: 64324.94 / Avg: 64557.69 / Max: 64833.51Min: 65797.98 / Avg: 66188.6 / Max: 66784.55Min: 93548.82 / Avg: 94835.24 / Max: 95794.93Min: 92540.22 / Avg: 93955.41 / Max: 94960.451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty306090120150SE +/- 0.37, N = 3SE +/- 0.59, N = 3SE +/- 0.45, N = 3SE +/- 1.08, N = 3SE +/- 0.22, N = 3SE +/- 1.52, N = 497.2098.2898.2397.12113.19102.981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty20406080100Min: 96.47 / Avg: 97.2 / Max: 97.64Min: 97.34 / Avg: 98.28 / Max: 99.37Min: 97.42 / Avg: 98.23 / Max: 98.97Min: 95.07 / Avg: 97.12 / Max: 98.75Min: 112.81 / Avg: 113.19 / Max: 113.57Min: 98.5 / Avg: 102.98 / Max: 105.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty16K32K48K64K80KSE +/- 360.17, N = 3SE +/- 54.15, N = 3SE +/- 110.86, N = 3SE +/- 130.16, N = 3SE +/- 208.99, N = 3SE +/- 274.89, N = 34997955115550295516570514750881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty13K26K39K52K65KMin: 49478.75 / Avg: 49979.29 / Max: 50678.18Min: 55031.16 / Avg: 55115.25 / Max: 55216.38Min: 54813.14 / Avg: 55029.35 / Max: 55179.98Min: 54974.01 / Avg: 55164.79 / Max: 55413.56Min: 70117.88 / Avg: 70513.58 / Max: 70828.02Min: 74569.23 / Avg: 75087.74 / Max: 75505.271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty5001000150020002500SE +/- 0.37, N = 3SE +/- 7.28, N = 3SE +/- 3.77, N = 3SE +/- 3.46, N = 3SE +/- 9.22, N = 3SE +/- 2.15, N = 31867189218831874211820801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty400800120016002000Min: 1866.27 / Avg: 1866.95 / Max: 1867.54Min: 1884.04 / Avg: 1892.13 / Max: 1906.66Min: 1876.3 / Avg: 1883.48 / Max: 1889.04Min: 1869.79 / Avg: 1873.65 / Max: 1880.56Min: 2107.8 / Avg: 2118.3 / Max: 2136.69Min: 2078.02 / Avg: 2080.26 / Max: 2084.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty14002800420056007000SE +/- 15.73, N = 3SE +/- 30.28, N = 3SE +/- 20.59, N = 3SE +/- 18.49, N = 3SE +/- 144.65, N = 12SE +/- 64.45, N = 45817597759796564565851851. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty11002200330044005500Min: 5799.77 / Avg: 5816.95 / Max: 5848.37Min: 5935.42 / Avg: 5977.07 / Max: 6035.96Min: 5937.38 / Avg: 5978.5 / Max: 6000.88Min: 6537.88 / Avg: 6563.5 / Max: 6599.39Min: 4423.22 / Avg: 5658.43 / Max: 6279.45Min: 5033.97 / Avg: 5184.79 / Max: 5347.991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty2K4K6K8K10KSE +/- 93.75, N = 3SE +/- 97.48, N = 3SE +/- 76.33, N = 3SE +/- 90.74, N = 3SE +/- 29.97, N = 3SE +/- 64.28, N = 3738669627378755910851107791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty2K4K6K8K10KMin: 7198.76 / Avg: 7386.23 / Max: 7482.81Min: 6766.83 / Avg: 6961.69 / Max: 7064.35Min: 7269.26 / Avg: 7377.55 / Max: 7524.88Min: 7391.25 / Avg: 7559.18 / Max: 7702.71Min: 10802.4 / Avg: 10851.24 / Max: 10905.74Min: 10670.68 / Avg: 10778.91 / Max: 10893.121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty20K40K60K80K100KSE +/- 1051.18, N = 3SE +/- 729.80, N = 3SE +/- 1198.08, N = 3SE +/- 618.15, N = 3SE +/- 875.03, N = 3SE +/- 344.54, N = 36801469944695506871399885987601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty20K40K60K80K100KMin: 66078.96 / Avg: 68013.8 / Max: 69693.43Min: 68684.42 / Avg: 69943.95 / Max: 71212.48Min: 67159.94 / Avg: 69550.23 / Max: 70890.57Min: 67479.51 / Avg: 68712.51 / Max: 69407.15Min: 98261.38 / Avg: 99884.63 / Max: 101262.69Min: 98099.9 / Avg: 98760.36 / Max: 99260.81. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty2K4K6K8K10KSE +/- 79.57, N = 4SE +/- 76.22, N = 6SE +/- 14.49, N = 3SE +/- 50.50, N = 3SE +/- 54.96, N = 3SE +/- 53.11, N = 36053644265056421891589731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty16003200480064008000Min: 5855.28 / Avg: 6052.66 / Max: 6216.61Min: 6095.58 / Avg: 6441.88 / Max: 6565.87Min: 6475.95 / Avg: 6504.89 / Max: 6520.73Min: 6357.67 / Avg: 6421.17 / Max: 6520.95Min: 8808.66 / Avg: 8915.4 / Max: 8991.53Min: 8868.03 / Avg: 8973.47 / Max: 9037.311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty50100150200250SE +/- 2.20, N = 3SE +/- 0.15, N = 3SE +/- 2.27, N = 9SE +/- 0.37, N = 3SE +/- 1.84, N = 3SE +/- 3.07, N = 32012032032022321961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty4080120160200Min: 198.97 / Avg: 201.49 / Max: 205.88Min: 202.89 / Avg: 203.2 / Max: 203.36Min: 186.81 / Avg: 202.66 / Max: 209.4Min: 200.78 / Avg: 201.52 / Max: 201.98Min: 228.24 / Avg: 231.93 / Max: 233.83Min: 191.92 / Avg: 196.42 / Max: 202.281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty2004006008001000SE +/- 4.66, N = 3SE +/- 3.11, N = 3SE +/- 2.26, N = 3SE +/- 6.93, N = 3SE +/- 10.74, N = 3SE +/- 4.93, N = 37978148188119669631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty2004006008001000Min: 788.53 / Avg: 797.22 / Max: 804.49Min: 809.87 / Avg: 814.37 / Max: 820.33Min: 814.55 / Avg: 818.27 / Max: 822.34Min: 797.4 / Avg: 811.19 / Max: 819.3Min: 945.96 / Avg: 965.78 / Max: 982.84Min: 954.72 / Avg: 963.31 / Max: 971.791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty100200300400500SE +/- 5.18, N = 3SE +/- 2.76, N = 3SE +/- 4.80, N = 3SE +/- 2.48, N = 3SE +/- 4.92, N = 15SE +/- 6.51, N = 34044204134574323921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty80160240320400Min: 393.32 / Avg: 403.51 / Max: 410.2Min: 415.67 / Avg: 420.03 / Max: 425.15Min: 403.84 / Avg: 413.12 / Max: 419.88Min: 454 / Avg: 457.38 / Max: 462.21Min: 388.51 / Avg: 431.52 / Max: 458.48Min: 385.56 / Avg: 392.45 / Max: 405.471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty20K40K60K80K100KSE +/- 1040.39, N = 3SE +/- 997.76, N = 3SE +/- 780.38, N = 3SE +/- 917.87, N = 3SE +/- 365.17, N = 3SE +/- 493.53, N = 369094698667037670991100587977631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty20K40K60K80K100KMin: 67669.8 / Avg: 69094.1 / Max: 71119.94Min: 68423.44 / Avg: 69866.04 / Max: 71781.38Min: 69232.41 / Avg: 70376.1 / Max: 71867.7Min: 69155.77 / Avg: 70991.2 / Max: 71938.11Min: 100216.83 / Avg: 100587.4 / Max: 101317.73Min: 96778.35 / Avg: 97762.53 / Max: 98319.961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty20K40K60K80K100KSE +/- 106.35, N = 3SE +/- 688.68, N = 3SE +/- 799.98, N = 3SE +/- 811.04, N = 3SE +/- 108.66, N = 3SE +/- 607.26, N = 35068058217593925825874040795111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty14K28K42K56K70KMin: 50472.25 / Avg: 50679.6 / Max: 50824.33Min: 57227.16 / Avg: 58216.76 / Max: 59541.23Min: 57839.59 / Avg: 59391.58 / Max: 60504.34Min: 56987.54 / Avg: 58257.52 / Max: 59766.43Min: 73903.53 / Avg: 74039.96 / Max: 74254.68Min: 78515.41 / Avg: 79511.12 / Max: 80611.241. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty5001000150020002500SE +/- 23.52, N = 9SE +/- 30.15, N = 3SE +/- 25.78, N = 3SE +/- 10.03, N = 3SE +/- 24.18, N = 9SE +/- 26.67, N = 31796180318041831221821611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty400800120016002000Min: 1677.78 / Avg: 1795.61 / Max: 1891.38Min: 1747.31 / Avg: 1802.6 / Max: 1851.1Min: 1773.78 / Avg: 1804.14 / Max: 1855.41Min: 1815.7 / Avg: 1830.59 / Max: 1849.66Min: 2079.71 / Avg: 2218.08 / Max: 2285.92Min: 2114.71 / Avg: 2161.13 / Max: 2207.091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-dirty15003000450060007500SE +/- 10.27, N = 3SE +/- 76.69, N = 3SE +/- 81.81, N = 5SE +/- 10.15, N = 3SE +/- 128.29, N = 13SE +/- 70.13, N = 35952621362106947677368531. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-dirty12002400360048006000Min: 5939.94 / Avg: 5951.66 / Max: 5972.13Min: 6059.62 / Avg: 6212.98 / Max: 6291.06Min: 5893.59 / Avg: 6210.02 / Max: 6322.16Min: 6932.08 / Avg: 6947.28 / Max: 6966.54Min: 5872.08 / Avg: 6773.47 / Max: 7643.92Min: 6716.4 / Avg: 6853.41 / Max: 6947.921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

postgres-current

Compiler Notes: --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 Notes: 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

Testing initiated at 13 June 2019 13:36 by user .

postgres-hugepages

Compiler Notes: --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 Notes: 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

Testing initiated at 14 June 2019 09:30 by user .

postgres-hugepages-noTHP-noCommit

Compiler Notes: --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 Notes: 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

Testing initiated at 19 June 2019 15:32 by user .

postgres-hugepages-noTHP-noCommit-dirty

Processor: Common KVM (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Memory: 1 x 16384 MB RAM QEMU, Disk: 21GB QEMU HDD + 27GB QEMU HDD, Graphics: bochsdrmfb

OS: CentOS Linux 7, Kernel: 3.10.0-957.21.2.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM

Compiler Notes: --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 Notes: 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

Testing initiated at 20 June 2019 08:35 by user .

postgres-prod-current

Compiler Notes: --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 Notes: 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

Testing initiated at 1 July 2019 16:09 by user root.

postgres-prod-HP-noTHP-noOverC-dirty

Processor: 4 x Intel Xeon E5-2697 v4 (8 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 1 x 16384 MB DRAM, Disk: 16GB Virtual disk + 54GB Virtual disk + 11GB Virtual disk, Graphics: VMware SVGA II, Network: VMware VMXNET3

OS: CentOS Linux 7, Kernel: 3.10.0-957.21.3.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1176x885, System Layer: VMware

Compiler Notes: --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 Notes: 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

Testing initiated at 2 July 2019 09:34 by user root.