postgresql

during raid syncing

HTML result view exported from: https://openbenchmarking.org/result/1706016-ASVA-170525208&grr.

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

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

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write

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

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write

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

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write

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

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Write

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

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write

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

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Write

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

Phoronix Test Suite v10.8.4