PostgreSQL on ZFS
mirrored zpool on 2x 128G SATA SSD, modified zfs settings: recordsize=32k, default zfs settings: logbias=latency, sync=standard, ashift=12, no SLOG, no L2ARC
HTML result view exported from: https://openbenchmarking.org/result/2102248-HA-POSTGRESQ18&sor&grt.
PostgreSQL pgbench
Scaling Factor: 1 - Clients: 1 - Mode: Read Write
PostgreSQL pgbench
Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency
PostgreSQL pgbench
Scaling Factor: 1 - Clients: 100 - Mode: Read Write
PostgreSQL pgbench
Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency
PostgreSQL pgbench
Scaling Factor: 1000 - Clients: 1 - Mode: Read Write
PostgreSQL pgbench
Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency
PostgreSQL pgbench
Scaling Factor: 1000 - Clients: 100 - Mode: Read Write
PostgreSQL pgbench
Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency
Phoronix Test Suite v10.8.5