PostgreSQL on ZFS

single 256G SATA SSD, default settings

HTML result view exported from: https://openbenchmarking.org/result/2102245-HA-POSTGRESQ83&sor.

PostgreSQL on ZFSProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverVulkanCompilerFile-SystemScreen ResolutionOpenGLdefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfsAMD Ryzen 5 3600XT 6-Core @ 3.80GHz (6 Cores / 12 Threads)Gigabyte B550M DS3H (F11 BIOS)AMD Starship/Matisse16GB500GB Western Digital WDS500G2B0C-00PXH0 + 2000GB Western Digital WDS200T2B0C-00PXH0 + 256GB Samsung SSD 850 + 2 x 128GB SAMSUNG SSD 830NVIDIA GeForce GTX 1660 SUPER 6GBNVIDIA TU116 HD AudioRealtek RTL8111/8168/8411Linuxmint 20.15.4.0-65-generic (x86_64)XfceX Server 1.20.9NVIDIA1.2.155GCC 9.3.0zfs1024x768NVIDIA GeForce GTX 1660 SUPER 6GB (435/405MHz)4.6.0ext41920x1200NVIDIA GeForce GTX 1660 SUPER 6GB (375/405MHz)xfsOpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler 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: 0x8701021Security 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 ZFSpgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencydefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs1705.903173578.2559210.985784129.61647920.209426723.44810031.0111016101.4231725.830172582.4229910.073997103.1361536.556153660.7741049.597105395.8743023.309314318.9782264.433512919.5043033.304313319.2472244.457455521.965OpenBenchmarking.org

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Writesync=disabledsingle SSD xfssingle SSD ext4recordsize=32kdefaultrecordsize=32k + logbias=throughput10002000300040005000SE +/- 51.48, N = 3SE +/- 0.41, N = 3SE +/- 0.63, N = 3SE +/- 2.43, N = 3SE +/- 1.25, N = 15SE +/- 1.42, N = 747923033021721701531. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latencysync=disabledsingle SSD xfssingle SSD ext4recordsize=32kdefaultrecordsize=32k + logbias=throughput246810SE +/- 0.002, N = 3SE +/- 0.004, N = 3SE +/- 0.007, N = 3SE +/- 0.082, N = 3SE +/- 0.045, N = 15SE +/- 0.062, N = 70.2093.3043.3095.8305.9036.5561. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Writesync=disabledsingle SSD ext4single SSD xfsdefaultrecordsize=32krecordsize=32k + logbias=throughput9001800270036004500SE +/- 32.46, N = 3SE +/- 0.75, N = 3SE +/- 0.43, N = 3SE +/- 1.48, N = 3SE +/- 0.66, N = 3SE +/- 3.47, N = 1342673143131731721531. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencysync=disabledsingle SSD ext4single SSD xfsdefaultrecordsize=32krecordsize=32k + logbias=throughput140280420560700SE +/- 0.18, N = 3SE +/- 0.76, N = 3SE +/- 0.44, N = 3SE +/- 4.95, N = 3SE +/- 2.22, N = 3SE +/- 19.58, N = 1323.45318.98319.25578.26582.42660.771. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Writesync=disabledsingle SSD ext4single SSD xfsrecordsize=32k + logbias=throughputrecordsize=32kdefault2004006008001000SE +/- 36.88, N = 12SE +/- 0.05, N = 3SE +/- 1.19, N = 3SE +/- 1.94, N = 9SE +/- 0.78, N = 3SE +/- 2.88, N = 9100322622410499921. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latencysync=disabledsingle SSD ext4single SSD xfsrecordsize=32k + logbias=throughputrecordsize=32kdefault3691215SE +/- 0.034, N = 12SE +/- 0.001, N = 3SE +/- 0.024, N = 3SE +/- 0.180, N = 9SE +/- 0.079, N = 3SE +/- 0.375, N = 91.0114.4334.4579.59710.07310.9851. (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.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Writesingle SSD ext4single SSD xfsrecordsize=32k + logbias=throughputsync=disabledrecordsize=32kdefault11002200330044005500SE +/- 6.38, N = 3SE +/- 27.63, N = 3SE +/- 36.59, N = 9SE +/- 56.18, N = 12SE +/- 55.65, N = 9SE +/- 41.27, N = 651294555105310169977841. (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.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latencysingle SSD ext4single SSD xfsrecordsize=32k + logbias=throughputsync=disabledrecordsize=32kdefault306090120150SE +/- 0.02, N = 3SE +/- 0.13, N = 3SE +/- 3.07, N = 9SE +/- 5.00, N = 12SE +/- 6.34, N = 9SE +/- 7.71, N = 619.5021.9795.87101.42103.14129.621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4