PostgreSQL on ZFS

single 256G SATA SSD, default settings

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2102245-HA-POSTGRESQ83
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Triggered
  Test
  Duration
default
February 24
  4 Hours, 36 Minutes
sync=disabled
February 24
  2 Hours, 30 Minutes
recordsize=32k
February 24
  4 Hours, 18 Minutes
recordsize=32k + logbias=throughput
February 24
  3 Hours, 7 Minutes
single SSD ext4
February 24
  49 Minutes
single SSD xfs
February 24
  48 Minutes
Invert Hiding All Results Option
  2 Hours, 41 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):


PostgreSQL on ZFSProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverVulkanCompilerFile-SystemScreen ResolutionOpenGLdefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfsAMD Ryzen 5 3600XT 6-Core @ 3.80GHz (6 Cores / 12 Threads)Gigabyte B550M DS3H (F11 BIOS)AMD Starship/Matisse16GB500GB Western Digital WDS500G2B0C-00PXH0 + 2000GB Western Digital WDS200T2B0C-00PXH0 + 256GB Samsung SSD 850 + 2 x 128GB SAMSUNG SSD 830NVIDIA GeForce GTX 1660 SUPER 6GBNVIDIA TU116 HD AudioRealtek RTL8111/8168/8411Linuxmint 20.15.4.0-65-generic (x86_64)XfceX Server 1.20.9NVIDIA1.2.155GCC 9.3.0zfs1024x768NVIDIA GeForce GTX 1660 SUPER 6GB (435/405MHz)4.6.0ext41920x1200NVIDIA GeForce GTX 1660 SUPER 6GB (375/405MHz)xfsOpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Processor Details- Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x8701021Security Details- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

defaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfsResult OverviewPhoronix Test Suite 10.4.0m1100%859%1618%2378%3137%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbench1000 - 100 - Read Write - Average Latency1000 - 100 - Read Write1 - 1 - Read Write - Average Latency1 - 1 - Read Write1 - 100 - Read Write - Average Latency1 - 100 - Read Write1000 - 1 - Read Write1000 - 1 - Read Write - Average Latency

PostgreSQL on ZFSpgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencydefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs1705.903173578.2559210.985784129.61647920.209426723.44810031.0111016101.4231725.830172582.4229910.073997103.1361536.556153660.7741049.597105395.8743023.309314318.9782264.433512919.5043033.304313319.2472244.457455521.965OpenBenchmarking.org

PostgreSQL pgbench

This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Writedefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs10002000300040005000SE +/- 1.25, N = 15SE +/- 51.48, N = 3SE +/- 2.43, N = 3SE +/- 1.42, N = 7SE +/- 0.63, N = 3SE +/- 0.41, N = 317047921721533023031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Writedefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs8001600240032004000Min: 155.82 / Avg: 169.56 / Max: 175.88Min: 4695.36 / Avg: 4792 / Max: 4871.09Min: 168.52 / Avg: 171.61 / Max: 176.4Min: 145.99 / Avg: 152.63 / Max: 155.84Min: 301.37 / Avg: 302.21 / Max: 303.44Min: 302.02 / Avg: 302.65 / Max: 303.411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latencydefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs246810SE +/- 0.045, N = 15SE +/- 0.002, N = 3SE +/- 0.082, N = 3SE +/- 0.062, N = 7SE +/- 0.007, N = 3SE +/- 0.004, N = 35.9030.2095.8306.5563.3093.3041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latencydefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs3691215Min: 5.69 / Avg: 5.9 / Max: 6.42Min: 0.21 / Avg: 0.21 / Max: 0.21Min: 5.67 / Avg: 5.83 / Max: 5.93Min: 6.42 / Avg: 6.56 / Max: 6.85Min: 3.3 / Avg: 3.31 / Max: 3.32Min: 3.3 / Avg: 3.3 / Max: 3.311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Writedefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs9001800270036004500SE +/- 1.48, N = 3SE +/- 32.46, N = 3SE +/- 0.66, N = 3SE +/- 3.47, N = 13SE +/- 0.75, N = 3SE +/- 0.43, N = 317342671721533143131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Writedefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs7001400210028003500Min: 170.23 / Avg: 173.02 / Max: 175.26Min: 4202.58 / Avg: 4266.73 / Max: 4307.46Min: 170.74 / Avg: 171.76 / Max: 172.98Min: 112.12 / Avg: 152.62 / Max: 159.8Min: 312.13 / Avg: 313.62 / Max: 314.43Min: 312.62 / Avg: 313.35 / Max: 314.111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencydefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs140280420560700SE +/- 4.95, N = 3SE +/- 0.18, N = 3SE +/- 2.22, N = 3SE +/- 19.58, N = 13SE +/- 0.76, N = 3SE +/- 0.44, N = 3578.2623.45582.42660.77318.98319.251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencydefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs120240360480600Min: 570.75 / Avg: 578.26 / Max: 587.61Min: 23.22 / Avg: 23.45 / Max: 23.8Min: 578.28 / Avg: 582.42 / Max: 585.88Min: 626 / Avg: 660.77 / Max: 892.22Min: 318.16 / Avg: 318.98 / Max: 320.49Min: 318.47 / Avg: 319.25 / Max: 3201. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Writedefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs2004006008001000SE +/- 2.88, N = 9SE +/- 36.88, N = 12SE +/- 0.78, N = 3SE +/- 1.94, N = 9SE +/- 0.05, N = 3SE +/- 1.19, N = 3921003991042262241. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Writedefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs2004006008001000Min: 76.66 / Avg: 91.83 / Max: 101.08Min: 834.31 / Avg: 1003.21 / Max: 1302.33Min: 98.16 / Avg: 99.29 / Max: 100.79Min: 95.86 / Avg: 104.5 / Max: 112.89Min: 225.55 / Avg: 225.6 / Max: 225.69Min: 222.72 / Avg: 224.4 / Max: 226.691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latencydefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs3691215SE +/- 0.375, N = 9SE +/- 0.034, N = 12SE +/- 0.079, N = 3SE +/- 0.180, N = 9SE +/- 0.001, N = 3SE +/- 0.024, N = 310.9851.01110.0739.5974.4334.4571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latencydefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs3691215Min: 9.9 / Avg: 10.98 / Max: 13.05Min: 0.77 / Avg: 1.01 / Max: 1.2Min: 9.92 / Avg: 10.07 / Max: 10.19Min: 8.86 / Avg: 9.6 / Max: 10.43Min: 4.43 / Avg: 4.43 / Max: 4.43Min: 4.41 / Avg: 4.46 / Max: 4.491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Writedefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs11002200330044005500SE +/- 41.27, N = 6SE +/- 56.18, N = 12SE +/- 55.65, N = 9SE +/- 36.59, N = 9SE +/- 6.38, N = 3SE +/- 27.63, N = 378410169971053512945551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Writedefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs9001800270036004500Min: 606.46 / Avg: 784.01 / Max: 894.9Min: 770.94 / Avg: 1016.25 / Max: 1450.13Min: 747.81 / Avg: 997.15 / Max: 1157.01Min: 929.51 / Avg: 1052.74 / Max: 1283.46Min: 5122.48 / Avg: 5128.94 / Max: 5141.7Min: 4511.39 / Avg: 4555.14 / Max: 4606.261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latencydefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs306090120150SE +/- 7.71, N = 6SE +/- 5.00, N = 12SE +/- 6.34, N = 9SE +/- 3.07, N = 9SE +/- 0.02, N = 3SE +/- 0.13, N = 3129.62101.42103.1495.8719.5021.971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latencydefaultsync=disabledrecordsize=32krecordsize=32k + logbias=throughputsingle SSD ext4single SSD xfs20406080100Min: 111.81 / Avg: 129.62 / Max: 164.94Min: 68.99 / Avg: 101.42 / Max: 129.77Min: 86.46 / Avg: 103.14 / Max: 133.76Min: 77.94 / Avg: 95.87 / Max: 107.62Min: 19.46 / Avg: 19.5 / Max: 19.53Min: 21.72 / Avg: 21.97 / Max: 22.181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm