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 1907163-HV-1907164HV47
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-HP-noTHP-noOverC-dirty-512m
July 02 2019
  6 Hours, 1 Minute
postgres-prod-HP-noTHP-noOverC-dirty-1gb
July 03 2019
  7 Hours, 57 Minutes
postgres-prod-HP-noTHP-noOverC-dirty-256m
July 04 2019
  6 Hours, 40 Minutes
postgres-prod-HP-noTHP-noOverC-dirty-512m-sched
July 15 2019
  5 Hours, 32 Minutes
postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig
July 16 2019
  5 Hours, 56 Minutes
Invert Hiding All Results Option
  6 Hours, 25 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 disk16GB Virtual disk + 64GB Virtual disk + 11GB Virtual diskVMware SVGA IIVMware VMXNET3CentOS Linux 73.10.0-957.21.3.el7.x86_64 (x86_64)GCC 4.8.5 20150623xfs1176x885VMwareProcessorMotherboardChipsetMemoryDisksGraphicsNetworkOSKernelCompilerFile-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 - postgres-prod-HP-noTHP-noOverC-dirty-512m: 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-dirty-512m-sched: 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-prod-HP-noTHP-noOverC-dirty-512m-sched-mig: 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-prod-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-migResult OverviewPhoronix Test Suite100%109%118%127%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchBuffer Test - Single Thread - Read WriteBuffer Test - Normal Load - Read WriteBuffer Test - Heavy Contention - Read WriteMostly RAM - Single Thread - Read WriteMostly RAM - Normal Load - Read WriteMostly RAM - Heavy Contention - Read OnlyMostly RAM - Normal Load - Read OnlyOn-Disk - Single Thread - Read WriteOn-Disk - Heavy Contention - Read OnlyBuffer Test - Single Thread - Read OnlyOn-Disk - Normal Load - Read WriteBuffer Test - Heavy Contention - Read OnlyMostly RAM - Single Thread - Read OnlyBuffer Test - Normal Load - Read OnlyOn-Disk - Single Thread - Read OnlyOn-Disk - Heavy Contention - Read WriteMostly RAM - Heavy Contention - Read WriteOn-Disk - Normal Load - 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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig97240958109719395510375088208051851077998760897319696339297763795112161685395353963109979561610674975207945981089498275893120197243310003180058221375449473395710819932991037526619984711107919953089212149563869952180919220267469791695711177974261097657121536061112211033209357227979524103520828572206826697814924112049874310977907206659911121610202492792239464631018998129321396875OpenBenchmarking.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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20K40K60K80K100KSE +/- 737.58, N = 3SE +/- 522.40, N = 3SE +/- 673.07, N = 3SE +/- 565.90, N = 3SE +/- 645.46, N = 397240953539473397916978141. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20K40K60K80K100KMin: 95844.47 / Avg: 97239.52 / Max: 98352.31Min: 94309.74 / Avg: 95353.42 / Max: 95917.4Min: 93740.47 / Avg: 94732.87 / Max: 96016.73Min: 96972.99 / Avg: 97916.1 / Max: 98929.52Min: 96859.09 / Avg: 97813.61 / Max: 99043.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: On-Disk - Test: Normal Load - Mode: Read Writepostgres-prod-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig2004006008001000SE +/- 2.12, N = 3SE +/- 1.82, N = 3SE +/- 5.47, N = 3SE +/- 2.99, N = 3SE +/- 3.66, N = 39589639579579241. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig2004006008001000Min: 954.78 / Avg: 958.34 / Max: 962.11Min: 960.06 / Avg: 963.14 / Max: 966.36Min: 946.29 / Avg: 956.89 / Max: 964.53Min: 953.23 / Avg: 956.68 / Max: 962.65Min: 918.71 / Avg: 924.41 / Max: 931.221. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig2K4K6K8K10KSE +/- 76.82, N = 3SE +/- 64.04, N = 3SE +/- 166.71, N = 3SE +/- 68.73, N = 3SE +/- 29.15, N = 310971109971081911177112041. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig2K4K6K8K10KMin: 10838.78 / Avg: 10971.02 / Max: 11104.89Min: 10875.68 / Avg: 10997.02 / Max: 11093.18Min: 10497.69 / Avg: 10819.1 / Max: 11056.58Min: 11044.34 / Avg: 11176.63 / Max: 11275.1Min: 11151.99 / Avg: 11204.49 / Max: 11252.681. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20K40K60K80K100KSE +/- 728.14, N = 3SE +/- 87.10, N = 3SE +/- 598.04, N = 3SE +/- 490.00, N = 3SE +/- 968.89, N = 393955956169329997426987431. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20K40K60K80K100KMin: 92540.22 / Avg: 93955.41 / Max: 94960.45Min: 95505.45 / Avg: 95616.34 / Max: 95788.14Min: 92114.87 / Avg: 93298.85 / Max: 94037.86Min: 96679.28 / Avg: 97426.47 / Max: 98349.24Min: 96899.11 / Avg: 98742.86 / Max: 100181.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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20406080100SE +/- 1.52, N = 4SE +/- 1.16, N = 9SE +/- 1.15, N = 3SE +/- 0.43, N = 3SE +/- 1.18, N = 31031061031091091. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20406080100Min: 98.5 / Avg: 102.98 / Max: 105.15Min: 98.27 / Avg: 106.39 / Max: 110.44Min: 101.98 / Avg: 103.25 / Max: 105.54Min: 108.21 / Avg: 108.97 / Max: 109.69Min: 107.01 / Avg: 108.91 / Max: 111.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: Normal Load - Mode: Read Onlypostgres-prod-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20K40K60K80K100KSE +/- 274.89, N = 3SE +/- 248.44, N = 3SE +/- 356.45, N = 3SE +/- 529.33, N = 3SE +/- 414.20, N = 375088749757526676571779071. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig14K28K42K56K70KMin: 74569.23 / Avg: 75087.74 / Max: 75505.27Min: 74651.73 / Avg: 74975.01 / Max: 75463.43Min: 74678.86 / Avg: 75266.38 / Max: 75909.84Min: 75806.57 / Avg: 76571.44 / Max: 77587.75Min: 77083.34 / Avg: 77907.18 / Max: 78394.261. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig5001000150020002500SE +/- 2.15, N = 3SE +/- 10.83, N = 3SE +/- 24.45, N = 6SE +/- 3.53, N = 3SE +/- 1.58, N = 3208020791998215320661. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig400800120016002000Min: 2078.02 / Avg: 2080.26 / Max: 2084.56Min: 2061.07 / Avg: 2078.88 / Max: 2098.47Min: 1886.62 / Avg: 1997.95 / Max: 2035.18Min: 2146.64 / Avg: 2153.14 / Max: 2158.76Min: 2064.19 / Avg: 2065.8 / Max: 2068.951. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig13002600390052006500SE +/- 64.45, N = 4SE +/- 131.14, N = 15SE +/- 71.24, N = 3SE +/- 73.24, N = 3SE +/- 26.34, N = 3518545984711606159911. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig11002200330044005500Min: 5033.97 / Avg: 5184.79 / Max: 5347.99Min: 3697.76 / Avg: 4598.14 / Max: 5472.29Min: 4576.46 / Avg: 4710.68 / Max: 4819.2Min: 5922.2 / Avg: 6060.81 / Max: 6171.15Min: 5938.94 / Avg: 5990.89 / Max: 6024.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: Mostly RAM - Test: Single Thread - Mode: Read Onlypostgres-prod-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig2K4K6K8K10KSE +/- 64.28, N = 3SE +/- 88.89, N = 3SE +/- 48.23, N = 3SE +/- 14.83, N = 3SE +/- 19.84, N = 310779108941079111221112161. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig2K4K6K8K10KMin: 10670.68 / Avg: 10778.91 / Max: 10893.12Min: 10732.9 / Avg: 10893.86 / Max: 11039.7Min: 10726.41 / Avg: 10791.07 / Max: 10885.4Min: 11196.99 / Avg: 11221.42 / Max: 11248.21Min: 11190.83 / Avg: 11216.23 / Max: 11255.341. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20K40K60K80K100KSE +/- 344.54, N = 3SE +/- 797.07, N = 3SE +/- 268.74, N = 3SE +/- 522.92, N = 3SE +/- 746.84, N = 39876098275995301033201020241. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20K40K60K80K100KMin: 98099.9 / Avg: 98760.36 / Max: 99260.8Min: 96738.87 / Avg: 98275.08 / Max: 99411.97Min: 99224.54 / Avg: 99530.48 / Max: 100066.15Min: 102773.95 / Avg: 103320.09 / Max: 104365.57Min: 100680.88 / Avg: 102023.63 / Max: 103261.631. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig2K4K6K8K10KSE +/- 53.11, N = 3SE +/- 28.02, N = 3SE +/- 83.01, N = 3SE +/- 50.20, N = 3SE +/- 7.94, N = 3897389318921935792791. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig16003200480064008000Min: 8868.03 / Avg: 8973.47 / Max: 9037.31Min: 8889.75 / Avg: 8931.44 / Max: 8984.71Min: 8784.64 / Avg: 8920.53 / Max: 9071.08Min: 9266.95 / Avg: 9356.78 / Max: 9440.51Min: 9263.07 / Avg: 9278.84 / Max: 9288.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: Single Thread - Mode: Read Writepostgres-prod-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig50100150200250SE +/- 3.07, N = 3SE +/- 4.39, N = 9SE +/- 1.29, N = 3SE +/- 2.04, N = 3SE +/- 1.37, N = 31962012142272231. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig4080120160200Min: 191.92 / Avg: 196.42 / Max: 202.28Min: 173.42 / Avg: 201.35 / Max: 212.58Min: 212.14 / Avg: 213.57 / Max: 216.13Min: 223.27 / Avg: 226.71 / Max: 230.32Min: 220.37 / Avg: 223.06 / Max: 224.821. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig2004006008001000SE +/- 4.93, N = 3SE +/- 1.79, N = 3SE +/- 4.00, N = 3SE +/- 9.56, N = 3SE +/- 6.31, N = 39639729569799461. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig2004006008001000Min: 954.72 / Avg: 963.31 / Max: 971.79Min: 968.1 / Avg: 971.67 / Max: 973.66Min: 948.55 / Avg: 955.84 / Max: 962.33Min: 960.22 / Avg: 978.81 / Max: 992.02Min: 937.8 / Avg: 945.55 / Max: 958.051. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig110220330440550SE +/- 6.51, N = 3SE +/- 6.01, N = 3SE +/- 1.47, N = 3SE +/- 3.75, N = 3SE +/- 4.79, N = 153924333865244631. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig90180270360450Min: 385.56 / Avg: 392.45 / Max: 405.47Min: 420.64 / Avg: 432.67 / Max: 438.7Min: 383.13 / Avg: 385.81 / Max: 388.2Min: 517.5 / Avg: 524.24 / Max: 530.45Min: 425.52 / Avg: 462.78 / Max: 493.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: Mostly RAM - Test: Heavy Contention - Mode: Read Onlypostgres-prod-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20K40K60K80K100KSE +/- 493.53, N = 3SE +/- 514.67, N = 3SE +/- 206.20, N = 3SE +/- 737.04, N = 3SE +/- 649.86, N = 397763100031995211035201018991. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20K40K60K80K100KMin: 96778.35 / Avg: 97762.53 / Max: 98319.96Min: 99030.85 / Avg: 100030.59 / Max: 100742.71Min: 99113.73 / Avg: 99521.31 / Max: 99779.47Min: 102173.54 / Avg: 103519.83 / Max: 104712.88Min: 100609.98 / Avg: 101899.26 / Max: 102686.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: Buffer Test - Test: Heavy Contention - Mode: Read Onlypostgres-prod-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig20K40K60K80K100KSE +/- 607.26, N = 3SE +/- 146.48, N = 3SE +/- 390.00, N = 3SE +/- 137.04, N = 3SE +/- 644.77, N = 379511800588091982857812931. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig14K28K42K56K70KMin: 78515.41 / Avg: 79511.12 / Max: 80611.24Min: 79877.87 / Avg: 80058.27 / Max: 80348.38Min: 80440.14 / Avg: 80919.21 / Max: 81691.83Min: 82657.57 / Avg: 82857.34 / Max: 83119.74Min: 80084.22 / Avg: 81293 / Max: 82286.421. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig5001000150020002500SE +/- 26.67, N = 3SE +/- 16.19, N = 3SE +/- 32.55, N = 3SE +/- 29.23, N = 4SE +/- 20.14, N = 3216122132202220621391. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig400800120016002000Min: 2114.71 / Avg: 2161.13 / Max: 2207.09Min: 2182.64 / Avg: 2212.68 / Max: 2238.14Min: 2137.41 / Avg: 2202.48 / Max: 2236.55Min: 2140.07 / Avg: 2205.9 / Max: 2268.75Min: 2113.14 / Avg: 2139.01 / Max: 2178.691. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig2K4K6K8K10KSE +/- 70.13, N = 3SE +/- 79.70, N = 7SE +/- 202.80, N = 14SE +/- 55.10, N = 3SE +/- 289.76, N = 12685375446746826668751. (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-HP-noTHP-noOverC-dirty-512mpostgres-prod-HP-noTHP-noOverC-dirty-1gbpostgres-prod-HP-noTHP-noOverC-dirty-256mpostgres-prod-HP-noTHP-noOverC-dirty-512m-schedpostgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig14002800420056007000Min: 6716.4 / Avg: 6853.41 / Max: 6947.92Min: 7181.62 / Avg: 7543.52 / Max: 7780.83Min: 4343.28 / Avg: 6745.97 / Max: 7393.46Min: 8203.1 / Avg: 8266.24 / Max: 8376.04Min: 3848.7 / Avg: 6875.43 / Max: 7528.391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm