pgbench-ext4-SATA

DB performance testing by FS: SATA attached variable rpm HD with ext4

HTML result view exported from: https://openbenchmarking.org/result/2107046-IB-MERGE425502&rdt.

pgbench-ext4-SATAProcessorMotherboardChipsetMemoryDiskOSKernelCompilerFile-SystemDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSARMv8 Cortex-A72 @ 1.42GHz (6 Cores)Pine64 RockPro64 v2.1Fuzhou Rockchip RK33994096MB4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32GGentoo/Linux5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64)GCC 11.1.0ext4btrfsext4btrfsOpenBenchmarking.orgCompiler Details- DB performance by FS: SATA variable rpm HD with ext4, DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib, DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4, DB performance by FS: Btrfs on 7200rpm SAS drive: --bindir=/usr/aarch64-unknown-linux-gnu/gcc-bin/11.1.0 --build=aarch64-unknown-linux-gnu --datadir=/usr/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0 --disable-esp --disable-fixed-point --disable-libada --disable-libssp --disable-libvtv --disable-multilib --disable-systemtap --disable-valgrind-annotations --disable-vtable-verify --disable-werror --enable-__cxa_atexit --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-default-ssp --enable-languages=c,c++,fortran --enable-libgomp --enable-libstdcxx-time --enable-lto --enable-nls --enable-obsolete --enable-secureplt --enable-shared --enable-threads=posix --host=aarch64-unknown-linux-gnu --includedir=/usr/lib/gcc/aarch64-unknown-linux-gnu/11.1.0/include --mandir=/usr/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0/man --with-python-dir=/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0/python --without-isl --without-zstd Processor Details- Scaling Governor: cpufreq-dt schedutilSecurity Details- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Vulnerable + tsx_async_abort: Not affected

