postgresql

during raid syncing

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1706016-ASVA-170525208
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
Performance Per
Dollar
Date
Run
  Test
  Duration
postgresql
May 25 2017
 
asvany_bcache_prewarm
May 31 2017
 
Invert Hiding All Results Option
 
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):

postgresql

Processor: AMD Ryzen 7 1700 Eight-Core @ 3.80GHz (16 Cores), Motherboard: MSI X370 SLI PLUS (MS-7A33) v2.0, Chipset: AMD Device 1450, Memory: 2 x 16384 MB DDR4-1333MHz CMK32GX4M2A2400C16, Disk: 512GB TOSHIBA-RD400, Graphics: MSI NVIDIA GeForce GTX 960 2048MB (1189/3505MHz), Audio: NVIDIA Device 0fba, Network: Realtek RTL8111/8168/8411

OS: Ubuntu 17.04, Kernel: 4.10.0-21-generic (x86_64), Desktop: LXDE 0.9.3, Display Server: X Server 1.19.3, Display Driver: NVIDIA 375.39, Vulkan: 1.0.24, Compiler: GCC 6.3.0 20170406, File-System: ext4, Screen Resolution: 1920x1080

Compiler Notes: --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

Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 8192MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 250GB Samsung SSD 750 + 240GB ADATA SP550, Graphics: Intel HD 4600, Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411

OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Desktop: Xfce 4.12, Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440

Compiler Notes: --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
Processor Notes: Scaling Governor: intel_pstate powersave

postgresqlProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverVulkanCompilerFile-SystemScreen Resolutionpostgresqlasvany_bcache_prewarmAMD 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 20160609overlayfs2560x1440OpenBenchmarking.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 Processor Details- asvany_bcache_prewarm: Scaling Governor: intel_pstate powersave

postgresql vs. asvany_bcache_prewarm ComparisonPhoronix Test SuiteBaseline+2921.3%+2921.3%+5842.6%+5842.6%+8763.9%+8763.9%Mostly RAM - Heavy Contention - Read Write572.4%Buffer Test - Normal Load - Read Write2651.3%On-Disk - Heavy Contention - Read Write2298.2%On-Disk - Normal Load - Read Write11685.2%Mostly RAM - Normal Load - Read Write10146.3%Buffer Test - Heavy Contention - Read Write946.4%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchpostgresqlasvany_bcache_prewarm

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_prewarm3480.164270.664480.471967.931995.672851.2929.5341.68162.8582.06296.82272.49OpenBenchmarking.org

PostgreSQL pgbench

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Normal Load - Mode: Read Writepostgresqlasvany_bcache_prewarm7001400210028003500SE +/- 57.58, N = 3SE +/- 14.64, N = 33480.1629.531. (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_prewarm6001200180024003000Min: 3371.2 / Avg: 3480.16 / Max: 3566.91Min: 14.01 / Avg: 29.53 / Max: 58.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: Normal Load - Mode: Read Writepostgresqlasvany_bcache_prewarm9001800270036004500SE +/- 62.30, N = 5SE +/- 2.96, N = 64270.6641.681. (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_prewarm7001400210028003500Min: 4162.89 / Avg: 4270.66 / Max: 4503.71Min: 32.42 / Avg: 41.68 / Max: 52.681. (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_prewarm10002000300040005000SE +/- 27.03, N = 3SE +/- 2.62, N = 34480.47162.851. (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_prewarm8001600240032004000Min: 4429.08 / Avg: 4480.47 / Max: 4520.68Min: 157.62 / Avg: 162.85 / Max: 165.481. (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_prewarm400800120016002000SE +/- 286.01, N = 6SE +/- 1.42, N = 41967.9382.061. (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_prewarm30060090012001500Min: 1555.19 / Avg: 1967.93 / Max: 3376.75Min: 79.35 / Avg: 82.06 / Max: 84.591. (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_prewarm400800120016002000SE +/- 59.00, N = 6SE +/- 2.97, N = 31995.67296.821. (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_prewarm30060090012001500Min: 1832.54 / Avg: 1995.67 / Max: 2197.16Min: 290.89 / Avg: 296.82 / Max: 300.181. (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_prewarm6001200180024003000SE +/- 84.85, N = 6SE +/- 2.63, N = 32851.29272.491. (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_prewarm5001000150020002500Min: 2604.09 / Avg: 2851.29 / Max: 3139.81Min: 269.79 / Avg: 272.49 / Max: 277.751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

postgresql

Processor: AMD Ryzen 7 1700 Eight-Core @ 3.80GHz (16 Cores), Motherboard: MSI X370 SLI PLUS (MS-7A33) v2.0, Chipset: AMD Device 1450, Memory: 2 x 16384 MB DDR4-1333MHz CMK32GX4M2A2400C16, Disk: 512GB TOSHIBA-RD400, Graphics: MSI NVIDIA GeForce GTX 960 2048MB (1189/3505MHz), Audio: NVIDIA Device 0fba, Network: Realtek RTL8111/8168/8411

OS: Ubuntu 17.04, Kernel: 4.10.0-21-generic (x86_64), Desktop: LXDE 0.9.3, Display Server: X Server 1.19.3, Display Driver: NVIDIA 375.39, Vulkan: 1.0.24, Compiler: GCC 6.3.0 20170406, File-System: ext4, Screen Resolution: 1920x1080

Compiler Notes: --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

Testing initiated at 25 May 2017 00:54 by user root.

asvany_bcache_prewarm

Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 8192MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 250GB Samsung SSD 750 + 240GB ADATA SP550, Graphics: Intel HD 4600, Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411

OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Desktop: Xfce 4.12, Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440

Compiler Notes: --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
Processor Notes: Scaling Governor: intel_pstate powersave

Testing initiated at 31 May 2017 18:07 by user asvany.