mirrored zpool on 2x 128G SATA SSD, modified zfs settings: recordsize=32k, default zfs settings: logbias=latency, 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 2102248-HA-POSTGRESQ18 PostgreSQL on ZFS - Phoronix Test Suite PostgreSQL on ZFS mirrored zpool on 2x 128G SATA SSD, modified zfs settings: recordsize=32k, default zfs settings: logbias=latency, sync=standard, ashift=12, no SLOG, no L2ARC
HTML result view exported from: https://openbenchmarking.org/result/2102248-HA-POSTGRESQ18&sro&grt .
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 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 pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 100 - Read Write - Average Latency default sync=disabled recordsize=32k 170 5.903 173 578.255 92 10.985 784 129.616 4792 0.209 4267 23.448 1003 1.011 1016 101.423 172 5.830 172 582.422 99 10.073 997 103.136 OpenBenchmarking.org
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 recordsize=32k sync=disabled 1000 2000 3000 4000 5000 SE +/- 1.25, N = 15 SE +/- 2.43, N = 3 SE +/- 51.48, N = 3 170 172 4792 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 recordsize=32k sync=disabled 1.3282 2.6564 3.9846 5.3128 6.641 SE +/- 0.045, N = 15 SE +/- 0.082, N = 3 SE +/- 0.002, N = 3 5.903 5.830 0.209 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 recordsize=32k sync=disabled 900 1800 2700 3600 4500 SE +/- 1.48, N = 3 SE +/- 0.66, N = 3 SE +/- 32.46, N = 3 173 172 4267 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 recordsize=32k sync=disabled 130 260 390 520 650 SE +/- 4.95, N = 3 SE +/- 2.22, N = 3 SE +/- 0.18, N = 3 578.26 582.42 23.45 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 recordsize=32k sync=disabled 200 400 600 800 1000 SE +/- 2.88, N = 9 SE +/- 0.78, N = 3 SE +/- 36.88, N = 12 92 99 1003 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 recordsize=32k sync=disabled 3 6 9 12 15 SE +/- 0.375, N = 9 SE +/- 0.079, N = 3 SE +/- 0.034, N = 12 10.985 10.073 1.011 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 recordsize=32k sync=disabled 200 400 600 800 1000 SE +/- 41.27, N = 6 SE +/- 55.65, N = 9 SE +/- 56.18, N = 12 784 997 1016 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 default recordsize=32k sync=disabled 30 60 90 120 150 SE +/- 7.71, N = 6 SE +/- 6.34, N = 9 SE +/- 5.00, N = 12 129.62 103.14 101.42 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.4