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 1907046-HV-1907035HV83
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-prod-current
July 01 2019
  5 Hours, 42 Minutes
postgres-prod-HP-noTHP-noOverC-dirty
July 02 2019
  6 Hours, 1 Minute
postgres-prod-HP-noTHP-noOverC-dirty-1gb
July 03 2019
  7 Hours, 57 Minutes
Invert Hiding All Results Option
  6 Hours, 33 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-testingOpenBenchmarking.orgPhoronix Test Suite4 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 20150623xfs1176x885VMwareProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem LayerPostgres-testing BenchmarksSystem Logs- --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 - 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-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gbResult OverviewPhoronix Test Suite100%106%112%117%123%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchBuffer Test - Normal Load - Read WriteMostly RAM - Single Thread - Read WriteBuffer Test - Heavy Contention - Read WriteBuffer Test - Single Thread - Read WriteOn-Disk - Single Thread - Read WriteBuffer Test - Heavy Contention - Read OnlyBuffer Test - Normal Load - Read OnlyMostly RAM - Heavy Contention - Read OnlyOn-Disk - Normal Load - Read OnlyMostly RAM - Heavy Contention - Read WriteMostly RAM - Normal Load - Read WriteMostly RAM - Normal Load - Read OnlyOn-Disk - Heavy Contention - Read OnlyOn-Disk - Normal Load - Read WriteMostly RAM - Single Thread - Read OnlyOn-Disk - Heavy Contention - Read WriteOn-Disk - Single Thread - Read OnlyBuffer Test - Single Thread - Read Only

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-1gb947399711090094835113.197051421185658108519988589152329664321005877404022186773972409581097193955102.98750882080518510779987608973196963392977637951121616853953539631099795616106.397497520794598108949827589312019724331000318005822137544OpenBenchmarking.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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KSE +/- 509.30, N = 3SE +/- 737.58, N = 3SE +/- 522.40, N = 39473997240953531. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KMin: 93884.56 / Avg: 94739.41 / Max: 95646.51Min: 95844.47 / Avg: 97239.52 / Max: 98352.31Min: 94309.74 / Avg: 95353.42 / Max: 95917.41. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2004006008001000SE +/- 0.69, N = 3SE +/- 2.12, N = 3SE +/- 1.82, N = 39719589631. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2004006008001000Min: 969.76 / Avg: 971.13 / Max: 971.96Min: 954.78 / Avg: 958.34 / Max: 962.11Min: 960.06 / Avg: 963.14 / Max: 966.361. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2K4K6K8K10KSE +/- 71.05, N = 3SE +/- 76.82, N = 3SE +/- 64.04, N = 31090010971109971. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2K4K6K8K10KMin: 10766.76 / Avg: 10900.15 / Max: 11009.24Min: 10838.78 / Avg: 10971.02 / Max: 11104.89Min: 10875.68 / Avg: 10997.02 / Max: 11093.181. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KSE +/- 668.66, N = 3SE +/- 728.14, N = 3SE +/- 87.10, N = 39483593955956161. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb17K34K51K68K85KMin: 93548.82 / Avg: 94835.24 / Max: 95794.93Min: 92540.22 / Avg: 93955.41 / Max: 94960.45Min: 95505.45 / Avg: 95616.34 / Max: 95788.141. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb306090120150SE +/- 0.22, N = 3SE +/- 1.52, N = 4SE +/- 1.16, N = 9113.19102.98106.391. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20406080100Min: 112.81 / Avg: 113.19 / Max: 113.57Min: 98.5 / Avg: 102.98 / Max: 105.15Min: 98.27 / Avg: 106.39 / Max: 110.441. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb16K32K48K64K80KSE +/- 208.99, N = 3SE +/- 274.89, N = 3SE +/- 248.44, N = 37051475088749751. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb13K26K39K52K65KMin: 70117.88 / Avg: 70513.58 / Max: 70828.02Min: 74569.23 / Avg: 75087.74 / Max: 75505.27Min: 74651.73 / Avg: 74975.01 / Max: 75463.431. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb5001000150020002500SE +/- 9.22, N = 3SE +/- 2.15, N = 3SE +/- 10.83, N = 32118208020791. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb400800120016002000Min: 2107.8 / Avg: 2118.3 / Max: 2136.69Min: 2078.02 / Avg: 2080.26 / Max: 2084.56Min: 2061.07 / Avg: 2078.88 / Max: 2098.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: Buffer Test - Test: Normal Load - Mode: Read Writepostgres-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb12002400360048006000SE +/- 144.65, N = 12SE +/- 64.45, N = 4SE +/- 131.14, N = 155658518545981. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb10002000300040005000Min: 4423.22 / Avg: 5658.43 / Max: 6279.45Min: 5033.97 / Avg: 5184.79 / Max: 5347.99Min: 3697.76 / Avg: 4598.14 / Max: 5472.291. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2K4K6K8K10KSE +/- 29.97, N = 3SE +/- 64.28, N = 3SE +/- 88.89, N = 31085110779108941. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2K4K6K8K10KMin: 10802.4 / Avg: 10851.24 / Max: 10905.74Min: 10670.68 / Avg: 10778.91 / Max: 10893.12Min: 10732.9 / Avg: 10893.86 / Max: 11039.71. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KSE +/- 875.03, N = 3SE +/- 344.54, N = 3SE +/- 797.07, N = 39988598760982751. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KMin: 98261.38 / Avg: 99884.63 / Max: 101262.69Min: 98099.9 / Avg: 98760.36 / Max: 99260.8Min: 96738.87 / Avg: 98275.08 / Max: 99411.971. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2K4K6K8K10KSE +/- 54.96, N = 3SE +/- 53.11, N = 3SE +/- 28.02, N = 38915897389311. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb16003200480064008000Min: 8808.66 / Avg: 8915.4 / Max: 8991.53Min: 8868.03 / Avg: 8973.47 / Max: 9037.31Min: 8889.75 / Avg: 8931.44 / Max: 8984.711. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb50100150200250SE +/- 1.84, N = 3SE +/- 3.07, N = 3SE +/- 4.39, N = 92321962011. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb4080120160200Min: 228.24 / Avg: 231.93 / Max: 233.83Min: 191.92 / Avg: 196.42 / Max: 202.28Min: 173.42 / Avg: 201.35 / Max: 212.581. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2004006008001000SE +/- 10.74, N = 3SE +/- 4.93, N = 3SE +/- 1.79, N = 39669639721. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb2004006008001000Min: 945.96 / Avg: 965.78 / Max: 982.84Min: 954.72 / Avg: 963.31 / Max: 971.79Min: 968.1 / Avg: 971.67 / Max: 973.661. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb90180270360450SE +/- 4.92, N = 15SE +/- 6.51, N = 3SE +/- 6.01, N = 34323924331. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb80160240320400Min: 388.51 / Avg: 431.52 / Max: 458.48Min: 385.56 / Avg: 392.45 / Max: 405.47Min: 420.64 / Avg: 432.67 / Max: 438.71. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KSE +/- 365.17, N = 3SE +/- 493.53, N = 3SE +/- 514.67, N = 3100587977631000311. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KMin: 100216.83 / Avg: 100587.4 / Max: 101317.73Min: 96778.35 / Avg: 97762.53 / Max: 98319.96Min: 99030.85 / Avg: 100030.59 / Max: 100742.711. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb20K40K60K80K100KSE +/- 108.66, N = 3SE +/- 607.26, N = 3SE +/- 146.48, N = 37404079511800581. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb14K28K42K56K70KMin: 73903.53 / Avg: 74039.96 / Max: 74254.68Min: 78515.41 / Avg: 79511.12 / Max: 80611.24Min: 79877.87 / Avg: 80058.27 / Max: 80348.381. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb5001000150020002500SE +/- 24.18, N = 9SE +/- 26.67, N = 3SE +/- 16.19, N = 32218216122131. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb400800120016002000Min: 2079.71 / Avg: 2218.08 / Max: 2285.92Min: 2114.71 / Avg: 2161.13 / Max: 2207.09Min: 2182.64 / Avg: 2212.68 / Max: 2238.141. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb16003200480064008000SE +/- 128.29, N = 13SE +/- 70.13, N = 3SE +/- 79.70, N = 76773685375441. (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-prod-currentpostgres-prod-HP-noTHP-noOverC-dirtypostgres-prod-HP-noTHP-noOverC-dirty-1gb13002600390052006500Min: 5872.08 / Avg: 6773.47 / Max: 7643.92Min: 6716.4 / Avg: 6853.41 / Max: 6947.92Min: 7181.62 / Avg: 7543.52 / Max: 7780.831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm