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, "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency", Lower Results Are Better "default",587.608,576.405,570.753 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Write", Higher Results Are Better "default",170.233896,173.548869,175.262715 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency", Lower Results Are Better "default",5.799,5.847,6.418,5.902,6.018,5.839,5.823,5.913,5.847,6.027,6.044,5.715,5.686,5.833,5.831 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Write", Higher Results Are Better "default",172.463371,171.058361,155.824907,169.460366,166.17409,171.266059,171.757509,169.142153,171.041203,165.942923,165.47341,174.994968,175.87916,171.470028,171.513344 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency", Lower Results Are Better "default",130.674,130.305,123.963,111.806,164.935,116.014 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write", Higher Results Are Better "default",765.493996,767.760919,807.10455,894.90301,606.459373,862.36439 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency", Lower Results Are Better "default",13.047,10.695,10.856,12.665,10.14,10.613,10.91,9.895,10.041 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write", Higher Results Are Better "default",76.659231,93.510258,92.124298,78.968451,98.629759,94.237032,91.668845,101.078003,99.606074