postgres-testing

KVM 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 1906172-HV-POSTGREST89
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
Invert Hiding All Results Option
  10 Hours, 38 Minutes
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 SuiteCommon 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 20150623xfs1024x768KVMProcessorMotherboardMemoryDiskGraphicsOSKernelCompilerFile-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 - 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-current vs. postgres-hugepages ComparisonPhoronix Test SuiteBaseline+3.7%+3.7%+7.4%+7.4%+11.1%+11.1%+14.8%+14.8%14.9%10.3%6.4%4.4%4%2.8%2.8%2.2%2.1%Buffer Test - Heavy Contention - Read OnlyBuffer Test - Normal Load - Read OnlyBuffer Test - Single Thread - Read OnlyMostly RAM - Single Thread - Read Only6.1%Buffer Test - Heavy Contention - Read WriteBuffer Test - Single Thread - Read WriteOn-Disk - Single Thread - Read Only3.2%On-Disk - Heavy Contention - Read OnlyBuffer Test - Normal Load - Read WriteMostly RAM - Normal Load - Read OnlyOn-Disk - Heavy Contention - Read WritePostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchpostgres-currentpostgres-hugepages

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-hugepages6405279871826469697.20499791867581773866801460532017974046909450680179659526510581169566610098.2855115189259776962699446442203814420698665821718036213OpenBenchmarking.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-hugepages14K28K42K56K70KSE +/- 303.57, N = 3SE +/- 32.79, N = 364052651051. (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-hugepages11K22K33K44K55KMin: 63449.43 / Avg: 64051.54 / Max: 64420.18Min: 65040.53 / Avg: 65105.03 / Max: 65147.481. (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-hugepages2004006008001000SE +/- 1.59, N = 3SE +/- 1.53, N = 37988111. (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-hugepages140280420560700Min: 796.1 / Avg: 797.94 / Max: 801.11Min: 808.47 / Avg: 811.05 / Max: 813.781. (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-hugepages15003000450060007500SE +/- 95.98, N = 9SE +/- 69.67, N = 3718269561. (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-hugepages12002400360048006000Min: 6622.45 / Avg: 7181.66 / Max: 7504.42Min: 6884.6 / Avg: 6956.3 / Max: 7095.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: Mostly RAM - Test: Normal Load - Mode: Read Onlypostgres-currentpostgres-hugepages14K28K42K56K70KSE +/- 274.59, N = 3SE +/- 141.73, N = 364696661001. (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-hugepages11K22K33K44K55KMin: 64146.93 / Avg: 64696.1 / Max: 64971.08Min: 65925.37 / Avg: 66100.17 / Max: 66380.831. (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-hugepages20406080100SE +/- 0.37, N = 3SE +/- 0.59, N = 397.2098.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: Single Thread - Mode: Read Writepostgres-currentpostgres-hugepages20406080100Min: 96.47 / Avg: 97.2 / Max: 97.64Min: 97.34 / Avg: 98.28 / Max: 99.371. (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-hugepages12K24K36K48K60KSE +/- 360.17, N = 3SE +/- 54.15, N = 349979551151. (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-hugepages10K20K30K40K50KMin: 49478.75 / Avg: 49979.29 / Max: 50678.18Min: 55031.16 / Avg: 55115.25 / Max: 55216.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: Normal Load - Mode: Read Writepostgres-currentpostgres-hugepages400800120016002000SE +/- 0.37, N = 3SE +/- 7.28, N = 3186718921. (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-hugepages30060090012001500Min: 1866.27 / Avg: 1866.95 / Max: 1867.54Min: 1884.04 / Avg: 1892.13 / Max: 1906.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: Normal Load - Mode: Read Writepostgres-currentpostgres-hugepages13002600390052006500SE +/- 15.73, N = 3SE +/- 30.28, N = 3581759771. (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-hugepages10002000300040005000Min: 5799.77 / Avg: 5816.95 / Max: 5848.37Min: 5935.42 / Avg: 5977.07 / Max: 6035.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: Mostly RAM - Test: Single Thread - Mode: Read Onlypostgres-currentpostgres-hugepages16003200480064008000SE +/- 93.75, N = 3SE +/- 97.48, N = 3738669621. (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-hugepages13002600390052006500Min: 7198.76 / Avg: 7386.23 / Max: 7482.81Min: 6766.83 / Avg: 6961.69 / Max: 7064.351. (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-hugepages15K30K45K60K75KSE +/- 1051.18, N = 3SE +/- 729.80, N = 368014699441. (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-hugepages12K24K36K48K60KMin: 66078.96 / Avg: 68013.8 / Max: 69693.43Min: 68684.42 / Avg: 69943.95 / Max: 71212.481. (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-hugepages14002800420056007000SE +/- 79.57, N = 4SE +/- 76.22, N = 6605364421. (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-hugepages11002200330044005500Min: 5855.28 / Avg: 6052.66 / Max: 6216.61Min: 6095.58 / Avg: 6441.88 / Max: 6565.871. (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-hugepages4080120160200SE +/- 2.20, N = 3SE +/- 0.15, N = 32012031. (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-hugepages4080120160200Min: 198.97 / Avg: 201.49 / Max: 205.88Min: 202.89 / Avg: 203.2 / Max: 203.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: Heavy Contention - Mode: Read Writepostgres-currentpostgres-hugepages2004006008001000SE +/- 4.66, N = 3SE +/- 3.11, N = 37978141. (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-hugepages140280420560700Min: 788.53 / Avg: 797.22 / Max: 804.49Min: 809.87 / Avg: 814.37 / Max: 820.331. (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-hugepages90180270360450SE +/- 5.18, N = 3SE +/- 2.76, N = 34044201. (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-hugepages70140210280350Min: 393.32 / Avg: 403.51 / Max: 410.2Min: 415.67 / Avg: 420.03 / Max: 425.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: Mostly RAM - Test: Heavy Contention - Mode: Read Onlypostgres-currentpostgres-hugepages15K30K45K60K75KSE +/- 1040.39, N = 3SE +/- 997.76, N = 369094698661. (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-hugepages12K24K36K48K60KMin: 67669.8 / Avg: 69094.1 / Max: 71119.94Min: 68423.44 / Avg: 69866.04 / Max: 71781.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: Buffer Test - Test: Heavy Contention - Mode: Read Onlypostgres-currentpostgres-hugepages12K24K36K48K60KSE +/- 106.35, N = 3SE +/- 688.68, N = 350680582171. (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-hugepages10K20K30K40K50KMin: 50472.25 / Avg: 50679.6 / Max: 50824.33Min: 57227.16 / Avg: 58216.76 / Max: 59541.231. (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-hugepages400800120016002000SE +/- 23.52, N = 9SE +/- 30.15, N = 3179618031. (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-hugepages30060090012001500Min: 1677.78 / Avg: 1795.61 / Max: 1891.38Min: 1747.31 / Avg: 1802.6 / Max: 1851.11. (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-hugepages13002600390052006500SE +/- 10.27, N = 3SE +/- 76.69, N = 3595262131. (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-hugepages11002200330044005500Min: 5939.94 / Avg: 5951.66 / Max: 5972.13Min: 6059.62 / Avg: 6212.98 / Max: 6291.061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm