mirrored zpool on 2x 128G SATA SSD, default zfs settings: sync=standard, logbias=latency, recordsize=128k, 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 2102240-HA-POSTGRESQ73
PostgreSQL on ZFS
mirrored zpool on 2x 128G SATA SSD, default zfs settings: sync=standard, logbias=latency, recordsize=128k, ashift=12, no SLOG, no L2ARC
,,"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
,,"default"
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency (ms)",LIB,578.255
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Write (TPS)",HIB,173
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency (ms)",LIB,5.903
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Write (TPS)",HIB,170
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency (ms)",LIB,129.616
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write (TPS)",HIB,784
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency (ms)",LIB,10.985
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write (TPS)",HIB,92