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 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: 1 - Mode: Read Write (TPS)",HIB,170 "PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency (ms)",LIB,5.903 "PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Write (TPS)",HIB,173 "PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency (ms)",LIB,578.255 "PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write (TPS)",HIB,92 "PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency (ms)",LIB,10.985 "PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write (TPS)",HIB,784 "PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency (ms)",LIB,129.616