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&sor&grs&export=pdf .
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: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write 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 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write default sync=disabled recordsize=32k recordsize=32k + logbias=throughput 5.903 170 129.616 784 10.985 92 578.255 173 0.209 4792 101.423 1016 1.011 1003 23.448 4267 5.830 172 103.136 997 10.073 99 582.422 172 6.556 153 95.874 1053 9.597 104 660.774 153 OpenBenchmarking.org
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 sync=disabled recordsize=32k default recordsize=32k + logbias=throughput 2 4 6 8 10 SE +/- 0.002, N = 3 SE +/- 0.082, N = 3 SE +/- 0.045, N = 15 SE +/- 0.062, N = 7 0.209 5.830 5.903 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 sync=disabled recordsize=32k default recordsize=32k + logbias=throughput 1000 2000 3000 4000 5000 SE +/- 51.48, N = 3 SE +/- 2.43, N = 3 SE +/- 1.25, N = 15 SE +/- 1.42, N = 7 4792 172 170 153 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 - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency recordsize=32k + logbias=throughput sync=disabled recordsize=32k default 30 60 90 120 150 SE +/- 3.07, N = 9 SE +/- 5.00, N = 12 SE +/- 6.34, N = 9 SE +/- 7.71, N = 6 95.87 101.42 103.14 129.62 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 recordsize=32k + logbias=throughput sync=disabled recordsize=32k default 200 400 600 800 1000 SE +/- 36.59, N = 9 SE +/- 56.18, N = 12 SE +/- 55.65, N = 9 SE +/- 41.27, N = 6 1053 1016 997 784 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 sync=disabled recordsize=32k + logbias=throughput recordsize=32k default 3 6 9 12 15 SE +/- 0.034, N = 12 SE +/- 0.180, N = 9 SE +/- 0.079, N = 3 SE +/- 0.375, N = 9 1.011 9.597 10.073 10.985 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 sync=disabled recordsize=32k + logbias=throughput recordsize=32k default 200 400 600 800 1000 SE +/- 36.88, N = 12 SE +/- 1.94, N = 9 SE +/- 0.78, N = 3 SE +/- 2.88, N = 9 1003 104 99 92 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 sync=disabled default recordsize=32k recordsize=32k + logbias=throughput 140 280 420 560 700 SE +/- 0.18, N = 3 SE +/- 4.95, N = 3 SE +/- 2.22, N = 3 SE +/- 19.58, N = 13 23.45 578.26 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 sync=disabled default recordsize=32k recordsize=32k + logbias=throughput 900 1800 2700 3600 4500 SE +/- 32.46, N = 3 SE +/- 1.48, N = 3 SE +/- 0.66, N = 3 SE +/- 3.47, N = 13 4267 173 172 153 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.4