postgresql

this is the true

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1706011-RI-1706016AS87
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
Disable Color Branding
Prefer Vertical Bar Graphs

Additional Graphs

Show Perf Per Core/Thread Calculation Graphs Where Applicable
Show Perf Per Clock Calculation Graphs Where Applicable

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
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
postgresql
May 25 2017
 
asvany_bcache_prewarm
May 31 2017
 
asvany_auriga_default
June 01 2017
 
asvany_auriga_default2
June 01 2017
 
Invert Hiding All Results Option
 

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):


postgresqlProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverVulkanCompilerFile-SystemScreen ResolutionOpenGLpostgresqlasvany_bcache_prewarmasvany_auriga_defaultasvany_auriga_default2AMD Ryzen 7 1700 Eight-Core @ 3.80GHz (16 Cores)MSI X370 SLI PLUS (MS-7A33) v2.0AMD Device 14502 x 16384 MB DDR4-1333MHz CMK32GX4M2A2400C16512GB TOSHIBA-RD400MSI NVIDIA GeForce GTX 960 2048MB (1189/3505MHz)NVIDIA Device 0fbaRealtek RTL8111/8168/8411Ubuntu 17.044.10.0-21-generic (x86_64)LXDE 0.9.3X Server 1.19.3NVIDIA 375.391.0.24GCC 6.3.0 20170406ext41920x1080Intel Core i5-4590 @ 3.70GHz (4 Cores)MSI Z97-G43 (MS-7816) v3.0Intel 4th Gen Core DRAM8192MB2 x 4001GB Western Digital WD40EFRX-68W + 250GB Samsung SSD 750 + 240GB ADATA SP550Intel HD 4600Intel Xeon E3-1200 v3/4thUbuntu 16.044.4.0-21-generic (x86_64)Xfce 4.12X Server 1.18.3intel 2.99.917GCC 5.4.0 20160609overlayfs2560x1440Intel Core i7-2600K @ 3.40GHz (8 Cores)ASUS P8P67-M PRO20480MB2000GB TOSHIBA DT01ACA2 + 60GB INTEL SSDSC2CT06 + 1500GB SAMSUNG HD154UINVIDIA GeForce GTS 450 1024MB (810/1804MHz)Realtek ALC892Gentoo4.9.16-gentoo-i7-sysd-as (x86_64)KDE 4.14.29X Server 1.19.2NVIDIA 375.264.5.01.0.24GCC 4.9.4 + LLVM 4.0.0 + CUDA 6.5ext4OpenBenchmarking.orgCompiler Details- postgresql: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v - asvany_bcache_prewarm: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-tune=generic -v - asvany_auriga_default: --bindir=/usr/x86_64-pc-linux-gnu/gcc-bin/4.9.4 --build=x86_64-pc-linux-gnu --datadir=/usr/share/gcc-data/x86_64-pc-linux-gnu/4.9.4 --disable-altivec --disable-fixed-point --disable-isl-version-check --disable-libcilkrts --disable-libgcj --disable-libmudflap --disable-libssp --disable-werror --enable-__cxa_atexit --enable-checking=release --enable-clocale=gnu --enable-languages=c,c++,fortran --enable-libgomp --enable-libsanitizer --enable-libstdcxx-time --enable-libvtv --enable-lto --enable-multilib --enable-nls --enable-obsolete --enable-secureplt --enable-shared --enable-targets=all --enable-threads=posix --enable-vtable-verify --host=x86_64-pc-linux-gnu --includedir=/usr/lib/gcc/x86_64-pc-linux-gnu/4.9.4/include --mandir=/usr/share/gcc-data/x86_64-pc-linux-gnu/4.9.4/man --with-cloog --with-multilib-list=m32,m64 --with-python-dir=/share/gcc-data/x86_64-pc-linux-gnu/4.9.4/python - asvany_auriga_default2: --bindir=/usr/x86_64-pc-linux-gnu/gcc-bin/4.9.4 --build=x86_64-pc-linux-gnu --datadir=/usr/share/gcc-data/x86_64-pc-linux-gnu/4.9.4 --disable-altivec --disable-fixed-point --disable-isl-version-check --disable-libcilkrts --disable-libgcj --disable-libmudflap --disable-libssp --disable-werror --enable-__cxa_atexit --enable-checking=release --enable-clocale=gnu --enable-languages=c,c++,fortran --enable-libgomp --enable-libsanitizer --enable-libstdcxx-time --enable-libvtv --enable-lto --enable-multilib --enable-nls --enable-obsolete --enable-secureplt --enable-shared --enable-targets=all --enable-threads=posix --enable-vtable-verify --host=x86_64-pc-linux-gnu --includedir=/usr/lib/gcc/x86_64-pc-linux-gnu/4.9.4/include --mandir=/usr/share/gcc-data/x86_64-pc-linux-gnu/4.9.4/man --with-cloog --with-multilib-list=m32,m64 --with-python-dir=/share/gcc-data/x86_64-pc-linux-gnu/4.9.4/python Processor Details- asvany_bcache_prewarm: Scaling Governor: intel_pstate powersave- asvany_auriga_default: Scaling Governor: acpi-cpufreq performance- asvany_auriga_default2: Scaling Governor: acpi-cpufreq performanceEnvironment Details- asvany_auriga_default, asvany_auriga_default2: __GL_YIELD=NOTHING

