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

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
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
default
February 24 2021
  4 Hours, 36 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

PostgreSQL on ZFS Suite 1.0.0 System Test suite extracted from PostgreSQL on ZFS. pts/pgbench-1.10.1 -s 1000 -c 1 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency pts/pgbench-1.10.1 -s 1000 -c 1 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write pts/pgbench-1.10.1 -s 1000 -c 100 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency pts/pgbench-1.10.1 -s 1000 -c 100 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write pts/pgbench-1.10.1 -s 1 -c 1 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency pts/pgbench-1.10.1 -s 1 -c 1 Scaling Factor: 1 - Clients: 1 - Mode: Read Write pts/pgbench-1.10.1 -s 1 -c 100 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency pts/pgbench-1.10.1 -s 1 -c 100 Scaling Factor: 1 - Clients: 100 - Mode: Read Write