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 PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better default . 10.99 |============================================================== PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better default . 92 |================================================================= PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better default . 129.62 |============================================================= PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better default . 784 |================================================================ PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better default . 5.903 |============================================================== PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better default . 170 |================================================================ PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better default . 578.26 |============================================================= PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better default . 173 |================================================================