postgresqlpgbench: On-Disk - Normal Load - Read Writepgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Writepgbench: On-Disk - Heavy Contention - Read Writepgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_defaultasvany_auriga_default23480.164270.664480.471967.931995.672851.2929.5341.68162.8582.06296.82272.49598.80271.42289.15644.28235.14395.81OpenBenchmarking.org

PostgreSQL pgbench

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Normal Load - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default27001400210028003500SE +/- 57.58, N = 3SE +/- 14.64, N = 3SE +/- 14.53, N = 63480.1629.53598.801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Normal Load - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default26001200180024003000Min: 3371.2 / Avg: 3480.16 / Max: 3566.91Min: 14.01 / Avg: 29.53 / Max: 58.8Min: 546.5 / Avg: 598.8 / Max: 643.691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default29001800270036004500SE +/- 62.30, N = 5SE +/- 2.96, N = 6SE +/- 20.57, N = 64270.6641.68271.421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default27001400210028003500Min: 4162.89 / Avg: 4270.66 / Max: 4503.71Min: 32.42 / Avg: 41.68 / Max: 52.68Min: 171.84 / Avg: 271.42 / Max: 306.891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default210002000300040005000SE +/- 27.03, N = 3SE +/- 2.62, N = 3SE +/- 7.34, N = 64480.47162.85289.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default28001600240032004000Min: 4429.08 / Avg: 4480.47 / Max: 4520.68Min: 157.62 / Avg: 162.85 / Max: 165.48Min: 261.42 / Avg: 289.15 / Max: 309.411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default2400800120016002000SE +/- 286.01, N = 6SE +/- 1.42, N = 4SE +/- 3.45, N = 31967.9382.06644.281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default230060090012001500Min: 1555.19 / Avg: 1967.93 / Max: 3376.75Min: 79.35 / Avg: 82.06 / Max: 84.59Min: 637.38 / Avg: 644.28 / Max: 647.81. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default2400800120016002000SE +/- 59.00, N = 6SE +/- 2.97, N = 3SE +/- 13.25, N = 61995.67296.82235.141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default230060090012001500Min: 1832.54 / Avg: 1995.67 / Max: 2197.16Min: 290.89 / Avg: 296.82 / Max: 300.18Min: 199.52 / Avg: 235.14 / Max: 282.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default26001200180024003000SE +/- 84.85, N = 6SE +/- 2.63, N = 3SE +/- 30.58, N = 62851.29272.49395.811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Writepostgresqlasvany_bcache_prewarmasvany_auriga_default25001000150020002500Min: 2604.09 / Avg: 2851.29 / Max: 3139.81Min: 269.79 / Avg: 272.49 / Max: 277.75Min: 303.19 / Avg: 395.81 / Max: 524.131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm