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-hugepagespostgres-current14K28K42K56K70KSE +/- 32.79, N = 3SE +/- 303.57, N = 365105640521. (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-hugepagespostgres-current11K22K33K44K55KMin: 65040.53 / Avg: 65105.03 / Max: 65147.48Min: 63449.43 / Avg: 64051.54 / Max: 64420.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: On-Disk - Test: Normal Load - Mode: Read Writepostgres-hugepagespostgres-current2004006008001000SE +/- 1.53, N = 3SE +/- 1.59, N = 38117981. (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-hugepagespostgres-current140280420560700Min: 808.47 / Avg: 811.05 / Max: 813.78Min: 796.1 / Avg: 797.94 / Max: 801.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-hugepagespostgres-current15003000450060007500SE +/- 69.67, N = 3SE +/- 95.98, N = 9695671821. (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-hugepagespostgres-current12002400360048006000Min: 6884.6 / Avg: 6956.3 / Max: 7095.63Min: 6622.45 / Avg: 7181.66 / Max: 7504.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: Normal Load - Mode: Read Onlypostgres-hugepagespostgres-current14K28K42K56K70KSE +/- 141.73, N = 3SE +/- 274.59, N = 366100646961. (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-hugepagespostgres-current11K22K33K44K55KMin: 65925.37 / Avg: 66100.17 / Max: 66380.83Min: 64146.93 / Avg: 64696.1 / Max: 64971.081. (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-hugepagespostgres-current20406080100SE +/- 0.59, N = 3SE +/- 0.37, N = 398.2897.201. (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-hugepagespostgres-current20406080100Min: 97.34 / Avg: 98.28 / Max: 99.37Min: 96.47 / Avg: 97.2 / Max: 97.641. (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-hugepagespostgres-current12K24K36K48K60KSE +/- 54.15, N = 3SE +/- 360.17, N = 355115499791. (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-hugepagespostgres-current10K20K30K40K50KMin: 55031.16 / Avg: 55115.25 / Max: 55216.38Min: 49478.75 / Avg: 49979.29 / Max: 50678.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 Writepostgres-hugepagespostgres-current400800120016002000SE +/- 7.28, N = 3SE +/- 0.37, N = 3189218671. (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-hugepagespostgres-current30060090012001500Min: 1884.04 / Avg: 1892.13 / Max: 1906.66Min: 1866.27 / Avg: 1866.95 / Max: 1867.541. (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-hugepagespostgres-current13002600390052006500SE +/- 30.28, N = 3SE +/- 15.73, N = 3597758171. (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-hugepagespostgres-current10002000300040005000Min: 5935.42 / Avg: 5977.07 / Max: 6035.96Min: 5799.77 / Avg: 5816.95 / Max: 5848.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: Mostly RAM - Test: Single Thread - Mode: Read Onlypostgres-hugepagespostgres-current16003200480064008000SE +/- 97.48, N = 3SE +/- 93.75, N = 3696273861. (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-hugepagespostgres-current13002600390052006500Min: 6766.83 / Avg: 6961.69 / Max: 7064.35Min: 7198.76 / Avg: 7386.23 / Max: 7482.811. (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-hugepagespostgres-current15K30K45K60K75KSE +/- 729.80, N = 3SE +/- 1051.18, N = 369944680141. (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-hugepagespostgres-current12K24K36K48K60KMin: 68684.42 / Avg: 69943.95 / Max: 71212.48Min: 66078.96 / Avg: 68013.8 / Max: 69693.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: Buffer Test - Test: Single Thread - Mode: Read Onlypostgres-hugepagespostgres-current14002800420056007000SE +/- 76.22, N = 6SE +/- 79.57, N = 4644260531. (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-hugepagespostgres-current11002200330044005500Min: 6095.58 / Avg: 6441.88 / Max: 6565.87Min: 5855.28 / Avg: 6052.66 / Max: 6216.611. (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-hugepagespostgres-current4080120160200SE +/- 0.15, N = 3SE +/- 2.20, N = 32032011. (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-hugepagespostgres-current4080120160200Min: 202.89 / Avg: 203.2 / Max: 203.36Min: 198.97 / Avg: 201.49 / Max: 205.881. (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-hugepagespostgres-current2004006008001000SE +/- 3.11, N = 3SE +/- 4.66, N = 38147971. (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-hugepagespostgres-current140280420560700Min: 809.87 / Avg: 814.37 / Max: 820.33Min: 788.53 / Avg: 797.22 / Max: 804.491. (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-hugepagespostgres-current90180270360450SE +/- 2.76, N = 3SE +/- 5.18, N = 34204041. (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-hugepagespostgres-current70140210280350Min: 415.67 / Avg: 420.03 / Max: 425.15Min: 393.32 / Avg: 403.51 / Max: 410.21. (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-hugepagespostgres-current15K30K45K60K75KSE +/- 997.76, N = 3SE +/- 1040.39, N = 369866690941. (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-hugepagespostgres-current12K24K36K48K60KMin: 68423.44 / Avg: 69866.04 / Max: 71781.38Min: 67669.8 / Avg: 69094.1 / Max: 71119.941. (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-hugepagespostgres-current12K24K36K48K60KSE +/- 688.68, N = 3SE +/- 106.35, N = 358217506801. (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-hugepagespostgres-current10K20K30K40K50KMin: 57227.16 / Avg: 58216.76 / Max: 59541.23Min: 50472.25 / Avg: 50679.6 / Max: 50824.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: Mostly RAM - Test: Heavy Contention - Mode: Read Writepostgres-hugepagespostgres-current400800120016002000SE +/- 30.15, N = 3SE +/- 23.52, N = 9180317961. (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-hugepagespostgres-current30060090012001500Min: 1747.31 / Avg: 1802.6 / Max: 1851.1Min: 1677.78 / Avg: 1795.61 / Max: 1891.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 Writepostgres-hugepagespostgres-current13002600390052006500SE +/- 76.69, N = 3SE +/- 10.27, N = 3621359521. (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-hugepagespostgres-current11002200330044005500Min: 6059.62 / Avg: 6212.98 / Max: 6291.06Min: 5939.94 / Avg: 5951.66 / Max: 5972.131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm