Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2102248-HA-POSTGRESQ23 PostgreSQL on ZFS - Phoronix Test Suite PostgreSQL on ZFS single 256G SATA SSD, default settings
HTML result view exported from: https://openbenchmarking.org/result/2102248-HA-POSTGRESQ23&grs&sro&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 OpenGL default sync=disabled recordsize=32k recordsize=32k + logbias=throughput single SSD ext4 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 NVIDIA GeForce GTX 1660 SUPER 6GB (435/405MHz) 4.6.0 ext4 1920x1200 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 single SSD ext4 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 3.309 302 19.504 5129 4.433 226 318.978 314 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 default recordsize=32k recordsize=32k + logbias=throughput single SSD ext4 sync=disabled 2 4 6 8 10 SE +/- 0.045, N = 15 SE +/- 0.082, N = 3 SE +/- 0.062, N = 7 SE +/- 0.007, N = 3 SE +/- 0.002, N = 3 5.903 5.830 6.556 3.309 0.209 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 recordsize=32k recordsize=32k + logbias=throughput single SSD ext4 sync=disabled 1000 2000 3000 4000 5000 SE +/- 1.25, N = 15 SE +/- 2.43, N = 3 SE +/- 1.42, N = 7 SE +/- 0.63, N = 3 SE +/- 51.48, N = 3 170 172 153 302 4792 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 single SSD ext4 sync=disabled 30 60 90 120 150 SE +/- 7.71, N = 6 SE +/- 6.34, N = 9 SE +/- 3.07, N = 9 SE +/- 0.02, N = 3 SE +/- 5.00, N = 12 129.62 103.14 95.87 19.50 101.42 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 single SSD ext4 sync=disabled 1100 2200 3300 4400 5500 SE +/- 41.27, N = 6 SE +/- 55.65, N = 9 SE +/- 36.59, N = 9 SE +/- 6.38, N = 3 SE +/- 56.18, N = 12 784 997 1053 5129 1016 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 single SSD ext4 sync=disabled 3 6 9 12 15 SE +/- 0.375, N = 9 SE +/- 0.079, N = 3 SE +/- 0.180, N = 9 SE +/- 0.001, N = 3 SE +/- 0.034, N = 12 10.985 10.073 9.597 4.433 1.011 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 single SSD ext4 sync=disabled 200 400 600 800 1000 SE +/- 2.88, N = 9 SE +/- 0.78, N = 3 SE +/- 1.94, N = 9 SE +/- 0.05, N = 3 SE +/- 36.88, N = 12 92 99 104 226 1003 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 single SSD ext4 sync=disabled 140 280 420 560 700 SE +/- 4.95, N = 3 SE +/- 2.22, N = 3 SE +/- 19.58, N = 13 SE +/- 0.76, N = 3 SE +/- 0.18, N = 3 578.26 582.42 660.77 318.98 23.45 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 single SSD ext4 sync=disabled 900 1800 2700 3600 4500 SE +/- 1.48, N = 3 SE +/- 0.66, N = 3 SE +/- 3.47, N = 13 SE +/- 0.75, N = 3 SE +/- 32.46, N = 3 173 172 153 314 4267 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.4