pgbench-ext4-SATApgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS52860.1949210.834139133.598128837.76991549.8161337.535901109.9732742.033405130.7453826.808455231.034181278.6761666.228117431.577187545.827124814.10367748.923891124.84740000.2575917.144149823.340144286.94254944.6706712.592492069.7932643.84093275.3712935.198911410.991279186.9171187.963361423.262126808.508412541.577361423.188392642.10856220.1832405.582151473.304489103.8175717.5872441.58758861.414491014.69240540.2473132.875158313.161154536.476281781.76720230.797382672.8643628.272264331.9951579.164110779.03451398.1011376.699127394.256649157.272452235.74283602.106101996.75952230.2006914.745147903.383147316.79590607.7857262.201591700.2244921.556523329.7534124.5463582140.501311178.7092148.883491040.514717143.598472160.822321719.510432319.263OpenBenchmarking.org

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS12002400360048006000SE +/- 272.89, N = 12SE +/- 216.12, N = 12SE +/- 264.65, N = 15SE +/- 17.82, N = 3SE +/- 310.66, N = 12528640005622405452231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS0.05780.11560.17340.23120.289SE +/- 0.009, N = 12SE +/- 0.012, N = 12SE +/- 0.008, N = 15SE +/- 0.001, N = 3SE +/- 0.013, N = 120.1940.2570.1830.2470.2001. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read WriteDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS50100150200250SE +/- 0.25, N = 3SE +/- 2.27, N = 15SE +/- 27.89, N = 12SE +/- 1.09, N = 15SE +/- 2.26, N = 15925924031691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS816243240SE +/- 0.030, N = 3SE +/- 0.627, N = 15SE +/- 1.124, N = 12SE +/- 1.105, N = 15SE +/- 0.490, N = 1510.83417.1445.58232.87514.7451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS3K6K9K12K15KSE +/- 125.25, N = 7SE +/- 70.45, N = 3SE +/- 83.84, N = 3SE +/- 144.82, N = 3SE +/- 116.66, N = 313913149821514715831147901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS0.80961.61922.42883.23844.048SE +/- 0.033, N = 7SE +/- 0.016, N = 3SE +/- 0.018, N = 3SE +/- 0.029, N = 3SE +/- 0.027, N = 33.5983.3403.3043.1613.3831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS3K6K9K12K15KSE +/- 85.70, N = 3SE +/- 114.79, N = 15SE +/- 144.24, N = 3SE +/- 164.46, N = 3128831442815453147311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS246810SE +/- 0.051, N = 3SE +/- 0.054, N = 15SE +/- 0.061, N = 3SE +/- 0.075, N = 37.7696.9426.4766.7951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS110220330440550SE +/- 0.45, N = 3SE +/- 1.99, N = 15SE +/- 15.03, N = 13SE +/- 0.90, N = 15SE +/- 7.24, N = 12915448928901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS400800120016002000SE +/- 2.73, N = 3SE +/- 30.21, N = 15SE +/- 4.15, N = 13SE +/- 56.78, N = 15SE +/- 56.42, N = 12549.82944.67103.821781.77607.791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS400800120016002000SE +/- 0.14, N = 3SE +/- 152.35, N = 12SE +/- 1.13, N = 9SE +/- 404.52, N = 9SE +/- 277.40, N = 91336715720237261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS48121620SE +/- 0.008, N = 3SE +/- 0.584, N = 12SE +/- 0.344, N = 9SE +/- 0.194, N = 9SE +/- 0.319, N = 97.5352.59217.5870.7972.2011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read WriteDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS20406080100SE +/- 0.16, N = 3SE +/- 2.15, N = 15SE +/- 0.50, N = 15SE +/- 0.81, N = 12904938591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS6001200180024003000SE +/- 2.06, N = 3SE +/- 76.50, N = 15SE +/- 36.09, N = 15SE +/- 23.22, N = 121109.972069.792672.861700.221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read WriteDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS1122334455SE +/- 3.65, N = 9SE +/- 3.51, N = 9SE +/- 0.35, N = 3SE +/- 0.86, N = 12SE +/- 3.50, N = 1227262436491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS1020304050SE +/- 4.50, N = 9SE +/- 6.06, N = 9SE +/- 0.60, N = 3SE +/- 0.69, N = 12SE +/- 1.74, N = 1242.0343.8441.5928.2721.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS2K4K6K8K10KSE +/- 43.65, N = 9SE +/- 93.78, N = 12SE +/- 0.43, N = 3SE +/- 796.92, N = 12SE +/- 1301.79, N = 12405932758264352331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS2004006008001000SE +/- 8.526, N = 9SE +/- 0.054, N = 12SE +/- 6.352, N = 3SE +/- 8.377, N = 12SE +/- 9.469, N = 12130.7455.371861.41431.99529.7531. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS918273645SE +/- 2.23, N = 7SE +/- 2.05, N = 9SE +/- 3.73, N = 7SE +/- 0.48, N = 4382915411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS20406080100SE +/- 1.63, N = 7SE +/- 2.13, N = 9SE +/- 9.24, N = 7SE +/- 0.28, N = 426.8135.2079.1624.551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS2K4K6K8K10KSE +/- 32.94, N = 12SE +/- 83.92, N = 12SE +/- 30.63, N = 3SE +/- 1272.56, N = 1245591141107735821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS50100150200250SE +/- 14.021, N = 12SE +/- 0.096, N = 12SE +/- 0.025, N = 3SE +/- 36.736, N = 12231.03410.9919.034140.5011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read WriteDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS110220330440550SE +/- 6.65, N = 9SE +/- 16.64, N = 12SE +/- 0.24, N = 3SE +/- 10.76, N = 12SE +/- 32.93, N = 9181279495133111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS2004006008001000SE +/- 10.12, N = 9SE +/- 11.34, N = 12SE +/- 4.87, N = 3SE +/- 2.31, N = 12SE +/- 22.41, N = 9278.68186.921014.6998.10178.711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read WriteDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS510152025SE +/- 1.79, N = 9SE +/- 0.29, N = 9SE +/- 0.39, N = 9SE +/- 0.51, N = 9161113211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS20406080100SE +/- 5.95, N = 9SE +/- 2.20, N = 9SE +/- 2.30, N = 9SE +/- 1.12, N = 966.2387.9676.7048.881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 50 - Mode: Read OnlyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS306090120150SE +/- 3.98, N = 9SE +/- 1.84, N = 9SE +/- 1.95, N = 9SE +/- 2.35, N = 911736127491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS30060090012001500SE +/- 13.39, N = 9SE +/- 63.21, N = 9SE +/- 6.03, N = 9SE +/- 54.31, N = 9431.581423.26394.261040.511. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read WriteDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS150300450600750SE +/- 7.73, N = 12SE +/- 5.29, N = 9SE +/- 24.87, N = 12SE +/- 37.35, N = 101871266497171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS2004006008001000SE +/- 25.45, N = 12SE +/- 36.68, N = 9SE +/- 7.36, N = 12SE +/- 8.54, N = 10545.83808.51157.27143.601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read OnlyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS306090120150SE +/- 3.14, N = 9SE +/- 2.40, N = 9SE +/- 1.47, N = 7SE +/- 2.64, N = 61244145471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS5001000150020002500SE +/- 21.21, N = 9SE +/- 160.61, N = 9SE +/- 69.13, N = 7SE +/- 131.07, N = 6814.102541.582235.742160.821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS20406080100SE +/- 2.13, N = 7SE +/- 2.28, N = 9SE +/- 1.67, N = 9SE +/- 3.61, N = 6673683321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS400800120016002000SE +/- 24.01, N = 7SE +/- 98.25, N = 9SE +/- 11.67, N = 9SE +/- 279.34, N = 6748.921423.19602.111719.511. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read WriteDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS20406080100SE +/- 1.11, N = 3SE +/- 2.26, N = 8SE +/- 4.23, N = 6SE +/- 0.34, N = 38939101431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibDB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS6001200180024003000SE +/- 13.83, N = 3SE +/- 129.76, N = 8SE +/- 43.96, N = 6SE +/- 18.18, N = 31124.852642.11996.762319.261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4