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&gru&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 pgbench: 1 - 100 - Read Write pgbench: 1000 - 1 - Read Write pgbench: 1000 - 100 - Read Write pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write - Average Latency default sync=disabled recordsize=32k recordsize=32k + logbias=throughput single SSD ext4 170 173 92 784 5.903 578.255 10.985 129.616 4792 4267 1003 1016 0.209 23.448 1.011 101.423 172 172 99 997 5.830 582.422 10.073 103.136 153 153 104 1053 6.556 660.774 9.597 95.874 302 314 226 5129 3.309 318.978 4.433 19.504 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 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: 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
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: 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: 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: 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: 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: 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
Phoronix Test Suite v10.8.4