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.

pgbench-ext4-SATAProcessorMotherboardChipsetMemoryDiskOSKernelCompilerFile-SystemDB performance by FS: SATA variable rpm HD with ext4DB performance by FS: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlibARMv8 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: Btrfs on 7200rpm SAS drive, DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4, DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib: --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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib52860.1949210.834139133.598128837.76991549.8161337.535901109.9732742.033405130.7453826.808455231.034181278.6761666.228117431.577187545.827124814.10367748.923891124.84740540.2473132.875158313.161154536.476281781.76720230.797382672.8643628.272264331.9951579.164110779.03451398.1011376.699127394.256649157.272452235.74283602.106101996.75956220.1832405.582151473.304489103.8175717.5872441.58758861.414491014.69252230.2006914.745147903.383147316.79590607.7857262.201591700.2244921.556523329.7534124.5463582140.501311178.7092148.883491040.514717143.598472160.822321719.510432319.26340000.2575917.144149823.340144286.94254944.6706712.592492069.7932643.84093275.3712935.198911410.991279186.9171187.963361423.262126808.508412541.577361423.188392642.108OpenBenchmarking.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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib12002400360048006000SE +/- 272.89, N = 12SE +/- 17.82, N = 3SE +/- 264.65, N = 15SE +/- 310.66, N = 12SE +/- 216.12, N = 12528640545622522340001. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib0.05780.11560.17340.23120.289SE +/- 0.009, N = 12SE +/- 0.001, N = 3SE +/- 0.008, N = 15SE +/- 0.013, N = 12SE +/- 0.012, N = 120.1940.2470.1830.2000.2571. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib50100150200250SE +/- 0.25, N = 3SE +/- 1.09, N = 15SE +/- 27.89, N = 12SE +/- 2.26, N = 15SE +/- 2.27, N = 15923124069591. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib816243240SE +/- 0.030, N = 3SE +/- 1.105, N = 15SE +/- 1.124, N = 12SE +/- 0.490, N = 15SE +/- 0.627, N = 1510.83432.8755.58214.74517.1441. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib3K6K9K12K15KSE +/- 125.25, N = 7SE +/- 144.82, N = 3SE +/- 83.84, N = 3SE +/- 116.66, N = 3SE +/- 70.45, N = 313913158311514714790149821. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib0.80961.61922.42883.23844.048SE +/- 0.033, N = 7SE +/- 0.029, N = 3SE +/- 0.018, N = 3SE +/- 0.027, N = 3SE +/- 0.016, N = 33.5983.1613.3043.3833.3401. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib3K6K9K12K15KSE +/- 85.70, N = 3SE +/- 144.24, N = 3SE +/- 164.46, N = 3SE +/- 114.79, N = 15128831545314731144281. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib246810SE +/- 0.051, N = 3SE +/- 0.061, N = 3SE +/- 0.075, N = 3SE +/- 0.054, N = 157.7696.4766.7956.9421. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib110220330440550SE +/- 0.45, N = 3SE +/- 0.90, N = 15SE +/- 15.03, N = 13SE +/- 7.24, N = 12SE +/- 1.99, N = 15912848990541. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib400800120016002000SE +/- 2.73, N = 3SE +/- 56.78, N = 15SE +/- 4.15, N = 13SE +/- 56.42, N = 12SE +/- 30.21, N = 15549.821781.77103.82607.79944.671. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib400800120016002000SE +/- 0.14, N = 3SE +/- 404.52, N = 9SE +/- 1.13, N = 9SE +/- 277.40, N = 9SE +/- 152.35, N = 121332023577266711. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib48121620SE +/- 0.008, N = 3SE +/- 0.194, N = 9SE +/- 0.344, N = 9SE +/- 0.319, N = 9SE +/- 0.584, N = 127.5350.79717.5872.2012.5921. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib20406080100SE +/- 0.16, N = 3SE +/- 0.50, N = 15SE +/- 0.81, N = 12SE +/- 2.15, N = 15903859491. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib6001200180024003000SE +/- 2.06, N = 3SE +/- 36.09, N = 15SE +/- 23.22, N = 12SE +/- 76.50, N = 151109.972672.861700.222069.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 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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib1122334455SE +/- 3.65, N = 9SE +/- 0.86, N = 12SE +/- 0.35, N = 3SE +/- 3.50, N = 12SE +/- 3.51, N = 927362449261. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib1020304050SE +/- 4.50, N = 9SE +/- 0.69, N = 12SE +/- 0.60, N = 3SE +/- 1.74, N = 12SE +/- 6.06, N = 942.0328.2741.5921.5643.841. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib2K4K6K8K10KSE +/- 43.65, N = 9SE +/- 796.92, N = 12SE +/- 0.43, N = 3SE +/- 1301.79, N = 12SE +/- 93.78, N = 12405264358523393271. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib2004006008001000SE +/- 8.526, N = 9SE +/- 8.377, N = 12SE +/- 6.352, N = 3SE +/- 9.469, N = 12SE +/- 0.054, N = 12130.74531.995861.41429.7535.3711. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib918273645SE +/- 2.23, N = 7SE +/- 3.73, N = 7SE +/- 0.48, N = 4SE +/- 2.05, N = 9381541291. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib20406080100SE +/- 1.63, N = 7SE +/- 9.24, N = 7SE +/- 0.28, N = 4SE +/- 2.13, N = 926.8179.1624.5535.201. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib2K4K6K8K10KSE +/- 32.94, N = 12SE +/- 30.63, N = 3SE +/- 1272.56, N = 12SE +/- 83.92, N = 1245511077358291141. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib50100150200250SE +/- 14.021, N = 12SE +/- 0.025, N = 3SE +/- 36.736, N = 12SE +/- 0.096, N = 12231.0349.034140.50110.9911. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib110220330440550SE +/- 6.65, N = 9SE +/- 10.76, N = 12SE +/- 0.24, N = 3SE +/- 32.93, N = 9SE +/- 16.64, N = 12181513493112791. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib2004006008001000SE +/- 10.12, N = 9SE +/- 2.31, N = 12SE +/- 4.87, N = 3SE +/- 22.41, N = 9SE +/- 11.34, N = 12278.6898.101014.69178.71186.921. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib510152025SE +/- 1.79, N = 9SE +/- 0.39, N = 9SE +/- 0.51, N = 9SE +/- 0.29, N = 9161321111. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib20406080100SE +/- 5.95, N = 9SE +/- 2.30, N = 9SE +/- 1.12, N = 9SE +/- 2.20, N = 966.2376.7048.8887.961. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib306090120150SE +/- 3.98, N = 9SE +/- 1.95, N = 9SE +/- 2.35, N = 9SE +/- 1.84, N = 911712749361. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib30060090012001500SE +/- 13.39, N = 9SE +/- 6.03, N = 9SE +/- 54.31, N = 9SE +/- 63.21, N = 9431.58394.261040.511423.261. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib150300450600750SE +/- 7.73, N = 12SE +/- 24.87, N = 12SE +/- 37.35, N = 10SE +/- 5.29, N = 91876497171261. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib2004006008001000SE +/- 25.45, N = 12SE +/- 7.36, N = 12SE +/- 8.54, N = 10SE +/- 36.68, N = 9545.83157.27143.60808.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 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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib306090120150SE +/- 3.14, N = 9SE +/- 1.47, N = 7SE +/- 2.64, N = 6SE +/- 2.40, N = 91244547411. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib5001000150020002500SE +/- 21.21, N = 9SE +/- 69.13, N = 7SE +/- 131.07, N = 6SE +/- 160.61, N = 9814.102235.742160.822541.581. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib20406080100SE +/- 2.13, N = 7SE +/- 1.67, N = 9SE +/- 3.61, N = 6SE +/- 2.28, N = 9678332361. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib400800120016002000SE +/- 24.01, N = 7SE +/- 11.67, N = 9SE +/- 279.34, N = 6SE +/- 98.25, N = 9748.92602.111719.511423.191. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib20406080100SE +/- 1.11, N = 3SE +/- 4.23, N = 6SE +/- 0.34, N = 3SE +/- 2.26, N = 88910143391. (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: Btrfs on 7200rpm SAS driveDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib6001200180024003000SE +/- 13.83, N = 3SE +/- 43.96, N = 6SE +/- 18.18, N = 3SE +/- 129.76, N = 81124.85996.762319.262642.111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4