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 postgresql - Phoronix Test Suite postgresql during raid syncing
HTML result view exported from: https://openbenchmarking.org/result/1706016-ASVA-170525208&grr&rdt .
postgresql Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Desktop Display Server Display Driver Vulkan Compiler File-System Screen Resolution postgresql asvany_bcache_prewarm AMD Ryzen 7 1700 Eight-Core @ 3.80GHz (16 Cores) MSI X370 SLI PLUS (MS-7A33) v2.0 AMD Device 1450 2 x 16384 MB DDR4-1333MHz CMK32GX4M2A2400C16 512GB TOSHIBA-RD400 MSI NVIDIA GeForce GTX 960 2048MB (1189/3505MHz) NVIDIA Device 0fba Realtek RTL8111/8168/8411 Ubuntu 17.04 4.10.0-21-generic (x86_64) LXDE 0.9.3 X Server 1.19.3 NVIDIA 375.39 1.0.24 GCC 6.3.0 20170406 ext4 1920x1080 Intel Core i5-4590 @ 3.70GHz (4 Cores) MSI Z97-G43 (MS-7816) v3.0 Intel 4th Gen Core DRAM 8192MB 2 x 4001GB Western Digital WD40EFRX-68W + 250GB Samsung SSD 750 + 240GB ADATA SP550 Intel HD 4600 Intel Xeon E3-1200 v3/4th Ubuntu 16.04 4.4.0-21-generic (x86_64) Xfce 4.12 X Server 1.18.3 intel 2.99.917 GCC 5.4.0 20160609 overlayfs 2560x1440 OpenBenchmarking.org Compiler 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 pgbench: Buffer Test - Heavy Contention - Read Write pgbench: Mostly RAM - Heavy Contention - Read Write pgbench: On-Disk - Heavy Contention - Read Write pgbench: Buffer Test - Normal Load - Read Write pgbench: Mostly RAM - Normal Load - Read Write pgbench: On-Disk - Normal Load - Read Write postgresql asvany_bcache_prewarm 2851.29 1995.67 1967.93 4480.47 4270.66 3480.16 272.49 296.82 82.06 162.85 41.68 29.53 OpenBenchmarking.org
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write postgresql asvany_bcache_prewarm 600 1200 1800 2400 3000 SE +/- 84.85, N = 6 SE +/- 2.63, N = 3 2851.29 272.49 1. (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.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write postgresql asvany_bcache_prewarm 400 800 1200 1600 2000 SE +/- 59.00, N = 6 SE +/- 2.97, N = 3 1995.67 296.82 1. (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.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write postgresql asvany_bcache_prewarm 400 800 1200 1600 2000 SE +/- 286.01, N = 6 SE +/- 1.42, N = 4 1967.93 82.06 1. (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.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write postgresql asvany_bcache_prewarm 1000 2000 3000 4000 5000 SE +/- 27.03, N = 3 SE +/- 2.62, N = 3 4480.47 162.85 1. (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.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write postgresql asvany_bcache_prewarm 900 1800 2700 3600 4500 SE +/- 62.30, N = 5 SE +/- 2.96, N = 6 4270.66 41.68 1. (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.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write postgresql asvany_bcache_prewarm 700 1400 2100 2800 3500 SE +/- 57.58, N = 3 SE +/- 14.64, N = 3 3480.16 29.53 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
Phoronix Test Suite v10.8.4