PostgreSQL on ZFS
single 256G SATA SSD, default settings


default: 

	Processor: AMD Ryzen 5 3600XT 6-Core @ 3.80GHz (6 Cores / 12 Threads), Motherboard: Gigabyte B550M DS3H (F11 BIOS), Chipset: AMD Starship/Matisse, Memory: 16GB, Disk: 500GB Western Digital WDS500G2B0C-00PXH0 + 2000GB Western Digital WDS200T2B0C-00PXH0 + 256GB Samsung SSD 850 + 2 x 128GB SAMSUNG SSD 830, Graphics: NVIDIA GeForce GTX 1660 SUPER 6GB, Audio: NVIDIA TU116 HD Audio, Network: Realtek RTL8111/8168/8411

	OS: Linuxmint 20.1, Kernel: 5.4.0-65-generic (x86_64), Desktop: Xfce, Display Server: X Server 1.20.9, Display Driver: NVIDIA, Vulkan: 1.2.155, Compiler: GCC 9.3.0, File-System: zfs, Screen Resolution: 1024x768

sync=disabled: 

	Processor: AMD Ryzen 5 3600XT 6-Core @ 3.80GHz (6 Cores / 12 Threads), Motherboard: Gigabyte B550M DS3H (F11 BIOS), Chipset: AMD Starship/Matisse, Memory: 16GB, Disk: 500GB Western Digital WDS500G2B0C-00PXH0 + 2000GB Western Digital WDS200T2B0C-00PXH0 + 256GB Samsung SSD 850 + 2 x 128GB SAMSUNG SSD 830, Graphics: NVIDIA GeForce GTX 1660 SUPER 6GB, Audio: NVIDIA TU116 HD Audio, Network: Realtek RTL8111/8168/8411

	OS: Linuxmint 20.1, Kernel: 5.4.0-65-generic (x86_64), Desktop: Xfce, Display Server: X Server 1.20.9, Display Driver: NVIDIA, Vulkan: 1.2.155, Compiler: GCC 9.3.0, File-System: zfs, Screen Resolution: 1024x768

recordsize=32k: 

	Processor: AMD Ryzen 5 3600XT 6-Core @ 3.80GHz (6 Cores / 12 Threads), Motherboard: Gigabyte B550M DS3H (F11 BIOS), Chipset: AMD Starship/Matisse, Memory: 16GB, Disk: 500GB Western Digital WDS500G2B0C-00PXH0 + 2000GB Western Digital WDS200T2B0C-00PXH0 + 256GB Samsung SSD 850 + 2 x 128GB SAMSUNG SSD 830, Graphics: NVIDIA GeForce GTX 1660 SUPER 6GB, Audio: NVIDIA TU116 HD Audio, Network: Realtek RTL8111/8168/8411

	OS: Linuxmint 20.1, Kernel: 5.4.0-65-generic (x86_64), Desktop: Xfce, Display Server: X Server 1.20.9, Display Driver: NVIDIA, Vulkan: 1.2.155, Compiler: GCC 9.3.0, File-System: zfs, Screen Resolution: 1024x768

recordsize=32k + logbias=throughput: 

	Processor: AMD Ryzen 5 3600XT 6-Core @ 3.80GHz (6 Cores / 12 Threads), Motherboard: Gigabyte B550M DS3H (F11 BIOS), Chipset: AMD Starship/Matisse, Memory: 16GB, Disk: 500GB Western Digital WDS500G2B0C-00PXH0 + 2000GB Western Digital WDS200T2B0C-00PXH0 + 256GB Samsung SSD 850 + 2 x 128GB SAMSUNG SSD 830, Graphics: NVIDIA GeForce GTX 1660 SUPER 6GB, Audio: NVIDIA TU116 HD Audio, Network: Realtek RTL8111/8168/8411

	OS: Linuxmint 20.1, Kernel: 5.4.0-65-generic (x86_64), Desktop: Xfce, Display Server: X Server 1.20.9, Display Driver: NVIDIA, Vulkan: 1.2.155, Compiler: GCC 9.3.0, File-System: zfs, Screen Resolution: 1024x768

