mirrored zpool on 2x 128G SATA SSD, modified zfs settings: recordsize=32k, logbias=throughput, default zfs settings: sync=standard, ashift=12, no SLOG, no L2ARC
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2102242-HA-POSTGRESQ30 PostgreSQL on ZFS - Phoronix Test Suite PostgreSQL on ZFS mirrored zpool on 2x 128G SATA SSD, modified zfs settings: recordsize=32k, logbias=throughput, default zfs settings: sync=standard, ashift=12, no SLOG, no L2ARC
HTML result view exported from: https://openbenchmarking.org/result/2102242-HA-POSTGRESQ30&grr .
PostgreSQL on ZFS Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Desktop Display Server Display Driver Vulkan Compiler File-System Screen Resolution default sync=disabled recordsize=32k recordsize=32k + logbias=throughput AMD Ryzen 5 3600XT 6-Core @ 3.80GHz (6 Cores / 12 Threads) Gigabyte B550M DS3H (F11 BIOS) AMD Starship/Matisse 16GB 500GB Western Digital WDS500G2B0C-00PXH0 + 2000GB Western Digital WDS200T2B0C-00PXH0 + 256GB Samsung SSD 850 + 2 x 128GB SAMSUNG SSD 830 NVIDIA GeForce GTX 1660 SUPER 6GB NVIDIA TU116 HD Audio Realtek RTL8111/8168/8411 Linuxmint 20.1 5.4.0-65-generic (x86_64) Xfce X Server 1.20.9 NVIDIA 1.2.155 GCC 9.3.0 zfs 1024x768 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler Details - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --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-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Processor Details - Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x8701021 Security Details - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected
PostgreSQL on ZFS pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write default sync=disabled recordsize=32k recordsize=32k + logbias=throughput 129.616 784 10.985 92 5.903 170 578.255 173 101.423 1016 1.011 1003 0.209 4792 23.448 4267 103.136 997 10.073 99 5.830 172 582.422 172 95.874 1053 9.597 104 6.556 153 660.774 153 OpenBenchmarking.org
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency default sync=disabled recordsize=32k recordsize=32k + logbias=throughput 30 60 90 120 150 SE +/- 7.71, N = 6 SE +/- 5.00, N = 12 SE +/- 6.34, N = 9 SE +/- 3.07, N = 9 129.62 101.42 103.14 95.87 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write default sync=disabled recordsize=32k recordsize=32k + logbias=throughput 200 400 600 800 1000 SE +/- 41.27, N = 6 SE +/- 56.18, N = 12 SE +/- 55.65, N = 9 SE +/- 36.59, N = 9 784 1016 997 1053 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency default sync=disabled recordsize=32k recordsize=32k + logbias=throughput 3 6 9 12 15 SE +/- 0.375, N = 9 SE +/- 0.034, N = 12 SE +/- 0.079, N = 3 SE +/- 0.180, N = 9 10.985 1.011 10.073 9.597 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write default sync=disabled recordsize=32k recordsize=32k + logbias=throughput 200 400 600 800 1000 SE +/- 2.88, N = 9 SE +/- 36.88, N = 12 SE +/- 0.78, N = 3 SE +/- 1.94, N = 9 92 1003 99 104 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency default sync=disabled recordsize=32k recordsize=32k + logbias=throughput 2 4 6 8 10 SE +/- 0.045, N = 15 SE +/- 0.002, N = 3 SE +/- 0.082, N = 3 SE +/- 0.062, N = 7 5.903 0.209 5.830 6.556 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write default sync=disabled recordsize=32k recordsize=32k + logbias=throughput 1000 2000 3000 4000 5000 SE +/- 1.25, N = 15 SE +/- 51.48, N = 3 SE +/- 2.43, N = 3 SE +/- 1.42, N = 7 170 4792 172 153 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency default sync=disabled recordsize=32k recordsize=32k + logbias=throughput 140 280 420 560 700 SE +/- 4.95, N = 3 SE +/- 0.18, N = 3 SE +/- 2.22, N = 3 SE +/- 19.58, N = 13 578.26 23.45 582.42 660.77 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write default sync=disabled recordsize=32k recordsize=32k + logbias=throughput 900 1800 2700 3600 4500 SE +/- 1.48, N = 3 SE +/- 32.46, N = 3 SE +/- 0.66, N = 3 SE +/- 3.47, N = 13 173 4267 172 153 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.4