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&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 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 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 recordsize=32k + logbias=throughput 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 153 6.556 153 660.774 104 9.597 1053 95.874 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 recordsize=32k + logbias=throughput sync=disabled 1000 2000 3000 4000 5000 SE +/- 1.25, N = 15 SE +/- 2.43, N = 3 SE +/- 1.42, N = 7 SE +/- 51.48, N = 3 170 172 153 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 recordsize=32k + logbias=throughput sync=disabled 2 4 6 8 10 SE +/- 0.045, N = 15 SE +/- 0.082, N = 3 SE +/- 0.062, N = 7 SE +/- 0.002, N = 3 5.903 5.830 6.556 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 recordsize=32k + logbias=throughput sync=disabled 900 1800 2700 3600 4500 SE +/- 1.48, N = 3 SE +/- 0.66, N = 3 SE +/- 3.47, N = 13 SE +/- 32.46, N = 3 173 172 153 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 recordsize=32k + logbias=throughput sync=disabled 140 280 420 560 700 SE +/- 4.95, N = 3 SE +/- 2.22, N = 3 SE +/- 19.58, N = 13 SE +/- 0.18, N = 3 578.26 582.42 660.77 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 recordsize=32k + logbias=throughput sync=disabled 200 400 600 800 1000 SE +/- 2.88, N = 9 SE +/- 0.78, N = 3 SE +/- 1.94, N = 9 SE +/- 36.88, N = 12 92 99 104 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 recordsize=32k + logbias=throughput sync=disabled 3 6 9 12 15 SE +/- 0.375, N = 9 SE +/- 0.079, N = 3 SE +/- 0.180, N = 9 SE +/- 0.034, N = 12 10.985 10.073 9.597 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 recordsize=32k + logbias=throughput sync=disabled 200 400 600 800 1000 SE +/- 41.27, N = 6 SE +/- 55.65, N = 9 SE +/- 36.59, N = 9 SE +/- 56.18, N = 12 784 997 1053 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 recordsize=32k + logbias=throughput sync=disabled 30 60 90 120 150 SE +/- 7.71, N = 6 SE +/- 6.34, N = 9 SE +/- 3.07, N = 9 SE +/- 5.00, N = 12 129.62 103.14 95.87 101.42 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.4