single SSD ext4: 

	Processor: AMD Ryzen 5 3600XT 6-Core @ 3.80GHz (6 Cores / 12 Threads), Motherboard: Gigabyte B550M DS3H (F11 BIOS), Chipset: AMD Starship/Matisse, Memory: 16GB, Disk: 500GB Western Digital WDS500G2B0C-00PXH0 + 2000GB Western Digital WDS200T2B0C-00PXH0 + 256GB Samsung SSD 850 + 2 x 128GB SAMSUNG SSD 830, Graphics: NVIDIA GeForce GTX 1660 SUPER 6GB (435/405MHz), Audio: NVIDIA TU116 HD Audio, Network: Realtek RTL8111/8168/8411

	OS: Linuxmint 20.1, Kernel: 5.4.0-65-generic (x86_64), Desktop: Xfce, Display Server: X Server 1.20.9, Display Driver: NVIDIA, OpenGL: 4.6.0, Vulkan: 1.2.155, Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1920x1200

single SSD xfs: 

	Processor: AMD Ryzen 5 3600XT 6-Core @ 3.80GHz (6 Cores / 12 Threads), Motherboard: Gigabyte B550M DS3H (F11 BIOS), Chipset: AMD Starship/Matisse, Memory: 16GB, Disk: 500GB Western Digital WDS500G2B0C-00PXH0 + 2000GB Western Digital WDS200T2B0C-00PXH0 + 256GB Samsung SSD 850 + 2 x 128GB SAMSUNG SSD 830, Graphics: NVIDIA GeForce GTX 1660 SUPER 6GB (375/405MHz), Audio: NVIDIA TU116 HD Audio, Network: Realtek RTL8111/8168/8411

	OS: Linuxmint 20.1, Kernel: 5.4.0-65-generic (x86_64), Desktop: Xfce, Display Server: X Server 1.20.9, Display Driver: NVIDIA, OpenGL: 4.6.0, Vulkan: 1.2.155, Compiler: GCC 9.3.0, File-System: xfs, Screen Resolution: 1920x1200


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 1 - Mode: Read Write
TPS > Higher Is Better
default ............................. 170  |=
sync=disabled ....................... 4792 |===================================
recordsize=32k ...................... 172  |=
recordsize=32k + logbias=throughput . 153  |=
single SSD ext4 ..................... 302  |==
single SSD xfs ...................... 303  |==


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency
ms < Lower Is Better
default ............................. 5.903 |===============================
sync=disabled ....................... 0.209 |=
recordsize=32k ...................... 5.830 |==============================
recordsize=32k + logbias=throughput . 6.556 |==================================
single SSD ext4 ..................... 3.309 |=================
single SSD xfs ...................... 3.304 |=================


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 100 - Mode: Read Write
TPS > Higher Is Better
default ............................. 173  |=
sync=disabled ....................... 4267 |===================================
recordsize=32k ...................... 172  |=
recordsize=32k + logbias=throughput . 153  |=
single SSD ext4 ..................... 314  |===
single SSD xfs ...................... 313  |===


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency
ms < Lower Is Better
default ............................. 578.26 |=============================
sync=disabled ....................... 23.45  |=
recordsize=32k ...................... 582.42 |=============================
recordsize=32k + logbias=throughput . 660.77 |=================================
single SSD ext4 ..................... 318.98 |================
single SSD xfs ...................... 319.25 |================


PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 1 - Mode: Read Write
TPS > Higher Is Better
default ............................. 92   |===
sync=disabled ....................... 1003 |===================================
recordsize=32k ...................... 99   |===
recordsize=32k + logbias=throughput . 104  |====
single SSD ext4 ..................... 226  |========
single SSD xfs ...................... 224  |========


PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency
ms < Lower Is Better
default ............................. 10.985 |=================================
sync=disabled ....................... 1.011  |===
recordsize=32k ...................... 10.073 |==============================
recordsize=32k + logbias=throughput . 9.597  |=============================
single SSD ext4 ..................... 4.433  |=============
single SSD xfs ...................... 4.457  |=============


PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 100 - Mode: Read Write
TPS > Higher Is Better
default ............................. 784  |=====
sync=disabled ....................... 1016 |=======
recordsize=32k ...................... 997  |=======
recordsize=32k + logbias=throughput . 1053 |=======
single SSD ext4 ..................... 5129 |===================================
single SSD xfs ...................... 4555 |===============================


PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency
ms < Lower Is Better
default ............................. 129.62 |=================================
sync=disabled ....................... 101.42 |==========================
recordsize=32k ...................... 103.14 |==========================
recordsize=32k + logbias=throughput . 95.87  |========================
single SSD ext4 ..................... 19.50  |=====
single SSD xfs ...................... 21.97  |======