Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2107047-IB-MERGE136101
{
"title": "pgbench-ext4-SATA",
"last_modified": "2021-07-03 22:58:31",
"description": "DB performance testing by FS: SATA attached variable rpm HD with ext4",
"systems": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"identifier": "DB performance by FS: SATA variable rpm HD with ext4",
"hardware": {
"Processor": "ARMv8 Cortex-A72 @ 1.42GHz (6 Cores)",
"Motherboard": "Pine64 RockPro64 v2.1",
"Chipset": "Fuzhou Rockchip RK3399",
"Memory": "4096MB",
"Disk": "4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G"
},
"software": {
"OS": "Gentoo\/Linux",
"Kernel": "5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64)",
"Compiler": "GCC 11.1.0",
"File-System": "ext4"
},
"user": "galiven",
"timestamp": "2021-06-23 23:46:24",
"data": {
"compiler-configuration": "--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",
"cpu-scaling-governor": "cpufreq-dt schedutil",
"security": "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"
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"identifier": "DB performance by FS: Btrfs on 7200rpm SAS drive",
"hardware": {
"Processor": "ARMv8 Cortex-A72 @ 1.42GHz (6 Cores)",
"Motherboard": "Pine64 RockPro64 v2.1",
"Chipset": "Fuzhou Rockchip RK3399",
"Memory": "4096MB",
"Disk": "4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G"
},
"software": {
"OS": "Gentoo\/Linux",
"Kernel": "5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64)",
"Compiler": "GCC 11.1.0",
"File-System": "btrfs"
},
"user": "root",
"timestamp": "2021-06-29 00:59:30",
"data": {
"compiler-configuration": "--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",
"cpu-scaling-governor": "cpufreq-dt schedutil",
"security": "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"
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"identifier": "DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4",
"hardware": {
"Processor": "ARMv8 Cortex-A72 @ 1.42GHz (6 Cores)",
"Motherboard": "Pine64 RockPro64 v2.1",
"Chipset": "Fuzhou Rockchip RK3399",
"Memory": "4096MB",
"Disk": "4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G"
},
"software": {
"OS": "Gentoo\/Linux",
"Kernel": "5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64)",
"Compiler": "GCC 11.1.0",
"File-System": "ext4"
},
"user": "root",
"timestamp": "2021-06-26 11:02:37",
"data": {
"compiler-configuration": "--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",
"cpu-scaling-governor": "cpufreq-dt schedutil",
"security": "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"
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"identifier": "DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",
"hardware": {
"Processor": "ARMv8 Cortex-A72 @ 1.42GHz (6 Cores)",
"Motherboard": "Pine64 RockPro64 v2.1",
"Chipset": "Fuzhou Rockchip RK3399",
"Memory": "4096MB",
"Disk": "4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G"
},
"software": {
"OS": "Gentoo\/Linux",
"Kernel": "5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64)",
"Compiler": "GCC 11.1.0",
"File-System": "btrfs"
},
"user": "root",
"timestamp": "2021-07-02 00:32:18",
"data": {
"cpu-scaling-governor": "cpufreq-dt schedutil",
"security": "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"
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"identifier": "USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib",
"hardware": {
"Processor": "ARMv8 Cortex-A72 @ 1.42GHz (6 Cores)",
"Motherboard": "Pine64 RockPro64 v2.1",
"Chipset": "Fuzhou Rockchip RK3399",
"Memory": "4096MB",
"Disk": "4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G"
},
"software": {
"OS": "Gentoo\/Linux",
"Kernel": "5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64)",
"Compiler": "GCC 11.1.0",
"File-System": "btrfs"
},
"user": "galiven",
"timestamp": "2021-06-24 16:58:26",
"data": {
"compiler-configuration": "--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",
"cpu-scaling-governor": "cpufreq-dt schedutil",
"security": "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"
}
}
},
"results": {
"9a62c9a652f0d042bb1f42c242fa4e4b311a3087": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 100 -S",
"description": "Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 7.7690000000000001278976924368180334568023681640625,
"raw_values": [
7.6669999999999998152588887023739516735076904296875,
7.8239999999999998436805981327779591083526611328125,
7.81599999999999983657517077517695724964141845703125
],
"test_run_times": [
28.35000000000000142108547152020037174224853515625,
28.370000000000000994759830064140260219573974609375,
28.589999999999999857891452847979962825775146484375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 6.47599999999999997868371792719699442386627197265625,
"raw_values": [
6.45399999999999973709918776876293122768402099609375,
6.3840000000000003410605131648480892181396484375,
6.59100000000000019184653865522705018520355224609375
],
"test_run_times": [
33.71000000000000085265128291212022304534912109375,
34.0799999999999982946974341757595539093017578125,
33.61999999999999744204615126363933086395263671875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 6.7949999999999999289457264239899814128875732421875,
"raw_values": [
6.90599999999999969446662362315692007541656494140625,
6.650999999999999801048033987171947956085205078125,
6.8269999999999999573674358543939888477325439453125
],
"test_run_times": [
28.199999999999999289457264239899814128875732421875,
28.410000000000000142108547152020037174224853515625,
28.480000000000000426325641456060111522674560546875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 6.94200000000000017053025658242404460906982421875,
"raw_values": [
7.10799999999999965183405947755090892314910888671875,
7.160000000000000142108547152020037174224853515625,
6.71600000000000019184653865522705018520355224609375,
6.5890000000000004121147867408581078052520751953125,
7.0129999999999999005240169935859739780426025390625,
6.92400000000000037658764995285309851169586181640625,
7.0540000000000002700062395888380706310272216796875,
6.897999999999999687361196265555918216705322265625,
6.54000000000000003552713678800500929355621337890625,
6.7430000000000003268496584496460855007171630859375,
6.98299999999999965183405947755090892314910888671875,
7.08100000000000040500935938325710594654083251953125,
7.275999999999999801048033987171947956085205078125,
7,
7.04399999999999959499064061674289405345916748046875
],
"test_run_times": [
31.019999999999999573674358543939888477325439453125,
30.8599999999999994315658113919198513031005859375,
30.17999999999999971578290569595992565155029296875,
30.3599999999999994315658113919198513031005859375,
30.489999999999998436805981327779591083526611328125,
30.53999999999999914734871708787977695465087890625,
31.870000000000000994759830064140260219573974609375,
30.75,
30.190000000000001278976924368180334568023681640625,
30.489999999999998436805981327779591083526611328125,
31.17999999999999971578290569595992565155029296875,
30.5799999999999982946974341757595539093017578125,
30.300000000000000710542735760100185871124267578125,
30.71000000000000085265128291212022304534912109375,
30.629999999999999005240169935859739780426025390625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"59cb07e52686ddf9f9cdd273795a854b0c8a2918": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 100 -S",
"description": "Scaling Factor: 1 - Clients: 100 - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 12883,
"raw_values": [
13053.813088000000789179466664791107177734375,
12789.598238000000492320396006107330322265625,
12804.47466999999960535205900669097900390625
],
"test_run_times": [
28.35000000000000142108547152020037174224853515625,
28.370000000000000994759830064140260219573974609375,
28.589999999999999857891452847979962825775146484375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 15453,
"raw_values": [
15503.627464999999574501998722553253173828125,
15674.2645929999998770654201507568359375,
15182.25041799999962677247822284698486328125
],
"test_run_times": [
33.71000000000000085265128291212022304534912109375,
34.0799999999999982946974341757595539093017578125,
33.61999999999999744204615126363933086395263671875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 14731,
"raw_values": [
14489.98593299999993178062140941619873046875,
15045.500120999999126070179045200347900390625,
14658.3252880000000004656612873077392578125
],
"test_run_times": [
28.199999999999999289457264239899814128875732421875,
28.410000000000000142108547152020037174224853515625,
28.480000000000000426325641456060111522674560546875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 14428,
"raw_values": [
14078.798673999999664374627172946929931640625,
13976.91694500000085099600255489349365234375,
14900.212503000000651809386909008026123046875,
15186.880794999999125138856470584869384765625,
14269.5081669999999576248228549957275390625,
14451.709276999999929103069007396697998046875,
14185.787092000000484404154121875762939453125,
14507.122070999999777995981276035308837890625,
15301.60267799999928683973848819732666015625,
14840.10584100000050966627895832061767578125,
14331.15445499999987077899277210235595703125,
14131.594796999999744002707302570343017578125,
13752.88981699999931151978671550750732421875,
14296.54286700000011478550732135772705078125,
14206.9620890000005601905286312103271484375
],
"test_run_times": [
31.019999999999999573674358543939888477325439453125,
30.8599999999999994315658113919198513031005859375,
30.17999999999999971578290569595992565155029296875,
30.3599999999999994315658113919198513031005859375,
30.489999999999998436805981327779591083526611328125,
30.53999999999999914734871708787977695465087890625,
31.870000000000000994759830064140260219573974609375,
30.75,
30.190000000000001278976924368180334568023681640625,
30.489999999999998436805981327779591083526611328125,
31.17999999999999971578290569595992565155029296875,
30.5799999999999982946974341757595539093017578125,
30.300000000000000710542735760100185871124267578125,
30.71000000000000085265128291212022304534912109375,
30.629999999999999005240169935859739780426025390625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"4b65a60060ec80b46829a5f7e51925580a59c8c2": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 50 -S",
"description": "Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 3.59799999999999986499688020558096468448638916015625,
"raw_values": [
3.4870000000000000994759830064140260219573974609375,
3.54000000000000003552713678800500929355621337890625,
3.745999999999999996447286321199499070644378662109375,
3.587000000000000188293824976426549255847930908203125,
3.54300000000000014921397450962103903293609619140625,
3.63300000000000000710542735760100185871124267578125,
3.650999999999999801048033987171947956085205078125
],
"test_run_times": [
28.510000000000001563194018672220408916473388671875,
28.440000000000001278976924368180334568023681640625,
28.280000000000001136868377216160297393798828125,
28.260000000000001563194018672220408916473388671875,
28.370000000000000994759830064140260219573974609375,
28.14999999999999857891452847979962825775146484375,
28.21000000000000085265128291212022304534912109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 3.161000000000000031974423109204508364200592041015625,
"raw_values": [
3.20699999999999985078602549037896096706390380859375,
3.16800000000000014921397450962103903293609619140625,
3.108000000000000095923269327613525092601776123046875
],
"test_run_times": [
32.659999999999996589394868351519107818603515625,
32.3299999999999982946974341757595539093017578125,
33.1099999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 3.303999999999999825917029738775454461574554443359375,
"raw_values": [
3.335999999999999854338739169179461896419525146484375,
3.273000000000000131450406115618534386157989501953125,
3.302000000000000046185277824406512081623077392578125
],
"test_run_times": [
27.17999999999999971578290569595992565155029296875,
26.769999999999999573674358543939888477325439453125,
26.64999999999999857891452847979962825775146484375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 3.38300000000000000710542735760100185871124267578125,
"raw_values": [
3.369000000000000216715534406830556690692901611328125,
3.435000000000000053290705182007513940334320068359375,
3.346000000000000085265128291212022304534912109375
],
"test_run_times": [
27.870000000000000994759830064140260219573974609375,
28.260000000000001563194018672220408916473388671875,
28.03999999999999914734871708787977695465087890625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 3.339999999999999857891452847979962825775146484375,
"raw_values": [
3.30900000000000016342482922482304275035858154296875,
3.35099999999999997868371792719699442386627197265625,
3.3589999999999999857891452847979962825775146484375
],
"test_run_times": [
31.030000000000001136868377216160297393798828125,
30.219999999999998863131622783839702606201171875,
30.589999999999999857891452847979962825775146484375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"089623dc74b9ba357d1c22927a1771c6688bc7c2": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 50 -S",
"description": "Scaling Factor: 1 - Clients: 50 - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 13913,
"raw_values": [
14350.177728000000570318661630153656005859375,
14138.377510000000256695784628391265869140625,
13357.269723999999769148416817188262939453125,
13947.15514099999927566386759281158447265625,
14122.04588499999954365193843841552734375,
13771.053255999999237246811389923095703125,
13705.277149999999892315827310085296630859375
],
"test_run_times": [
28.510000000000001563194018672220408916473388671875,
28.440000000000001278976924368180334568023681640625,
28.280000000000001136868377216160297393798828125,
28.260000000000001563194018672220408916473388671875,
28.370000000000000994759830064140260219573974609375,
28.14999999999999857891452847979962825775146484375,
28.21000000000000085265128291212022304534912109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 15831,
"raw_values": [
15601.5286269999996875412762165069580078125,
15791.549801999999544932506978511810302734375,
16098.6421919999993406236171722412109375
],
"test_run_times": [
32.659999999999996589394868351519107818603515625,
32.3299999999999982946974341757595539093017578125,
33.1099999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 15147,
"raw_values": [
14998.07006399999954737722873687744140625,
15288.1701119999997899867594242095947265625,
15154.97453999999925144948065280914306640625
],
"test_run_times": [
27.17999999999999971578290569595992565155029296875,
26.769999999999999573674358543939888477325439453125,
26.64999999999999857891452847979962825775146484375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 14790,
"raw_values": [
14851.467909000000872765667736530303955078125,
14564.871610000000146101228892803192138671875,
14954.90834800000084214843809604644775390625
],
"test_run_times": [
27.870000000000000994759830064140260219573974609375,
28.260000000000001563194018672220408916473388671875,
28.03999999999999914734871708787977695465087890625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 14982,
"raw_values": [
15121.308130999999775667674839496612548828125,
14929.175177999999505118466913700103759765625,
14894.93735100000048987567424774169921875
],
"test_run_times": [
31.030000000000001136868377216160297393798828125,
30.219999999999998863131622783839702606201171875,
30.589999999999999857891452847979962825775146484375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"7ef3e4d3e59adb9415db4c7c2af2b6423edcb9b9": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 100",
"description": "Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 1124.846999999999979991116560995578765869140625,
"raw_values": [
1141.763999999999896317603997886180877685546875,
1097.442999999999983629095368087291717529296875,
1135.334000000000060026650317013263702392578125
],
"test_run_times": [
1118.359999999999899955582804977893829345703125,
1114.299999999999954525264911353588104248046875,
1139.55999999999994543031789362430572509765625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 996.759000000000014551915228366851806640625,
"raw_values": [
909.93499999999994543031789362430572509765625,
891.87300000000004729372449219226837158203125,
954.1779999999999972715158946812152862548828125,
1166.412000000000034560798667371273040771484375,
1087.15000000000009094947017729282379150390625,
971.0030000000000427462509833276271820068359375
],
"test_run_times": [
1718.26999999999998181010596454143524169921875,
1857.829999999999927240423858165740966796875,
1165.839999999999918145476840436458587646484375,
1398.48000000000001818989403545856475830078125,
1846.680000000000063664629124104976654052734375,
1756.529999999999972715158946812152862548828125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 2319.2629999999999199644662439823150634765625,
"raw_values": [
2297.75300000000015643308870494365692138671875,
2304.6300000000001091393642127513885498046875,
2355.4070000000001527951098978519439697265625
],
"test_run_times": [
1169.470000000000027284841053187847137451171875,
1098.180000000000063664629124104976654052734375,
1058.660000000000081854523159563541412353515625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 2642.1080000000001746229827404022216796875,
"raw_values": [
2474.46599999999989449861459434032440185546875,
2962.1379999999999199644662439823150634765625,
2684.07900000000017826096154749393463134765625,
2512.9769999999998617568053305149078369140625,
2901.9499999999998181010596454143524169921875,
3044.07299999999986539478413760662078857421875,
2666.21599999999989449861459434032440185546875,
1890.962999999999965439201332628726959228515625
],
"test_run_times": [
1201.140000000000100044417195022106170654296875,
1215.80999999999994543031789362430572509765625,
1222.930000000000063664629124104976654052734375,
1163.76999999999998181010596454143524169921875,
1265.5,
1199.7100000000000363797880709171295166015625,
1223.339999999999918145476840436458587646484375,
1176.920000000000072759576141834259033203125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"bc04080bf274cee3b4a897df30e0f77eb0742cc2": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 100",
"description": "Scaling Factor: 1000 - Clients: 100 - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 89,
"raw_values": [
87.63663800000000492218532599508762359619140625,
91.1793449999999978672349243424832820892333984375,
88.133523999999994202880770899355411529541015625
],
"test_run_times": [
1118.359999999999899955582804977893829345703125,
1114.299999999999954525264911353588104248046875,
1139.55999999999994543031789362430572509765625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 101,
"raw_values": [
109.96607299999999440842657350003719329833984375,
112.1950350000000042882675188593566417694091796875,
104.8702219999999982746885507367551326751708984375,
85.7922980000000023892425815574824810028076171875,
92.0509579999999942856447887606918811798095703125,
103.052313999999995530743035487830638885498046875
],
"test_run_times": [
1718.26999999999998181010596454143524169921875,
1857.829999999999927240423858165740966796875,
1165.839999999999918145476840436458587646484375,
1398.48000000000001818989403545856475830078125,
1846.680000000000063664629124104976654052734375,
1756.529999999999972715158946812152862548828125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 43,
"raw_values": [
43.5497840000000024929249775595963001251220703125,
43.42106199999999915917214821092784404754638671875,
42.4839640000000002828528522513806819915771484375
],
"test_run_times": [
1169.470000000000027284841053187847137451171875,
1098.180000000000063664629124104976654052734375,
1058.660000000000081854523159563541412353515625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 39,
"raw_values": [
40.4374540000000024519977159798145294189453125,
33.77932899999999705187292420305311679840087890625,
37.280495000000001937223714776337146759033203125,
39.81887199999999893407220952212810516357421875,
34.48129300000000085901774582453072071075439453125,
32.87218899999999877081791055388748645782470703125,
37.53105699999999700366970500908792018890380859375,
52.9191900000000003956301952712237834930419921875
],
"test_run_times": [
1201.140000000000100044417195022106170654296875,
1215.80999999999994543031789362430572509765625,
1222.930000000000063664629124104976654052734375,
1163.76999999999998181010596454143524169921875,
1265.5,
1199.7100000000000363797880709171295166015625,
1223.339999999999918145476840436458587646484375,
1176.920000000000072759576141834259033203125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"881f535973f7200ecc51d46c1ed39fb2e161f5ad": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 50",
"description": "Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 748.923000000000001818989403545856475830078125,
"raw_values": [
754.511999999999943611328490078449249267578125,
813.326999999999998181010596454143524169921875,
740.3999999999999772626324556767940521240234375,
687.5539999999999736246536485850811004638671875,
734.017000000000052750692702829837799072265625,
667.2630000000000336513039655983448028564453125,
845.3880000000000336513039655983448028564453125
],
"test_run_times": [
1369.26999999999998181010596454143524169921875,
1073.509999999999990905052982270717620849609375,
1088.40000000000009094947017729282379150390625,
1099.589999999999918145476840436458587646484375,
1100.2899999999999636202119290828704833984375,
1089.90000000000009094947017729282379150390625,
1135.829999999999927240423858165740966796875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 602.105999999999994543031789362430572509765625,
"raw_values": [
586.4089999999999918145476840436458587646484375,
640.5720000000000027284841053187847137451171875,
624.1209999999999809006112627685070037841796875,
613.816000000000030922819860279560089111328125,
613.933999999999969077180139720439910888671875,
598.0579999999999927240423858165740966796875,
541.44000000000005456968210637569427490234375,
557.8300000000000409272615797817707061767578125,
642.770999999999958163243718445301055908203125
],
"test_run_times": [
1209.6300000000001091393642127513885498046875,
1670.51999999999998181010596454143524169921875,
2090.09000000000014551915228366851806640625,
1634,
1601.84999999999990905052982270717620849609375,
2348.01999999999998181010596454143524169921875,
1556.529999999999972715158946812152862548828125,
1269.51999999999998181010596454143524169921875,
1798.029999999999972715158946812152862548828125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 1719.509999999999990905052982270717620849609375,
"raw_values": [
1376.3530000000000654836185276508331298828125,
1548.9600000000000363797880709171295166015625,
1263.20299999999997453414835035800933837890625,
3051.0360000000000582076609134674072265625,
1810.4510000000000218278728425502777099609375,
1267.055000000000063664629124104976654052734375
],
"test_run_times": [
1687.69000000000005456968210637569427490234375,
1718.319999999999936335370875895023345947265625,
1614.3800000000001091393642127513885498046875,
1638.339999999999918145476840436458587646484375,
1537.140000000000100044417195022106170654296875,
1610.160000000000081854523159563541412353515625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 1423.188000000000101863406598567962646484375,
"raw_values": [
1080.785000000000081854523159563541412353515625,
1318.207000000000107320374809205532073974609375,
1612.31500000000005456968210637569427490234375,
1381.509000000000014551915228366851806640625,
1425.28400000000010550138540565967559814453125,
1548.865999999999985448084771633148193359375,
1112.950000000000045474735088646411895751953125,
1276.5670000000000072759576141834259033203125,
2052.20800000000008367351256310939788818359375
],
"test_run_times": [
1125.25,
1226.9600000000000363797880709171295166015625,
1255.1199999999998908606357872486114501953125,
1241.34999999999990905052982270717620849609375,
1191.009999999999990905052982270717620849609375,
1285.160000000000081854523159563541412353515625,
1214.75,
1191.7899999999999636202119290828704833984375,
1213.3699999999998908606357872486114501953125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"bd2ab262ee3c09e73cb92ae9021df4abade289b2": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 50",
"description": "Scaling Factor: 1000 - Clients: 50 - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 67,
"raw_values": [
66.3094549999999998135535861365497112274169921875,
61.52694100000000076988726505078375339508056640625,
67.5756789999999938345354166813194751739501953125,
72.7771039999999942438080324791371822357177734375,
68.1651169999999950732672004960477352142333984375,
74.979590000000001737134880386292934417724609375,
59.1952160000000020545485313050448894500732421875
],
"test_run_times": [
1369.26999999999998181010596454143524169921875,
1073.509999999999990905052982270717620849609375,
1088.40000000000009094947017729282379150390625,
1099.589999999999918145476840436458587646484375,
1100.2899999999999636202119290828704833984375,
1089.90000000000009094947017729282379150390625,
1135.829999999999927240423858165740966796875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 83,
"raw_values": [
85.3201080000000047220964916050434112548828125,
78.106729000000001406078808940947055816650390625,
80.1653450000000020736479200422763824462890625,
81.510219000000006417394615709781646728515625,
81.4939509999999955880412016995251178741455078125,
83.6579980000000063000697991810739040374755859375,
92.40636399999999639476300217211246490478515625,
89.6896090000000043573891161940991878509521484375,
77.8398830000000003792592906393110752105712890625
],
"test_run_times": [
1209.6300000000001091393642127513885498046875,
1670.51999999999998181010596454143524169921875,
2090.09000000000014551915228366851806640625,
1634,
1601.84999999999990905052982270717620849609375,
2348.01999999999998181010596454143524169921875,
1556.529999999999972715158946812152862548828125,
1269.51999999999998181010596454143524169921875,
1798.029999999999972715158946812152862548828125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 32,
"raw_values": [
36.3788890000000009194991434924304485321044921875,
32.32341600000000170211933436803519725799560546875,
39.646895999999998139173840172588825225830078125,
16.5631139999999987821865943260490894317626953125,
27.6842180000000013251337804831564426422119140625,
39.5030900000000002592059900052845478057861328125
],
"test_run_times": [
1687.69000000000005456968210637569427490234375,
1718.319999999999936335370875895023345947265625,
1614.3800000000001091393642127513885498046875,
1638.339999999999918145476840436458587646484375,
1537.140000000000100044417195022106170654296875,
1610.160000000000081854523159563541412353515625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 36,
"raw_values": [
46.29098400000000168574842973612248897552490234375,
37.95562199999999819510776433162391185760498046875,
31.0316499999999990677679306827485561370849609375,
36.21897799999999989495336194522678852081298828125,
35.105086000000000012732925824820995330810546875,
32.3034779999999983601810527034103870391845703125,
44.956017000000002781234798021614551544189453125,
39.1934499999999985675458447076380252838134765625,
24.380151999999998935209077899344265460968017578125
],
"test_run_times": [
1125.25,
1226.9600000000000363797880709171295166015625,
1255.1199999999998908606357872486114501953125,
1241.34999999999990905052982270717620849609375,
1191.009999999999990905052982270717620849609375,
1285.160000000000081854523159563541412353515625,
1214.75,
1191.7899999999999636202119290828704833984375,
1213.3699999999998908606357872486114501953125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"37fcc20d101aeeeb2ee942e479d40c57fadfd0b0": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 100 -S",
"description": "Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 814.1029999999999517967808060348033905029296875,
"raw_values": [
768.5890000000000554791768081486225128173828125,
785.442999999999983629095368087291717529296875,
885.01099999999996725819073617458343505859375,
828.51999999999998181010596454143524169921875,
742.392000000000052750692702829837799072265625,
920.64300000000002910383045673370361328125,
792.076999999999998181010596454143524169921875,
742.92200000000002546585164964199066162109375,
861.3300000000000409272615797817707061767578125
],
"test_run_times": [
996.549999999999954525264911353588104248046875,
1002.01999999999998181010596454143524169921875,
1103.470000000000027284841053187847137451171875,
1175.98000000000001818989403545856475830078125,
1036.339999999999918145476840436458587646484375,
1047.470000000000027284841053187847137451171875,
1089.450000000000045474735088646411895751953125,
1047.8800000000001091393642127513885498046875,
1068
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 2235.742000000000189174897968769073486328125,
"raw_values": [
2207.28699999999980718712322413921356201171875,
2249.25599999999985811882652342319488525390625,
2387.94500000000016370904631912708282470703125,
2080.4059999999999490682967007160186767578125,
2387.436999999999898136593401432037353515625,
2414.3580000000001746229827404022216796875,
1923.50700000000006184563972055912017822265625
],
"test_run_times": [
1644.6199999999998908606357872486114501953125,
1865.51999999999998181010596454143524169921875,
1882.410000000000081854523159563541412353515625,
1563.609999999999899955582804977893829345703125,
1585.089999999999918145476840436458587646484375,
1903.05999999999994543031789362430572509765625,
1579.84999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 2160.822000000000116415321826934814453125,
"raw_values": [
2032.7010000000000218278728425502777099609375,
1913.5850000000000363797880709171295166015625,
2009.8350000000000363797880709171295166015625,
1877.457000000000107320374809205532073974609375,
2506.7010000000000218278728425502777099609375,
2624.650999999999839928932487964630126953125
],
"test_run_times": [
1165.51999999999998181010596454143524169921875,
1147.640000000000100044417195022106170654296875,
1141.2899999999999636202119290828704833984375,
1085.759999999999990905052982270717620849609375,
1408.569999999999936335370875895023345947265625,
1662.509999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 2541.5770000000002255546860396862030029296875,
"raw_values": [
2886.489999999999781721271574497222900390625,
2875.7820000000001527951098978519439697265625,
2121.19500000000016370904631912708282470703125,
2480.92599999999993087840266525745391845703125,
3487.5770000000002255546860396862030029296875,
2218.79300000000012005330063402652740478515625,
2597.04599999999982173903845250606536865234375,
1930.281999999999925421434454619884490966796875,
2276.10600000000022191670723259449005126953125
],
"test_run_times": [
2527.57000000000016370904631912708282470703125,
2586.09000000000014551915228366851806640625,
2515.7100000000000363797880709171295166015625,
2778.19000000000005456968210637569427490234375,
2837.84000000000014551915228366851806640625,
2420.09000000000014551915228366851806640625,
1209.680000000000063664629124104976654052734375,
1199.990000000000009094947017729282379150390625,
1187.34999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"c86ab3fd6558e9c955c75095bd560beb94bbc04c": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 100 -S",
"description": "Scaling Factor: 1000 - Clients: 100 - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 124,
"raw_values": [
130.201150000000012596501619555056095123291015625,
127.410528999999996813130564987659454345703125,
113.069985000000002628439688123762607574462890625,
120.775948999999997113263816572725772857666015625,
134.79032499999999572537490166723728179931640625,
108.6996620000000035588527680374681949615478515625,
126.3500709999999997990016709081828594207763671875,
134.696362999999990961441653780639171600341796875,
116.1857439999999996871338225901126861572265625
],
"test_run_times": [
996.549999999999954525264911353588104248046875,
1002.01999999999998181010596454143524169921875,
1103.470000000000027284841053187847137451171875,
1175.98000000000001818989403545856475830078125,
1036.339999999999918145476840436458587646484375,
1047.470000000000027284841053187847137451171875,
1089.450000000000045474735088646411895751953125,
1047.8800000000001091393642127513885498046875,
1068
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 45,
"raw_values": [
45.3321940000000012105374480597674846649169921875,
44.48547800000000052023096941411495208740234375,
41.9034869999999983747329679317772388458251953125,
48.096631999999999607098288834095001220703125,
41.91075500000000175759851117618381977081298828125,
41.4431730000000015934347175061702728271484375,
52.02036700000000024601831682957708835601806640625
],
"test_run_times": [
1644.6199999999998908606357872486114501953125,
1865.51999999999998181010596454143524169921875,
1882.410000000000081854523159563541412353515625,
1563.609999999999899955582804977893829345703125,
1585.089999999999918145476840436458587646484375,
1903.05999999999994543031789362430572509765625,
1579.84999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 47,
"raw_values": [
49.2256339999999994461177266202867031097412109375,
52.29140300000000252111931331455707550048828125,
49.79183100000000194995664060115814208984375,
53.3301450000000016871126717887818813323974609375,
39.94268100000000032423486118204891681671142578125,
38.145173999999997249688021838665008544921875
],
"test_run_times": [
1165.51999999999998181010596454143524169921875,
1147.640000000000100044417195022106170654296875,
1141.2899999999999636202119290828704833984375,
1085.759999999999990905052982270717620849609375,
1408.569999999999936335370875895023345947265625,
1662.509999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 41,
"raw_values": [
34.66653900000000021464074961841106414794921875,
34.79744099999999917827153694815933704376220703125,
47.1754040000000003374225343577563762664794921875,
40.33563199999999682177076465450227260589599609375,
28.691751000000000004774847184307873249053955078125,
45.09753599999999806868800078518688678741455078125,
38.5291739999999975907485350035130977630615234375,
51.83905399999999730198396719060838222503662109375,
43.961714000000000623913365416228771209716796875
],
"test_run_times": [
2527.57000000000016370904631912708282470703125,
2586.09000000000014551915228366851806640625,
2515.7100000000000363797880709171295166015625,
2778.19000000000005456968210637569427490234375,
2837.84000000000014551915228366851806640625,
2420.09000000000014551915228366851806640625,
1209.680000000000063664629124104976654052734375,
1199.990000000000009094947017729282379150390625,
1187.34999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"5e93a7c68fa60d465394ea61383c80e0c8418436": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 100",
"description": "Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 545.826999999999998181010596454143524169921875,
"raw_values": [
697.5829999999999699866748414933681488037109375,
685.787000000000034560798667371273040771484375,
521.058999999999969077180139720439910888671875,
478.653000000000020008883439004421234130859375,
554.3120000000000118234311230480670928955078125,
476.144000000000005456968210637569427490234375,
459.86799999999999499777914024889469146728515625,
484.6299999999999954525264911353588104248046875,
674.9660000000000081854523159563541412353515625,
514.883000000000038198777474462985992431640625,
495.49700000000001409716787748038768768310546875,
506.538999999999987267074175179004669189453125
],
"test_run_times": [
127.1200000000000045474735088646411895751953125,
126.2300000000000039790393202565610408782958984375,
123.68999999999999772626324556767940521240234375,
124.18000000000000682121026329696178436279296875,
122.2099999999999937472239253111183643341064453125,
123.030000000000001136868377216160297393798828125,
119.4500000000000028421709430404007434844970703125,
123.3599999999999994315658113919198513031005859375,
161.1200000000000045474735088646411895751953125,
134.31999999999999317878973670303821563720703125,
123.099999999999994315658113919198513031005859375,
124.4599999999999937472239253111183643341064453125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 157.27199999999999135980033315718173980712890625,
"raw_values": [
224.618999999999999772626324556767940521240234375,
163.974999999999994315658113919198513031005859375,
146.551999999999992496668710373342037200927734375,
142.320999999999997953636921010911464691162109375,
140.365000000000009094947017729282379150390625,
149.6490000000000009094947017729282379150390625,
178.847000000000008412825991399586200714111328125,
134.419999999999987494447850622236728668212890625,
144.349999999999994315658113919198513031005859375,
143.407000000000010686562745831906795501708984375,
175.58699999999998908606357872486114501953125,
143.176999999999992496668710373342037200927734375
],
"test_run_times": [
239.30000000000001136868377216160297393798828125,
214.81999999999999317878973670303821563720703125,
222.1100000000000136424205265939235687255859375,
232.530000000000001136868377216160297393798828125,
139.94999999999998863131622783839702606201171875,
160.719999999999998863131622783839702606201171875,
163.740000000000009094947017729282379150390625,
161.979999999999989768184605054557323455810546875,
167.460000000000007958078640513122081756591796875,
150.240000000000009094947017729282379150390625,
159.090000000000003410605131648480892181396484375,
143.289999999999992041921359486877918243408203125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 143.59800000000001318767317570745944976806640625,
"raw_values": [
145.37700000000000954969436861574649810791015625,
136.6779999999999972715158946812152862548828125,
120.046999999999997044142219237983226776123046875,
122.59399999999999408828443847596645355224609375,
141.722000000000008412825991399586200714111328125,
123.84600000000000363797880709171295166015625,
191.038999999999987267074175179004669189453125,
117.8310000000000030695446184836328029632568359375,
146.364000000000004320099833421409130096435546875,
190.480999999999994543031789362430572509765625
],
"test_run_times": [
137.240000000000009094947017729282379150390625,
133.8600000000000136424205265939235687255859375,
131.3899999999999863575794734060764312744140625,
129.340000000000003410605131648480892181396484375,
122.1299999999999954525264911353588104248046875,
115.7900000000000062527760746888816356658935546875,
123.8900000000000005684341886080801486968994140625,
126.06000000000000227373675443232059478759765625,
122.75,
140.650000000000005684341886080801486968994140625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 808.508000000000038198777474462985992431640625,
"raw_values": [
817.730999999999994543031789362430572509765625,
704.5159999999999627107172273099422454833984375,
901.078999999999950887286104261875152587890625,
732.0320000000000391082721762359142303466796875,
1022.980999999999994543031789362430572509765625,
730.0739999999999554347596131265163421630859375,
782.749000000000023646862246096134185791015625,
697.240999999999985448084771633148193359375,
888.171000000000049112713895738124847412109375
],
"test_run_times": [
285.970000000000027284841053187847137451171875,
255.5,
261.31999999999999317878973670303821563720703125,
239.090000000000003410605131648480892181396484375,
253.650000000000005684341886080801486968994140625,
206.520000000000010231815394945442676544189453125,
250.900000000000005684341886080801486968994140625,
238.759999999999990905052982270717620849609375,
293.779999999999972715158946812152862548828125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"39aadc47db20526c9604590bb4b28ae265a23303": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 100",
"description": "Scaling Factor: 100 - Clients: 100 - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 187,
"raw_values": [
143.44693799999998873317963443696498870849609375,
145.917338999999998350176610983908176422119140625,
192.042026999999990266587701626121997833251953125,
209.0729509999999891078914515674114227294921875,
180.54732500000000072759576141834259033203125,
210.16135600000001204534783028066158294677734375,
217.61219399999998813655111007392406463623046875,
206.491974999999996498445398174226284027099609375,
148.270296000000001868102117441594600677490234375,
194.36282199999999420469976030290126800537109375,
201.962297000000006619302439503371715545654296875,
197.552108000000004039975465275347232818603515625
],
"test_run_times": [
127.1200000000000045474735088646411895751953125,
126.2300000000000039790393202565610408782958984375,
123.68999999999999772626324556767940521240234375,
124.18000000000000682121026329696178436279296875,
122.2099999999999937472239253111183643341064453125,
123.030000000000001136868377216160297393798828125,
119.4500000000000028421709430404007434844970703125,
123.3599999999999994315658113919198513031005859375,
161.1200000000000045474735088646411895751953125,
134.31999999999999317878973670303821563720703125,
123.099999999999994315658113919198513031005859375,
124.4599999999999937472239253111183643341064453125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 649,
"raw_values": [
445.48889900000000352520146407186985015869140625,
610.286452000000053885742090642452239990234375,
682.853296000000000276486389338970184326171875,
703.079332000000022162566892802715301513671875,
712.9215659999999843421392142772674560546875,
668.6435629999999719075276516377925872802734375,
559.505615000000034342519938945770263671875,
744.436989000000039595761336386203765869140625,
693.2323330000000396466930396854877471923828125,
697.7579600000000255022314377129077911376953125,
569.8713910000000169020495377480983734130859375,
698.9068559999999479259713552892208099365234375
],
"test_run_times": [
239.30000000000001136868377216160297393798828125,
214.81999999999999317878973670303821563720703125,
222.1100000000000136424205265939235687255859375,
232.530000000000001136868377216160297393798828125,
139.94999999999998863131622783839702606201171875,
160.719999999999998863131622783839702606201171875,
163.740000000000009094947017729282379150390625,
161.979999999999989768184605054557323455810546875,
167.460000000000007958078640513122081756591796875,
150.240000000000009094947017729282379150390625,
159.090000000000003410605131648480892181396484375,
143.289999999999992041921359486877918243408203125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 717,
"raw_values": [
688.374598999999989246134646236896514892578125,
732.1435840000000325744622386991977691650390625,
833.55261199999995369580574333667755126953125,
816.2408110000000078798620961606502532958984375,
706.075681000000031417584978044033050537109375,
807.9703419999999596257111988961696624755859375,
523.7979870000000346408342011272907257080078125,
849.2296710000000530271790921688079833984375,
683.6646240000000034342519938945770263671875,
525.3103139999999484643922187387943267822265625
],
"test_run_times": [
137.240000000000009094947017729282379150390625,
133.8600000000000136424205265939235687255859375,
131.3899999999999863575794734060764312744140625,
129.340000000000003410605131648480892181396484375,
122.1299999999999954525264911353588104248046875,
115.7900000000000062527760746888816356658935546875,
123.8900000000000005684341886080801486968994140625,
126.06000000000000227373675443232059478759765625,
122.75,
140.650000000000005684341886080801486968994140625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 126,
"raw_values": [
122.371252999999995836333255283534526824951171875,
142.039032999999989215211826376616954803466796875,
111.0594320000000010395524441264569759368896484375,
136.6997979999999870415194891393184661865234375,
97.8211840000000023565007722936570644378662109375,
137.0754279999999880601535551249980926513671875,
127.8414120000000053778421715833246707916259765625,
143.528177999999996927726897411048412322998046875,
112.670963999999997895429260097444057464599609375
],
"test_run_times": [
285.970000000000027284841053187847137451171875,
255.5,
261.31999999999999317878973670303821563720703125,
239.090000000000003410605131648480892181396484375,
253.650000000000005684341886080801486968994140625,
206.520000000000010231815394945442676544189453125,
250.900000000000005684341886080801486968994140625,
238.759999999999990905052982270717620849609375,
293.779999999999972715158946812152862548828125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"64a31814890717ee48592736ec4f4af3ef4d4da6": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 50 -S",
"description": "Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 431.576999999999998181010596454143524169921875,
"raw_values": [
408.25799999999998135535861365497112274169921875,
455.17000000000001591615728102624416351318359375,
468.94900000000001227817847393453121185302734375,
438.14100000000001955413608811795711517333984375,
485.06000000000000227373675443232059478759765625,
411.23700000000002319211489520967006683349609375,
430.538999999999987267074175179004669189453125,
347.7459999999999809006112627685070037841796875,
439.095000000000027284841053187847137451171875
],
"test_run_times": [
999.5900000000000318323145620524883270263671875,
974.950000000000045474735088646411895751953125,
1039.34999999999990905052982270717620849609375,
998.1100000000000136424205265939235687255859375,
1005.009999999999990905052982270717620849609375,
1018.3300000000000409272615797817707061767578125,
984.700000000000045474735088646411895751953125,
976.950000000000045474735088646411895751953125,
995.1599999999999681676854379475116729736328125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 394.2559999999999718056642450392246246337890625,
"raw_values": [
386.73799999999999954525264911353588104248046875,
422.76799999999997226041159592568874359130859375,
394.6960000000000263753463514149188995361328125,
409.3129999999999881765688769519329071044921875,
407.33800000000002228262019343674182891845703125,
382.24299999999999499777914024889469146728515625,
368.8210000000000263753463514149188995361328125,
403.8129999999999881765688769519329071044921875,
372.56999999999999317878973670303821563720703125
],
"test_run_times": [
2273.4600000000000363797880709171295166015625,
2052.78000000000020008883439004421234130859375,
1504.09999999999990905052982270717620849609375,
1565.180000000000063664629124104976654052734375,
2129.3699999999998908606357872486114501953125,
1958.319999999999936335370875895023345947265625,
1465.390000000000100044417195022106170654296875,
1550.48000000000001818989403545856475830078125,
2150.8800000000001091393642127513885498046875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 1040.513999999999896317603997886180877685546875,
"raw_values": [
976.479000000000041836756281554698944091796875,
1238.52399999999988722265698015689849853515625,
884.9009999999999536157702095806598663330078125,
1181.557000000000016370904631912708282470703125,
998.2240000000000463842297904193401336669921875,
894.288999999999987267074175179004669189453125,
960.4650000000000318323145620524883270263671875,
909.866999999999961801222525537014007568359375,
1320.321999999999889041646383702754974365234375
],
"test_run_times": [
1014.6200000000000045474735088646411895751953125,
1068.069999999999936335370875895023345947265625,
1187.740000000000009094947017729282379150390625,
1132.51999999999998181010596454143524169921875,
1156.6300000000001091393642127513885498046875,
1096.200000000000045474735088646411895751953125,
1105.950000000000045474735088646411895751953125,
1012.1799999999999499777914024889469146728515625,
1145.5
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 1423.261999999999943611328490078449249267578125,
"raw_values": [
1679.761999999999943611328490078449249267578125,
1525.78800000000001091393642127513885498046875,
1199.691000000000030922819860279560089111328125,
1447.40000000000009094947017729282379150390625,
1537.738000000000056388671509921550750732421875,
1429.959000000000060026650317013263702392578125,
1469.542999999999892679625190794467926025390625,
1045.24299999999993815436027944087982177734375,
1474.23199999999997089616954326629638671875
],
"test_run_times": [
1742.34999999999990905052982270717620849609375,
2373.920000000000072759576141834259033203125,
2327.3699999999998908606357872486114501953125,
2524.30999999999994543031789362430572509765625,
2514.989999999999781721271574497222900390625,
2424.05999999999994543031789362430572509765625,
2420.38999999999987267074175179004669189453125,
2419.03000000000020008883439004421234130859375,
2524.42999999999983629095368087291717529296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"2b66cb56569ff98a2acde4e5e2d56ef9f703490c": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 50 -S",
"description": "Scaling Factor: 1000 - Clients: 50 - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 117,
"raw_values": [
122.550465000000002646629582159221172332763671875,
109.925963999999993347955751232802867889404296875,
106.7268930000000040081431507132947444915771484375,
114.1950929999999999608917278237640857696533203125,
103.146848000000005640686140395700931549072265625,
121.6673569999999955371094984002411365509033203125,
116.2135109999999968977135722525417804718017578125,
143.877555999999998448402038775384426116943359375,
113.9538739999999990004653227515518665313720703125
],
"test_run_times": [
999.5900000000000318323145620524883270263671875,
974.950000000000045474735088646411895751953125,
1039.34999999999990905052982270717620849609375,
998.1100000000000136424205265939235687255859375,
1005.009999999999990905052982270717620849609375,
1018.3300000000000409272615797817707061767578125,
984.700000000000045474735088646411895751953125,
976.950000000000045474735088646411895751953125,
995.1599999999999681676854379475116729736328125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 127,
"raw_values": [
129.381563999999997349732439033687114715576171875,
118.3443079999999980600478011183440685272216796875,
126.7584489999999988185663823969662189483642578125,
122.235331999999999652573023922741413116455078125,
122.825513000000000829459168016910552978515625,
130.892013999999988982381182722747325897216796875,
135.656661000000013928001862950623035430908203125,
123.9007969999999971832949086092412471771240234375,
134.287273999999996476617525331676006317138671875
],
"test_run_times": [
2273.4600000000000363797880709171295166015625,
2052.78000000000020008883439004421234130859375,
1504.09999999999990905052982270717620849609375,
1565.180000000000063664629124104976654052734375,
2129.3699999999998908606357872486114501953125,
1958.319999999999936335370875895023345947265625,
1465.390000000000100044417195022106170654296875,
1550.48000000000001818989403545856475830078125,
2150.8800000000001091393642127513885498046875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 49,
"raw_values": [
51.236300999999997429767972789704799652099609375,
40.3959100000000006502887117676436901092529296875,
56.5403400000000004865796654485166072845458984375,
42.34470400000000012141754268668591976165771484375,
50.1220349999999967849362292326986789703369140625,
55.94733899999999948704498820006847381591796875,
52.0915269999999992478478816337883472442626953125,
54.99198899999999667898009647615253925323486328125,
37.89316699999999826786734047345817089080810546875
],
"test_run_times": [
1014.6200000000000045474735088646411895751953125,
1068.069999999999936335370875895023345947265625,
1187.740000000000009094947017729282379150390625,
1132.51999999999998181010596454143524169921875,
1156.6300000000001091393642127513885498046875,
1096.200000000000045474735088646411895751953125,
1105.950000000000045474735088646411895751953125,
1012.1799999999999499777914024889469146728515625,
1145.5
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 36,
"raw_values": [
29.787767999999999801730155013501644134521484375,
32.79282599999999803230821271426975727081298828125,
41.706467000000003508830559439957141876220703125,
34.56902000000000185764292837120592594146728515625,
32.53788399999999825240593054331839084625244140625,
34.99031599999999997407940099947154521942138671875,
34.04775599999999968758856994099915027618408203125,
47.86902400000000312729753204621374607086181640625,
33.94128400000000311820258502848446369171142578125
],
"test_run_times": [
1742.34999999999990905052982270717620849609375,
2373.920000000000072759576141834259033203125,
2327.3699999999998908606357872486114501953125,
2524.30999999999994543031789362430572509765625,
2514.989999999999781721271574497222900390625,
2424.05999999999994543031789362430572509765625,
2420.38999999999987267074175179004669189453125,
2419.03000000000020008883439004421234130859375,
2524.42999999999983629095368087291717529296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"745499cae657f5ade32a2817a98996055121e5e0": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 1",
"description": "Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 66.2279999999999944293449516408145427703857421875,
"raw_values": [
82.33899999999999863575794734060764312744140625,
83.243999999999999772626324556767940521240234375,
44.332999999999998408384271897375583648681640625,
76.332999999999998408384271897375583648681640625,
37.4680000000000035242919693700969219207763671875,
79.965000000000003410605131648480892181396484375,
79.51699999999999590727384202182292938232421875,
52.30499999999999971578290569595992565155029296875,
60.5450000000000017053025658242404460906982421875
],
"test_run_times": [
1346.450000000000045474735088646411895751953125,
1131.09999999999990905052982270717620849609375,
1023.26999999999998181010596454143524169921875,
1006.470000000000027284841053187847137451171875,
1007.3999999999999772626324556767940521240234375,
994.0700000000000500222085975110530853271484375,
1007.23000000000001818989403545856475830078125,
995.6100000000000136424205265939235687255859375,
1165.6300000000001091393642127513885498046875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 76.6989999999999980673237587325274944305419921875,
"raw_values": [
76.6640000000000014779288903810083866119384765625,
66.78100000000000591171556152403354644775390625,
79.6110000000000042064129956997931003570556640625,
79.5049999999999954525264911353588104248046875,
70.43500000000000227373675443232059478759765625,
89,
82.2120000000000032969182939268648624420166015625,
69.900000000000005684341886080801486968994140625,
76.183999999999997498889570124447345733642578125
],
"test_run_times": [
2015.4600000000000363797880709171295166015625,
1503.3800000000001091393642127513885498046875,
1966.65000000000009094947017729282379150390625,
2203.13999999999987267074175179004669189453125,
1594.51999999999998181010596454143524169921875,
1712.6199999999998908606357872486114501953125,
2124.6999999999998181010596454143524169921875,
1928.579999999999927240423858165740966796875,
1183.509999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 48.88300000000000267164068645797669887542724609375,
"raw_values": [
49.86500000000000198951966012828052043914794921875,
49.344999999999998863131622783839702606201171875,
41.69500000000000028421709430404007434844970703125,
53.066000000000002501110429875552654266357421875,
49.78699999999999903366187936626374721527099609375,
46.9440000000000026147972675971686840057373046875,
49.969999999999998863131622783839702606201171875,
47.09400000000000119371179607696831226348876953125,
52.1779999999999972715158946812152862548828125
],
"test_run_times": [
1158.990000000000009094947017729282379150390625,
1112.579999999999927240423858165740966796875,
1043.5,
1013.779999999999972715158946812152862548828125,
1166.9600000000000363797880709171295166015625,
1136.549999999999954525264911353588104248046875,
1170.029999999999972715158946812152862548828125,
1150.3800000000001091393642127513885498046875,
1117.670000000000072759576141834259033203125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 87.962999999999993860910763032734394073486328125,
"raw_values": [
78.453000000000002955857780762016773223876953125,
86.7099999999999937472239253111183643341064453125,
89.519000000000005456968210637569427490234375,
82.36799999999999499777914024889469146728515625,
93.304000000000002046363078989088535308837890625,
90.969999999999998863131622783839702606201171875,
91.337999999999993860910763032734394073486328125,
98.6970000000000027284841053187847137451171875,
80.308999999999997498889570124447345733642578125
],
"test_run_times": [
1182.76999999999998181010596454143524169921875,
1252.30999999999994543031789362430572509765625,
1245.660000000000081854523159563541412353515625,
1187.950000000000045474735088646411895751953125,
1250.8699999999998908606357872486114501953125,
1217.8800000000001091393642127513885498046875,
1242.80999999999994543031789362430572509765625,
1256.170000000000072759576141834259033203125,
1219.73000000000001818989403545856475830078125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"ff700e82d6109d1e9f6016fc68748d168c3dba88": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 1",
"description": "Scaling Factor: 1000 - Clients: 1 - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 16,
"raw_values": [
12.1514830000000007004246072028763592243194580078125,
12.0185230000000000671889210934750735759735107421875,
22.568702999999999292413122020661830902099609375,
13.1133019999999991256345310830511152744293212890625,
26.71113100000000173395164893008768558502197265625,
12.5139530000000007703420124016702175140380859375,
12.582767000000000479076334158889949321746826171875,
19.131060999999998983867044444195926189422607421875,
16.5250979999999998426574165932834148406982421875
],
"test_run_times": [
1346.450000000000045474735088646411895751953125,
1131.09999999999990905052982270717620849609375,
1023.26999999999998181010596454143524169921875,
1006.470000000000027284841053187847137451171875,
1007.3999999999999772626324556767940521240234375,
994.0700000000000500222085975110530853271484375,
1007.23000000000001818989403545856475830078125,
995.6100000000000136424205265939235687255859375,
1165.6300000000001091393642127513885498046875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 13,
"raw_values": [
13.049879000000000672798705636523663997650146484375,
14.986430999999999613692125421948730945587158203125,
12.5699009999999997688746589119546115398406982421875,
12.585679999999999978399500832892954349517822265625,
14.206177000000000276713763014413416385650634765625,
11.24292799999999914462023298256099224090576171875,
12.1713070000000005421725290943868458271026611328125,
14.3149800000000002597744241938926279544830322265625,
13.13435199999999980491338646970689296722412109375
],
"test_run_times": [
2015.4600000000000363797880709171295166015625,
1503.3800000000001091393642127513885498046875,
1966.65000000000009094947017729282379150390625,
2203.13999999999987267074175179004669189453125,
1594.51999999999998181010596454143524169921875,
1712.6199999999998908606357872486114501953125,
2124.6999999999998181010596454143524169921875,
1928.579999999999927240423858165740966796875,
1183.509999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 21,
"raw_values": [
20.0646899999999988040144671685993671417236328125,
20.281797000000000963382262852974236011505126953125,
23.995225999999998833800418651662766933441162109375,
18.855063999999998713974491693079471588134765625,
20.096748000000001610487743164412677288055419921875,
21.312196000000000140062184073030948638916015625,
20.027792000000001593207343830727040767669677734375,
21.244519000000000374939190805889666080474853515625,
19.180644000000000914951669983565807342529296875
],
"test_run_times": [
1158.990000000000009094947017729282379150390625,
1112.579999999999927240423858165740966796875,
1043.5,
1013.779999999999972715158946812152862548828125,
1166.9600000000000363797880709171295166015625,
1136.549999999999954525264911353588104248046875,
1170.029999999999972715158946812152862548828125,
1150.3800000000001091393642127513885498046875,
1117.670000000000072759576141834259033203125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 11,
"raw_values": [
12.752663999999999333567757275886833667755126953125,
11.5407829999999993475512383156456053256988525390625,
11.177851000000000425416146754287183284759521484375,
12.1510079999999991429149304167367517948150634765625,
10.730779999999999319015842047519981861114501953125,
10.99894199999999955252860672771930694580078125,
10.9536339999999992045331964618526399135589599609375,
10.1372319999999991324557413463480770587921142578125,
12.4578340000000000742375050322152674198150634765625
],
"test_run_times": [
1182.76999999999998181010596454143524169921875,
1252.30999999999994543031789362430572509765625,
1245.660000000000081854523159563541412353515625,
1187.950000000000045474735088646411895751953125,
1250.8699999999998908606357872486114501953125,
1217.8800000000001091393642127513885498046875,
1242.80999999999994543031789362430572509765625,
1256.170000000000072759576141834259033203125,
1219.73000000000001818989403545856475830078125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"e663bdccf1911859d0b5df203b641a2f4874b44c": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 50",
"description": "Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 278.67599999999998772182152606546878814697265625,
"raw_values": [
250.23799999999999954525264911353588104248046875,
281.8700000000000045474735088646411895751953125,
284.17000000000001591615728102624416351318359375,
234.3410000000000081854523159563541412353515625,
326.97300000000001318767317570745944976806640625,
302.73799999999999954525264911353588104248046875,
272.75,
249.102000000000003865352482534945011138916015625,
305.90100000000001045918907038867473602294921875
],
"test_run_times": [
159.229999999999989768184605054557323455810546875,
151.8600000000000136424205265939235687255859375,
160.6200000000000045474735088646411895751953125,
161.479999999999989768184605054557323455810546875,
161.090000000000003410605131648480892181396484375,
160.719999999999998863131622783839702606201171875,
159.69999999999998863131622783839702606201171875,
158.56999999999999317878973670303821563720703125,
163.729999999999989768184605054557323455810546875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 98.1009999999999990905052982270717620849609375,
"raw_values": [
96.51699999999999590727384202182292938232421875,
88.6230000000000046611603465862572193145751953125,
120.1400000000000005684341886080801486968994140625,
102.79099999999999681676854379475116729736328125,
96.68999999999999772626324556767940521240234375,
99.7950000000000017053025658242404460906982421875,
91.0100000000000051159076974727213382720947265625,
95.751000000000004774847184307873249053955078125,
100.7900000000000062527760746888816356658935546875,
93.683999999999997498889570124447345733642578125,
94.522999999999996134647517465054988861083984375,
96.9009999999999962483343551866710186004638671875
],
"test_run_times": [
155.919999999999987494447850622236728668212890625,
169.280000000000001136868377216160297393798828125,
191.090000000000003410605131648480892181396484375,
186.5,
215,
224.580000000000012505552149377763271331787109375,
219.479999999999989768184605054557323455810546875,
206.789999999999992041921359486877918243408203125,
216.150000000000005684341886080801486968994140625,
195.330000000000012505552149377763271331787109375,
196.44999999999998863131622783839702606201171875,
205.080000000000012505552149377763271331787109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 1014.6920000000000072759576141834259033203125,
"raw_values": [
1005.615000000000009094947017729282379150390625,
1016.174999999999954525264911353588104248046875,
1022.2849999999999681676854379475116729736328125
],
"test_run_times": [
287.8600000000000136424205265939235687255859375,
286.1499999999999772626324556767940521240234375,
288.509999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 178.70900000000000318323145620524883270263671875,
"raw_values": [
150.515999999999991132426657713949680328369140625,
192.769000000000005456968210637569427490234375,
127.974999999999994315658113919198513031005859375,
140.1920000000000072759576141834259033203125,
106.054000000000002046363078989088535308837890625,
232.085000000000007958078640513122081756591796875,
135.493999999999999772626324556767940521240234375,
201.01200000000000045474735088646411895751953125,
322.2839999999999918145476840436458587646484375
],
"test_run_times": [
130.460000000000007958078640513122081756591796875,
139.080000000000012505552149377763271331787109375,
116.43999999999999772626324556767940521240234375,
126.2900000000000062527760746888816356658935546875,
122.599999999999994315658113919198513031005859375,
128.93000000000000682121026329696178436279296875,
129.81999999999999317878973670303821563720703125,
130.43000000000000682121026329696178436279296875,
138.039999999999992041921359486877918243408203125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 186.917000000000001591615728102624416351318359375,
"raw_values": [
242.931999999999987949195201508700847625732421875,
185.929000000000002046363078989088535308837890625,
161.27600000000001045918907038867473602294921875,
154.663999999999987267074175179004669189453125,
221.0430000000000063664629124104976654052734375,
159.251000000000004774847184307873249053955078125,
159.27600000000001045918907038867473602294921875,
222.27899999999999636202119290828704833984375,
128.032999999999987039700499735772609710693359375,
163.586000000000012732925824820995330810546875,
193.4859999999999899955582804977893829345703125,
251.24299999999999499777914024889469146728515625
],
"test_run_times": [
133.039999999999992041921359486877918243408203125,
133.1200000000000045474735088646411895751953125,
125.2699999999999960209606797434389591217041015625,
138.44999999999998863131622783839702606201171875,
139.06999999999999317878973670303821563720703125,
133.469999999999998863131622783839702606201171875,
135.090000000000003410605131648480892181396484375,
132.1299999999999954525264911353588104248046875,
131.31000000000000227373675443232059478759765625,
133.8700000000000045474735088646411895751953125,
133.25,
133.6100000000000136424205265939235687255859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"769fb9210929c7b46856dd79f332d40608ec7525": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 50",
"description": "Scaling Factor: 100 - Clients: 50 - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 181,
"raw_values": [
199.9435290000000122745404951274394989013671875,
177.5102200000000038926373235881328582763671875,
176.088039000000009082214091904461383819580078125,
213.534907000000004018147592432796955108642578125,
153.020413999999988163835951127111911773681640625,
165.269171999999997524355421774089336395263671875,
183.438543000000009897121344693005084991455078125,
200.857364999999987276169122196733951568603515625,
163.55667099999999436477082781493663787841796875
],
"test_run_times": [
159.229999999999989768184605054557323455810546875,
151.8600000000000136424205265939235687255859375,
160.6200000000000045474735088646411895751953125,
161.479999999999989768184605054557323455810546875,
161.090000000000003410605131648480892181396484375,
160.719999999999998863131622783839702606201171875,
159.69999999999998863131622783839702606201171875,
158.56999999999999317878973670303821563720703125,
163.729999999999989768184605054557323455810546875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 513,
"raw_values": [
518.400216000000000349245965480804443359375,
564.56816200000002936576493084430694580078125,
416.46814299999999775536707602441310882568359375,
486.749681000000009589712135493755340576171875,
517.495838000000048850779421627521514892578125,
501.34317800000002307569957338273525238037109375,
549.79449999999997089616954326629638671875,
522.5087429999999812935129739344120025634765625,
496.39060799999998607745510526001453399658203125,
534.0544909999999845240381546318531036376953125,
529.324902999999949315679259598255157470703125,
516.332873999999947045580483973026275634765625
],
"test_run_times": [
155.919999999999987494447850622236728668212890625,
169.280000000000001136868377216160297393798828125,
191.090000000000003410605131648480892181396484375,
186.5,
215,
224.580000000000012505552149377763271331787109375,
219.479999999999989768184605054557323455810546875,
206.789999999999992041921359486877918243408203125,
216.150000000000005684341886080801486968994140625,
195.330000000000012505552149377763271331787109375,
196.44999999999998863131622783839702606201171875,
205.080000000000012505552149377763271331787109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 49,
"raw_values": [
49.75190400000000323643689625896513462066650390625,
49.237042000000002417436917312443256378173828125,
48.94344000000000249883669312112033367156982421875
],
"test_run_times": [
287.8600000000000136424205265939235687255859375,
286.1499999999999772626324556767940521240234375,
288.509999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 311,
"raw_values": [
332.41423600000001670196070335805416107177734375,
259.5503979999999728534021414816379547119140625,
390.98620099999999411011231131851673126220703125,
356.8827509999999847423168830573558807373046875,
471.7677489999999806968844495713710784912109375,
215.580639999999988276613294146955013275146484375,
369.28826600000002144952304661273956298828125,
248.89839200000000118961906991899013519287109375,
155.245537000000012994860298931598663330078125
],
"test_run_times": [
130.460000000000007958078640513122081756591796875,
139.080000000000012505552149377763271331787109375,
116.43999999999999772626324556767940521240234375,
126.2900000000000062527760746888816356658935546875,
122.599999999999994315658113919198513031005859375,
128.93000000000000682121026329696178436279296875,
129.81999999999999317878973670303821563720703125,
130.43000000000000682121026329696178436279296875,
138.039999999999992041921359486877918243408203125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 279,
"raw_values": [
205.946044999999998026396497152745723724365234375,
269.08394700000002330853021703660488128662109375,
310.26742899999999281135387718677520751953125,
323.525675999999975829268805682659149169921875,
226.332008999999999332430888898670673370361328125,
314.2071369999999888023012317717075347900390625,
314.1437779999999975188984535634517669677734375,
225.08431799999999611827661283314228057861328125,
390.81950000000000500222085975110530853271484375,
305.87024500000001125954440794885158538818359375,
258.57278400000001283842721022665500640869140625,
199.14879500000000689396983943879604339599609375
],
"test_run_times": [
133.039999999999992041921359486877918243408203125,
133.1200000000000045474735088646411895751953125,
125.2699999999999960209606797434389591217041015625,
138.44999999999998863131622783839702606201171875,
139.06999999999999317878973670303821563720703125,
133.469999999999998863131622783839702606201171875,
135.090000000000003410605131648480892181396484375,
132.1299999999999954525264911353588104248046875,
131.31000000000000227373675443232059478759765625,
133.8700000000000045474735088646411895751953125,
133.25,
133.6100000000000136424205265939235687255859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"9f2ed94d28a42e02c0ae5b0ca004dc06a1361d86": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 100 -S",
"description": "Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 231.0339999999999918145476840436458587646484375,
"raw_values": [
161.188999999999992951416061259806156158447265625,
191.2640000000000100044417195022106170654296875,
279.0539999999999736246536485850811004638671875,
206.308999999999997498889570124447345733642578125,
274.51200000000000045474735088646411895751953125,
250.33699999999998908606357872486114501953125,
278.2559999999999718056642450392246246337890625,
220.099999999999994315658113919198513031005859375,
288.644000000000005456968210637569427490234375,
254,
227.729999999999989768184605054557323455810546875,
141.01699999999999590727384202182292938232421875
],
"test_run_times": [
157.830000000000012505552149377763271331787109375,
156.349999999999994315658113919198513031005859375,
163.289999999999992041921359486877918243408203125,
155.659999999999996589394868351519107818603515625,
164.080000000000012505552149377763271331787109375,
163.650000000000005684341886080801486968994140625,
161.30000000000001136868377216160297393798828125,
160.25,
161.169999999999987494447850622236728668212890625,
159.789999999999992041921359486877918243408203125,
163.3899999999999863575794734060764312744140625,
159.409999999999996589394868351519107818603515625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 9.0340000000000006963318810448981821537017822265625,
"raw_values": [
8.9839999999999999857891452847979962825775146484375,
9.0540000000000002700062395888380706310272216796875,
9.0630000000000006110667527536861598491668701171875
],
"test_run_times": [
173.150000000000005684341886080801486968994140625,
147.05000000000001136868377216160297393798828125,
163.349999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 140.501000000000004774847184307873249053955078125,
"raw_values": [
305.8079999999999927240423858165740966796875,
9.349000000000000198951966012828052043914794921875,
284.46399999999999863575794734060764312744140625,
248.145000000000010231815394945442676544189453125,
92.320999999999997953636921010911464691162109375,
31.7710000000000007958078640513122081756591796875,
9.6809999999999991615595718030817806720733642578125,
9.368999999999999772626324556767940521240234375,
164.8410000000000081854523159563541412353515625,
333.2450000000000045474735088646411895751953125,
174.5819999999999936335370875895023345947265625,
22.43599999999999994315658113919198513031005859375
],
"test_run_times": [
104.6700000000000017053025658242404460906982421875,
116.150000000000005684341886080801486968994140625,
131.1299999999999954525264911353588104248046875,
132.8700000000000045474735088646411895751953125,
137.969999999999998863131622783839702606201171875,
121.6700000000000017053025658242404460906982421875,
139.919999999999987494447850622236728668212890625,
130.740000000000009094947017729282379150390625,
139.43999999999999772626324556767940521240234375,
138.590000000000003410605131648480892181396484375,
133.759999999999990905052982270717620849609375,
126.18000000000000682121026329696178436279296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 10.9909999999999996589394868351519107818603515625,
"raw_values": [
11.330999999999999516830939683131873607635498046875,
11.2520000000000006679101716144941747188568115234375,
10.160000000000000142108547152020037174224853515625,
10.974000000000000198951966012828052043914794921875,
11.1899999999999995026200849679298698902130126953125,
10.92999999999999971578290569595992565155029296875,
11.0559999999999991615595718030817806720733642578125,
11.1059999999999998721023075631819665431976318359375,
11.1959999999999997299937604111619293689727783203125,
10.51200000000000045474735088646411895751953125,
11.1159999999999996589394868351519107818603515625,
11.0660000000000007247535904753021895885467529296875
],
"test_run_times": [
156.18000000000000682121026329696178436279296875,
127.93999999999999772626324556767940521240234375,
127.3900000000000005684341886080801486968994140625,
126.1700000000000017053025658242404460906982421875,
127.0499999999999971578290569595992565155029296875,
134.030000000000001136868377216160297393798828125,
130.8600000000000136424205265939235687255859375,
123.4899999999999948840923025272786617279052734375,
131.68999999999999772626324556767940521240234375,
142.520000000000010231815394945442676544189453125,
131.280000000000001136868377216160297393798828125,
131.490000000000009094947017729282379150390625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"128b714660bc4a88770d556c09581e1d766f2a10": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 100 -S",
"description": "Scaling Factor: 100 - Clients: 100 - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 455,
"raw_values": [
620.914657000000033804099075496196746826171875,
523.1818050000000539512257091701030731201171875,
358.657738999999992302036844193935394287109375,
485.0453909999999950741766951978206634521484375,
364.534006999999974141246639192104339599609375,
400.05063699999999471401679329574108123779296875,
359.7046589999999923747964203357696533203125,
454.6751960000000281070242635905742645263671875,
346.68945300000001452644937671720981597900390625,
393.9780190000000175132299773395061492919921875,
439.411976999999978943378664553165435791015625,
709.642920000000003710738383233547210693359375
],
"test_run_times": [
157.830000000000012505552149377763271331787109375,
156.349999999999994315658113919198513031005859375,
163.289999999999992041921359486877918243408203125,
155.659999999999996589394868351519107818603515625,
164.080000000000012505552149377763271331787109375,
163.650000000000005684341886080801486968994140625,
161.30000000000001136868377216160297393798828125,
160.25,
161.169999999999987494447850622236728668212890625,
159.789999999999992041921359486877918243408203125,
163.3899999999999863575794734060764312744140625,
159.409999999999996589394868351519107818603515625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 11077,
"raw_values": [
11138.15795699999944190494716167449951171875,
11052.178137000000788248144090175628662109375,
11041.33922800000073038972914218902587890625
],
"test_run_times": [
173.150000000000005684341886080801486968994140625,
147.05000000000001136868377216160297393798828125,
163.349999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 3582,
"raw_values": [
327.22840400000001181979314424097537994384765625,
10704.79112399999939952977001667022705078125,
351.76726999999999634383129887282848358154296875,
403.25677500000000463842297904193401336669921875,
1083.869390999999950508936308324337005615234375,
3149.650526999999783583916723728179931640625,
10336.290364000000408850610256195068359375,
10681.48688000000038300640881061553955078125,
607.019438000000036481651477515697479248046875,
300.279354000000012092641554772853851318359375,
573.182191999999986364855431020259857177734375,
4460.1224179999999250867404043674468994140625
],
"test_run_times": [
104.6700000000000017053025658242404460906982421875,
116.150000000000005684341886080801486968994140625,
131.1299999999999954525264911353588104248046875,
132.8700000000000045474735088646411895751953125,
137.969999999999998863131622783839702606201171875,
121.6700000000000017053025658242404460906982421875,
139.919999999999987494447850622236728668212890625,
130.740000000000009094947017729282379150390625,
139.43999999999999772626324556767940521240234375,
138.590000000000003410605131648480892181396484375,
133.759999999999990905052982270717620849609375,
126.18000000000000682121026329696178436279296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 9114,
"raw_values": [
8831.413012999999409657903015613555908203125,
8893.58772200000021257437765598297119140625,
9850.212254000000029918737709522247314453125,
9119.6232810000001336447894573211669921875,
8943.0089389999993727542459964752197265625,
9155.90331399999922723509371280670166015625,
9052.369235000000116997398436069488525390625,
9011.66634100000010221265256404876708984375,
8937.72219699999914155341684818267822265625,
9520.685202999999091844074428081512451171875,
9002.477084000000104424543678760528564453125,
9043.62391299999944749288260936737060546875
],
"test_run_times": [
156.18000000000000682121026329696178436279296875,
127.93999999999999772626324556767940521240234375,
127.3900000000000005684341886080801486968994140625,
126.1700000000000017053025658242404460906982421875,
127.0499999999999971578290569595992565155029296875,
134.030000000000001136868377216160297393798828125,
130.8600000000000136424205265939235687255859375,
123.4899999999999948840923025272786617279052734375,
131.68999999999999772626324556767940521240234375,
142.520000000000010231815394945442676544189453125,
131.280000000000001136868377216160297393798828125,
131.490000000000009094947017729282379150390625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"01ccfa223a851f53af7821eb210f02570eb9f64b": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 1 -S",
"description": "Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 26.80799999999999982946974341757595539093017578125,
"raw_values": [
21.742999999999998550492819049395620822906494140625,
22.821999999999999175770426518283784389495849609375,
26.507000000000001449507180950604379177093505859375,
24.519999999999999573674358543939888477325439453125,
27.477000000000000312638803734444081783294677734375,
33.6400000000000005684341886080801486968994140625,
30.94500000000000028421709430404007434844970703125
],
"test_run_times": [
1211.670000000000072759576141834259033203125,
1195.73000000000001818989403545856475830078125,
1216.98000000000001818989403545856475830078125,
1275.6199999999998908606357872486114501953125,
1288.25,
1316.700000000000045474735088646411895751953125,
1885.09999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 79.1640000000000014779288903810083866119384765625,
"raw_values": [
99.3970000000000055706550483591854572296142578125,
74.125,
91.4860000000000042064129956997931003570556640625,
85.215000000000003410605131648480892181396484375,
84.21399999999999863575794734060764312744140625,
92.9719999999999942019712761975824832916259765625,
26.739000000000000767386154620908200740814208984375
],
"test_run_times": [
3283.7100000000000363797880709171295166015625,
2905.6300000000001091393642127513885498046875,
2416.15999999999985448084771633148193359375,
2061.96999999999979991116560995578765869140625,
2410.2100000000000363797880709171295166015625,
2425.90000000000009094947017729282379150390625,
1627.720000000000027284841053187847137451171875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 24.54599999999999937472239253111183643341064453125,
"raw_values": [
25.0090000000000003410605131648480892181396484375,
23.721000000000000085265128291212022304534912109375,
24.660000000000000142108547152020037174224853515625,
24.792000000000001591615728102624416351318359375
],
"test_run_times": [
1162.910000000000081854523159563541412353515625,
1123.75,
1102.1300000000001091393642127513885498046875,
990.6799999999999499777914024889469146728515625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 35.19800000000000039790393202565610408782958984375,
"raw_values": [
39.7120000000000032969182939268648624420166015625,
24.5270000000000010231815394945442676544189453125,
34.85600000000000164845914696343243122100830078125,
39.9729999999999989768184605054557323455810546875,
26.2590000000000003410605131648480892181396484375,
33.02799999999999869260136620141565799713134765625,
35.13900000000000289901436190120875835418701171875,
40.66799999999999926103555480949580669403076171875,
42.618999999999999772626324556767940521240234375
],
"test_run_times": [
1275.240000000000009094947017729282379150390625,
1158.089999999999918145476840436458587646484375,
1212.359999999999899955582804977893829345703125,
1233.140000000000100044417195022106170654296875,
1158.950000000000045474735088646411895751953125,
1213.5,
1228.609999999999899955582804977893829345703125,
1198.6300000000001091393642127513885498046875,
1230.109999999999899955582804977893829345703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"6f3b8abb5cb78e9842f85c9b4ed0681515f5acf3": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1000 -c 1 -S",
"description": "Scaling Factor: 1000 - Clients: 1 - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 38,
"raw_values": [
46.02906500000000278305378742516040802001953125,
43.84575600000000150657797348685562610626220703125,
37.756292999999999437932274304330348968505859375,
40.8065500000000014324541552923619747161865234375,
36.42357700000000164664015755988657474517822265625,
29.740345999999998838347892160527408123016357421875,
32.33398700000000047793946578167378902435302734375
],
"test_run_times": [
1211.670000000000072759576141834259033203125,
1195.73000000000001818989403545856475830078125,
1216.98000000000001818989403545856475830078125,
1275.6199999999998908606357872486114501953125,
1288.25,
1316.700000000000045474735088646411895751953125,
1885.09999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 15,
"raw_values": [
10.0661529999999999063220457173883914947509765625,
13.499781999999999726469468441791832447052001953125,
10.9368269999999991881622918299399316310882568359375,
11.74028799999999961301000439561903476715087890625,
11.8804560000000005715037332265637814998626708984375,
10.762736000000000302634362014941871166229248046875,
37.42237899999999939382178126834332942962646484375
],
"test_run_times": [
3283.7100000000000363797880709171295166015625,
2905.6300000000001091393642127513885498046875,
2416.15999999999985448084771633148193359375,
2061.96999999999979991116560995578765869140625,
2410.2100000000000363797880709171295166015625,
2425.90000000000009094947017729282379150390625,
1627.720000000000027284841053187847137451171875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 41,
"raw_values": [
40.0042609999999996261976775713264942169189453125,
42.17898100000000027876012609340250492095947265625,
40.5717920000000020763764041475951671600341796875,
40.354962999999997919076122343540191650390625
],
"test_run_times": [
1162.910000000000081854523159563541412353515625,
1123.75,
1102.1300000000001091393642127513885498046875,
990.6799999999999499777914024889469146728515625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 29,
"raw_values": [
25.202529999999999432702679769136011600494384765625,
40.790987999999998692146618850529193878173828125,
28.705307999999998713747118017636239528656005859375,
25.030795999999998713292370666749775409698486328125,
38.11322899999999691544871893711388111114501953125,
30.293893000000000625959728495217859745025634765625,
28.47285000000000110276232589967548847198486328125,
24.602244999999999919282345217652618885040283203125,
23.47465100000000148838807945139706134796142578125
],
"test_run_times": [
1275.240000000000009094947017729282379150390625,
1158.089999999999918145476840436458587646484375,
1212.359999999999899955582804977893829345703125,
1233.140000000000100044417195022106170654296875,
1158.950000000000045474735088646411895751953125,
1213.5,
1228.609999999999899955582804977893829345703125,
1198.6300000000001091393642127513885498046875,
1230.109999999999899955582804977893829345703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"db296ccca54d5cff7cebe633bf606f73cffab741": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 50 -S",
"description": "Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 130.7450000000000045474735088646411895751953125,
"raw_values": [
144.806999999999987949195201508700847625732421875,
140.8410000000000081854523159563541412353515625,
130.22800000000000864019966684281826019287109375,
124.8670000000000044337866711430251598358154296875,
139.48799999999999954525264911353588104248046875,
151.256000000000000227373675443232059478759765625,
148.551999999999992496668710373342037200927734375,
66.8359999999999985220711096189916133880615234375,
129.832999999999998408384271897375583648681640625
],
"test_run_times": [
139.31999999999999317878973670303821563720703125,
139.06000000000000227373675443232059478759765625,
141.229999999999989768184605054557323455810546875,
139.1100000000000136424205265939235687255859375,
137.099999999999994315658113919198513031005859375,
141,
138.8899999999999863575794734060764312744140625,
139.759999999999990905052982270717620849609375,
138.080000000000012505552149377763271331787109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 31.995000000000000994759830064140260219573974609375,
"raw_values": [
4.467999999999999971578290569595992565155029296875,
17.928000000000000824229573481716215610504150390625,
33.05199999999999960209606797434389591217041015625,
27.385999999999999232613845379091799259185791015625,
27.602000000000000312638803734444081783294677734375,
33.61500000000000198951966012828052043914794921875,
28.568000000000001392663762089796364307403564453125,
25.605000000000000426325641456060111522674560546875,
20.7950000000000017053025658242404460906982421875,
20.437000000000001165290086646564304828643798828125,
23.699000000000001620037437533028423786163330078125,
120.7830000000000012505552149377763271331787109375
],
"test_run_times": [
169.56999999999999317878973670303821563720703125,
160.009999999999990905052982270717620849609375,
156.169999999999987494447850622236728668212890625,
149.909999999999996589394868351519107818603515625,
161.8799999999999954525264911353588104248046875,
165.25,
161.6100000000000136424205265939235687255859375,
168.05000000000001136868377216160297393798828125,
143.039999999999992041921359486877918243408203125,
160.259999999999990905052982270717620849609375,
152.81000000000000227373675443232059478759765625,
163.81999999999999317878973670303821563720703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 861.413999999999987267074175179004669189453125,
"raw_values": [
870.104000000000041836756281554698944091796875,
865.095000000000027284841053187847137451171875,
849.0439999999999827196006663143634796142578125
],
"test_run_times": [
287.51999999999998181010596454143524169921875,
286.42000000000001591615728102624416351318359375,
288.509999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 29.7530000000000001136868377216160297393798828125,
"raw_values": [
56.97500000000000142108547152020037174224853515625,
4.86300000000000043343106881366111338138580322265625,
17.498000000000001108446667785756289958953857421875,
94.703000000000002955857780762016773223876953125,
18.739000000000000767386154620908200740814208984375,
84.2660000000000053432813729159533977508544921875,
4.4779999999999997584154698415659368038177490234375,
4.4749999999999996447286321199499070644378662109375,
4.53000000000000024868995751603506505489349365234375,
46.9429999999999978399500832892954349517822265625,
8.1760000000000001563194018672220408916473388671875,
11.393000000000000682121026329696178436279296875
],
"test_run_times": [
127.219999999999998863131622783839702606201171875,
120.6200000000000045474735088646411895751953125,
127.1700000000000017053025658242404460906982421875,
124.43000000000000682121026329696178436279296875,
128.05000000000001136868377216160297393798828125,
118.7999999999999971578290569595992565155029296875,
121.2300000000000039790393202565610408782958984375,
114.3799999999999954525264911353588104248046875,
114.840000000000003410605131648480892181396484375,
129.55000000000001136868377216160297393798828125,
123.5,
124.7000000000000028421709430404007434844970703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 5.3710000000000004405364961712621152400970458984375,
"raw_values": [
5.3300000000000000710542735760100185871124267578125,
5.522999999999999687361196265555918216705322265625,
5.17499999999999982236431605997495353221893310546875,
5.34799999999999986499688020558096468448638916015625,
5.76199999999999956656893118633888661861419677734375,
5.38600000000000012079226507921703159809112548828125,
5.32300000000000039790393202565610408782958984375,
5,
5.48299999999999965183405947755090892314910888671875,
5.31099999999999994315658113919198513031005859375,
5.47299999999999986499688020558096468448638916015625,
5.333999999999999630517777404747903347015380859375
],
"test_run_times": [
127.2099999999999937472239253111183643341064453125,
122.150000000000005684341886080801486968994140625,
132.219999999999998863131622783839702606201171875,
141.469999999999998863131622783839702606201171875,
130.090000000000003410605131648480892181396484375,
135.270000000000010231815394945442676544189453125,
132.259999999999990905052982270717620849609375,
128.830000000000012505552149377763271331787109375,
128.93000000000000682121026329696178436279296875,
127.530000000000001136868377216160297393798828125,
128.210000000000007958078640513122081756591796875,
137.539999999999992041921359486877918243408203125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"15801af0592c8ef94aa499f4a8ccc39083fb8696": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 50 -S",
"description": "Scaling Factor: 100 - Clients: 50 - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 405,
"raw_values": [
345.52152599999999438296072185039520263671875,
355.2636519999999791252776049077510833740234375,
384.22435799999999517240212298929691314697265625,
400.7045289999999795327312313020229339599609375,
358.72687300000001187072484754025936126708984375,
330.78218099999998003113432787358760833740234375,
336.81235199999997576014720834791660308837890625,
748.6011529999999538631527684628963470458984375,
385.3754109999999855062924325466156005859375
],
"test_run_times": [
139.31999999999999317878973670303821563720703125,
139.06000000000000227373675443232059478759765625,
141.229999999999989768184605054557323455810546875,
139.1100000000000136424205265939235687255859375,
137.099999999999994315658113919198513031005859375,
141,
138.8899999999999863575794734060764312744140625,
139.759999999999990905052982270717620849609375,
138.080000000000012505552149377763271331787109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 2643,
"raw_values": [
11200.529429000000163796357810497283935546875,
2790.84759299999996073893271386623382568359375,
1513.826256000000057611032389104366302490234375,
1827.006646999999929903424344956874847412109375,
1812.783548000000109823304228484630584716796875,
1488.405794999999898209352977573871612548828125,
1751.41807199999993827077560126781463623046875,
1954.054084000000102605554275214672088623046875,
2406.0917269999999916763044893741607666015625,
2448.2578659999999217689037322998046875,
2111.21207599999979720450937747955322265625,
414.25641600000000153158907778561115264892578125
],
"test_run_times": [
169.56999999999999317878973670303821563720703125,
160.009999999999990905052982270717620849609375,
156.169999999999987494447850622236728668212890625,
149.909999999999996589394868351519107818603515625,
161.8799999999999954525264911353588104248046875,
165.25,
161.6100000000000136424205265939235687255859375,
168.05000000000001136868377216160297393798828125,
143.039999999999992041921359486877918243408203125,
160.259999999999990905052982270717620849609375,
152.81000000000000227373675443232059478759765625,
163.81999999999999317878973670303821563720703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 58,
"raw_values": [
57.50115799999999666169969714246690273284912109375,
57.83536600000000049703885451890528202056884765625,
58.93150399999999677902451367117464542388916015625
],
"test_run_times": [
287.51999999999998181010596454143524169921875,
286.42000000000001591615728102624416351318359375,
288.509999999999990905052982270717620849609375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 5233,
"raw_values": [
878.1657470000000103027559816837310791015625,
10288.412240999999994528479874134063720703125,
2859.4253699999999298597685992717742919921875,
528.3284429999999929350451566278934478759765625,
2670.33552199999985532485879957675933837890625,
593.757069000000001324224285781383514404296875,
11173.670685999999477644450962543487548828125,
11181.164581999999427353031933307647705078125,
11045.31470199999967007897794246673583984375,
1065.81765399999994770041666924953460693359375,
6119.8781470000003537279553711414337158203125,
4391.7306539999999586143530905246734619140625
],
"test_run_times": [
127.219999999999998863131622783839702606201171875,
120.6200000000000045474735088646411895751953125,
127.1700000000000017053025658242404460906982421875,
124.43000000000000682121026329696178436279296875,
128.05000000000001136868377216160297393798828125,
118.7999999999999971578290569595992565155029296875,
121.2300000000000039790393202565610408782958984375,
114.3799999999999954525264911353588104248046875,
114.840000000000003410605131648480892181396484375,
129.55000000000001136868377216160297393798828125,
123.5,
124.7000000000000028421709430404007434844970703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 9327,
"raw_values": [
9387.09488000000055762939155101776123046875,
9060.015578000000459724105894565582275390625,
9668.43942500000048312358558177947998046875,
9357.20021300000007613562047481536865234375,
8684.2747170000002370215952396392822265625,
9290.592447000000902335159480571746826171875,
9401.446748000000297906808555126190185546875,
10006.984866000000693020410835742950439453125,
9125.337453000000095926225185394287109375,
9421.947006000000328640453517436981201171875,
9143.049392999999327003024518489837646484375,
9379.537755999999717460013926029205322265625
],
"test_run_times": [
127.2099999999999937472239253111183643341064453125,
122.150000000000005684341886080801486968994140625,
132.219999999999998863131622783839702606201171875,
141.469999999999998863131622783839702606201171875,
130.090000000000003410605131648480892181396484375,
135.270000000000010231815394945442676544189453125,
132.259999999999990905052982270717620849609375,
128.830000000000012505552149377763271331787109375,
128.93000000000000682121026329696178436279296875,
127.530000000000001136868377216160297393798828125,
128.210000000000007958078640513122081756591796875,
137.539999999999992041921359486877918243408203125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"ff40a64305c309170da96cc8fe9ca49f3106a979": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 1",
"description": "Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 42.0330000000000012505552149377763271331787109375,
"raw_values": [
52.8119999999999976125764078460633754730224609375,
55.62299999999999755573298898525536060333251953125,
53.18900000000000005684341886080801486968994140625,
22.129999999999999005240169935859739780426025390625,
23.849000000000000198951966012828052043914794921875,
27.71300000000000096633812063373625278472900390625,
46.1520000000000010231815394945442676544189453125,
47.41599999999999681676854379475116729736328125,
49.4140000000000014779288903810083866119384765625
],
"test_run_times": [
137.44999999999998863131622783839702606201171875,
138.960000000000007958078640513122081756591796875,
139.590000000000003410605131648480892181396484375,
138.280000000000001136868377216160297393798828125,
137.419999999999987494447850622236728668212890625,
137.80000000000001136868377216160297393798828125,
136.090000000000003410605131648480892181396484375,
138.210000000000007958078640513122081756591796875,
140.18999999999999772626324556767940521240234375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 28.27199999999999846522769075818359851837158203125,
"raw_values": [
29.8539999999999992041921359486877918243408203125,
26.27799999999999869260136620141565799713134765625,
24.800000000000000710542735760100185871124267578125,
29.242999999999998550492819049395620822906494140625,
27.995000000000000994759830064140260219573974609375,
30.89399999999999835154085303656756877899169921875,
26.824999999999999289457264239899814128875732421875,
26.089999999999999857891452847979962825775146484375,
27.614999999999998436805981327779591083526611328125,
26.1460000000000007958078640513122081756591796875,
32.49000000000000198951966012828052043914794921875,
31.03699999999999903366187936626374721527099609375
],
"test_run_times": [
127.3599999999999994315658113919198513031005859375,
126.5100000000000051159076974727213382720947265625,
130.56999999999999317878973670303821563720703125,
134.259999999999990905052982270717620849609375,
130.31999999999999317878973670303821563720703125,
128.1299999999999954525264911353588104248046875,
125.93000000000000682121026329696178436279296875,
128.979999999999989768184605054557323455810546875,
143.759999999999990905052982270717620849609375,
144.009999999999990905052982270717620849609375,
161.3799999999999954525264911353588104248046875,
159.31999999999999317878973670303821563720703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 41.5870000000000032969182939268648624420166015625,
"raw_values": [
42.582999999999998408384271897375583648681640625,
40.5210000000000007958078640513122081756591796875,
41.6580000000000012505552149377763271331787109375
],
"test_run_times": [
278.51999999999998181010596454143524169921875,
282.42000000000001591615728102624416351318359375,
281.8500000000000227373675443232059478759765625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 21.556000000000000937916411203332245349884033203125,
"raw_values": [
26.123000000000001108446667785756289958953857421875,
20.4020000000000010231815394945442676544189453125,
16.858000000000000540012479177676141262054443359375,
21.7409999999999996589394868351519107818603515625,
14.986000000000000653699316899292171001434326171875,
22.39099999999999823785401531495153903961181640625,
15.2889999999999997015720509807579219341278076171875,
27.81400000000000005684341886080801486968994140625,
16.44800000000000039790393202565610408782958984375,
35.67399999999999948840923025272786617279052734375,
18.614000000000000767386154620908200740814208984375,
22.33200000000000073896444519050419330596923828125
],
"test_run_times": [
126.5199999999999960209606797434389591217041015625,
118.9800000000000039790393202565610408782958984375,
109.5799999999999982946974341757595539093017578125,
118.43000000000000682121026329696178436279296875,
115.469999999999998863131622783839702606201171875,
116.9500000000000028421709430404007434844970703125,
117.9500000000000028421709430404007434844970703125,
122.780000000000001136868377216160297393798828125,
129.25,
138.3899999999999863575794734060764312744140625,
138.409999999999996589394868351519107818603515625,
130.18000000000000682121026329696178436279296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 43.840000000000003410605131648480892181396484375,
"raw_values": [
34.99199999999999732835931354202330112457275390625,
40.840000000000003410605131648480892181396484375,
26.53999999999999914734871708787977695465087890625,
40.243999999999999772626324556767940521240234375,
71.0460000000000064801497501321136951446533203125,
73.9069999999999964757080306299030780792236328125,
21.71900000000000119371179607696831226348876953125,
49.85000000000000142108547152020037174224853515625,
35.42099999999999937472239253111183643341064453125
],
"test_run_times": [
136.770000000000010231815394945442676544189453125,
131.349999999999994315658113919198513031005859375,
142.5,
141.900000000000005684341886080801486968994140625,
129.44999999999998863131622783839702606201171875,
135.210000000000007958078640513122081756591796875,
130.650000000000005684341886080801486968994140625,
125.2999999999999971578290569595992565155029296875,
146.330000000000012505552149377763271331787109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"8b49d0cfe5dd2c7356f335e6f5fbb2b971ec000a": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 1",
"description": "Scaling Factor: 100 - Clients: 1 - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 27,
"raw_values": [
18.943870000000000430873114964924752712249755859375,
17.992937000000001290800355491228401660919189453125,
18.81219899999999967121766530908644199371337890625,
45.21194899999999705642039771191775798797607421875,
41.95798899999999775900505483150482177734375,
36.10173400000000043519321479834616184234619140625,
21.6782970000000005939000402577221393585205078125,
21.1006560000000007448761607520282268524169921875,
20.253685999999998301746018114499747753143310546875
],
"test_run_times": [
137.44999999999998863131622783839702606201171875,
138.960000000000007958078640513122081756591796875,
139.590000000000003410605131648480892181396484375,
138.280000000000001136868377216160297393798828125,
137.419999999999987494447850622236728668212890625,
137.80000000000001136868377216160297393798828125,
136.090000000000003410605131648480892181396484375,
138.210000000000007958078640513122081756591796875,
140.18999999999999772626324556767940521240234375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 36,
"raw_values": [
33.5170389999999969177224556915462017059326171875,
38.07811099999999981946530169807374477386474609375,
40.3502739999999988640411174856126308441162109375,
34.2176400000000029422153602354228496551513671875,
35.74017400000000321824700222350656986236572265625,
32.3900110000000012178134056739509105682373046875,
37.30696400000000068075678427703678607940673828125,
38.3549569999999988567651598714292049407958984375,
36.240982999999999947249307297170162200927734375,
38.26795700000000266527422354556620121002197265625,
30.792919000000001261696525034494698047637939453125,
32.238618999999999914507498033344745635986328125
],
"test_run_times": [
127.3599999999999994315658113919198513031005859375,
126.5100000000000051159076974727213382720947265625,
130.56999999999999317878973670303821563720703125,
134.259999999999990905052982270717620849609375,
130.31999999999999317878973670303821563720703125,
128.1299999999999954525264911353588104248046875,
125.93000000000000682121026329696178436279296875,
128.979999999999989768184605054557323455810546875,
143.759999999999990905052982270717620849609375,
144.009999999999990905052982270717620849609375,
161.3799999999999954525264911353588104248046875,
159.31999999999999317878973670303821563720703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 24,
"raw_values": [
23.49439100000000024692781153135001659393310546875,
24.6907810000000011996235116384923458099365234375,
24.018944999999998657358446507714688777923583984375
],
"test_run_times": [
278.51999999999998181010596454143524169921875,
282.42000000000001591615728102624416351318359375,
281.8500000000000227373675443232059478759765625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 49,
"raw_values": [
38.2998309999999975161699694581329822540283203125,
49.0441009999999977253537508659064769744873046875,
59.347589999999996734914020635187625885009765625,
46.019959000000000060026650317013263702392578125,
66.7656640000000010104486136697232723236083984375,
44.69661800000000084764906205236911773681640625,
65.4359429999999946403477224521338939666748046875,
35.972971000000001140506356023252010345458984375,
60.8269090000000005602487362921237945556640625,
28.048759000000000440877556684426963329315185546875,
53.7486660000000000536601874046027660369873046875,
44.80350899999999825240593054331839084625244140625
],
"test_run_times": [
126.5199999999999960209606797434389591217041015625,
118.9800000000000039790393202565610408782958984375,
109.5799999999999982946974341757595539093017578125,
118.43000000000000682121026329696178436279296875,
115.469999999999998863131622783839702606201171875,
116.9500000000000028421709430404007434844970703125,
117.9500000000000028421709430404007434844970703125,
122.780000000000001136868377216160297393798828125,
129.25,
138.3899999999999863575794734060764312744140625,
138.409999999999996589394868351519107818603515625,
130.18000000000000682121026329696178436279296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 26,
"raw_values": [
28.592040000000000787849785410799086093902587890625,
24.499244999999998384510035975836217403411865234375,
37.6978730000000012978489394299685955047607421875,
24.86201200000000000045474735088646411895751953125,
14.081751000000000573209035792388021945953369140625,
13.540839999999999321289578801952302455902099609375,
46.06792399999999787496562930755317211151123046875,
20.072008000000000293994162348099052906036376953125,
28.24773499999999870624378672800958156585693359375
],
"test_run_times": [
136.770000000000010231815394945442676544189453125,
131.349999999999994315658113919198513031005859375,
142.5,
141.900000000000005684341886080801486968994140625,
129.44999999999998863131622783839702606201171875,
135.210000000000007958078640513122081756591796875,
130.650000000000005684341886080801486968994140625,
125.2999999999999971578290569595992565155029296875,
146.330000000000012505552149377763271331787109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"bc389d3ee382bbb3b58f8a1d7ef7ae74934d33ee": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 100",
"description": "Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 1109.972999999999956344254314899444580078125,
"raw_values": [
1111.962999999999965439201332628726959228515625,
1112.10500000000001818989403545856475830078125,
1105.852000000000089130480773746967315673828125
],
"test_run_times": [
30.050000000000000710542735760100185871124267578125,
29.410000000000000142108547152020037174224853515625,
29.3599999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 2672.86400000000003274180926382541656494140625,
"raw_values": [
2840.927999999999883584678173065185546875,
2600.24699999999984356691129505634307861328125,
2652.5360000000000582076609134674072265625,
2824.53699999999980718712322413921356201171875,
2947.71199999999998908606357872486114501953125,
2837.802999999999883584678173065185546875,
2646.78900000000021464074961841106414794921875,
2669.4679999999998472048901021480560302734375,
2698.3170000000000072759576141834259033203125,
2482,
2560.7280000000000654836185276508331298828125,
2487.3350000000000363797880709171295166015625,
2588.3090000000001964508555829524993896484375,
2722.64100000000007639755494892597198486328125,
2533.60500000000001818989403545856475830078125
],
"test_run_times": [
40.52000000000000312638803734444081783294677734375,
34.8599999999999994315658113919198513031005859375,
32.969999999999998863131622783839702606201171875,
33.63000000000000255795384873636066913604736328125,
34.53999999999999914734871708787977695465087890625,
34.1099999999999994315658113919198513031005859375,
33.82000000000000028421709430404007434844970703125,
33.75,
33.88000000000000255795384873636066913604736328125,
33.4200000000000017053025658242404460906982421875,
33.27000000000000312638803734444081783294677734375,
33.61999999999999744204615126363933086395263671875,
31.96000000000000085265128291212022304534912109375,
33.530000000000001136868377216160297393798828125,
33.53999999999999914734871708787977695465087890625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 1700.223999999999932697392068803310394287109375,
"raw_values": [
1631.269000000000005456968210637569427490234375,
1692.428000000000110958353616297245025634765625,
1725.79700000000002546585164964199066162109375,
1744.32099999999991268850862979888916015625,
1816.73000000000001818989403545856475830078125,
1702.75199999999995270627550780773162841796875,
1604.90799999999990177457220852375030517578125,
1626.259000000000014551915228366851806640625,
1771.634000000000014551915228366851806640625,
1706.799999999999954525264911353588104248046875,
1812.954999999999927240423858165740966796875,
1566.829999999999927240423858165740966796875
],
"test_run_times": [
32.56000000000000227373675443232059478759765625,
31.809999999999998721023075631819665431976318359375,
31.879999999999999005240169935859739780426025390625,
32.03999999999999914734871708787977695465087890625,
31.67999999999999971578290569595992565155029296875,
32.5,
31.6700000000000017053025658242404460906982421875,
31.57000000000000028421709430404007434844970703125,
31.809999999999998721023075631819665431976318359375,
31.96000000000000085265128291212022304534912109375,
32.909999999999996589394868351519107818603515625,
30.730000000000000426325641456060111522674560546875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 2069.79300000000012005330063402652740478515625,
"raw_values": [
1411.828999999999950887286104261875152587890625,
1608.3969999999999345163814723491668701171875,
2142.69399999999995998223312199115753173828125,
2488.96999999999979991116560995578765869140625,
2156.849000000000160071067512035369873046875,
1968.98199999999997089616954326629638671875,
2322.78900000000021464074961841106414794921875,
2236.33199999999987994669936597347259521484375,
2127.063000000000101863406598567962646484375,
2299.697000000000116415321826934814453125,
1749.979000000000041836756281554698944091796875,
1974.9600000000000363797880709171295166015625,
1948.65399999999999636202119290828704833984375,
2306.329999999999927240423858165740966796875,
2303.36299999999982901499606668949127197265625
],
"test_run_times": [
34.18999999999999772626324556767940521240234375,
34.78999999999999914734871708787977695465087890625,
33.3299999999999982946974341757595539093017578125,
32.8599999999999994315658113919198513031005859375,
33.4500000000000028421709430404007434844970703125,
32.25,
32.81000000000000227373675443232059478759765625,
32.27000000000000312638803734444081783294677734375,
32.11999999999999744204615126363933086395263671875,
32.909999999999996589394868351519107818603515625,
32.74000000000000198951966012828052043914794921875,
32.47999999999999687361196265555918216705322265625,
32.25999999999999801048033987171947956085205078125,
33.27000000000000312638803734444081783294677734375,
33.00999999999999801048033987171947956085205078125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"ed4d2864cc0ec62021c7129f67cebcc86124281f": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 100",
"description": "Scaling Factor: 1 - Clients: 100 - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 90,
"raw_values": [
90.007641000000006670234142802655696868896484375,
89.983913999999998623025021515786647796630859375,
90.489428000000003748937160708010196685791015625
],
"test_run_times": [
30.050000000000000710542735760100185871124267578125,
29.410000000000000142108547152020037174224853515625,
29.3599999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 38,
"raw_values": [
35.2196339999999992187440511770546436309814453125,
38.480220000000002755768946371972560882568359375,
37.72038400000000279987943940795958042144775390625,
35.42415100000000194313543033786118030548095703125,
33.942272000000002663000486791133880615234375,
35.25923300000000182308212970383465290069580078125,
37.80387300000000294630808639340102672576904296875,
37.48146899999999703823050367645919322967529296875,
37.08108200000000209684003493748605251312255859375,
40.313682000000000016370904631912708282470703125,
39.0736720000000019581420929171144962310791015625,
40.22738199999999864076016820035874843597412109375,
38.6569089999999988549461704678833484649658203125,
36.74987800000000248701326199807226657867431640625,
39.49243200000000086902218754403293132781982421875
],
"test_run_times": [
40.52000000000000312638803734444081783294677734375,
34.8599999999999994315658113919198513031005859375,
32.969999999999998863131622783839702606201171875,
33.63000000000000255795384873636066913604736328125,
34.53999999999999914734871708787977695465087890625,
34.1099999999999994315658113919198513031005859375,
33.82000000000000028421709430404007434844970703125,
33.75,
33.88000000000000255795384873636066913604736328125,
33.4200000000000017053025658242404460906982421875,
33.27000000000000312638803734444081783294677734375,
33.61999999999999744204615126363933086395263671875,
31.96000000000000085265128291212022304534912109375,
33.530000000000001136868377216160297393798828125,
33.53999999999999914734871708787977695465087890625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 59,
"raw_values": [
61.3396970000000010259100235998630523681640625,
59.12659800000000132058630697429180145263671875,
57.980941999999998870407580398023128509521484375,
57.36651299999999764622771181166172027587890625,
55.079216999999999870851752348244190216064453125,
58.7648099999999971032593748532235622406005859375,
62.34960199999999730380295659415423870086669921875,
61.53033099999999677720552426762878894805908203125,
56.480625000000003410605131648480892181396484375,
58.626519000000001824446371756494045257568359375,
55.19590000000000173940861714072525501251220703125,
63.862617000000000189174897968769073486328125
],
"test_run_times": [
32.56000000000000227373675443232059478759765625,
31.809999999999998721023075631819665431976318359375,
31.879999999999999005240169935859739780426025390625,
32.03999999999999914734871708787977695465087890625,
31.67999999999999971578290569595992565155029296875,
32.5,
31.6700000000000017053025658242404460906982421875,
31.57000000000000028421709430404007434844970703125,
31.809999999999998721023075631819665431976318359375,
31.96000000000000085265128291212022304534912109375,
32.909999999999996589394868351519107818603515625,
30.730000000000000426325641456060111522674560546875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 49,
"raw_values": [
70.8800379999999989877323969267308712005615234375,
62.2120000000000032969182939268648624420166015625,
46.699151000000000522049958817660808563232421875,
40.202393000000000711224856786429882049560546875,
46.391672999999997273334884084761142730712890625,
50.82130200000000286308932118117809295654296875,
43.0805160000000029185684979893267154693603515625,
44.74758200000000130103217088617384433746337890625,
47.04178999999999888359525357373058795928955078125,
43.513835999999997738996171392500400543212890625,
57.18015799999999870806277613155543804168701171875,
50.66876400000000302270564134232699871063232421875,
51.35198799999999863530319998972117900848388671875,
43.3853620000000006484697223640978336334228515625,
43.4409399999999976671460899524390697479248046875
],
"test_run_times": [
34.18999999999999772626324556767940521240234375,
34.78999999999999914734871708787977695465087890625,
33.3299999999999982946974341757595539093017578125,
32.8599999999999994315658113919198513031005859375,
33.4500000000000028421709430404007434844970703125,
32.25,
32.81000000000000227373675443232059478759765625,
32.27000000000000312638803734444081783294677734375,
32.11999999999999744204615126363933086395263671875,
32.909999999999996589394868351519107818603515625,
32.74000000000000198951966012828052043914794921875,
32.47999999999999687361196265555918216705322265625,
32.25999999999999801048033987171947956085205078125,
33.27000000000000312638803734444081783294677734375,
33.00999999999999801048033987171947956085205078125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"f564d98f649cf16913fd02778b39cb7821f7cbff": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 1 -S",
"description": "Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 7.535000000000000142108547152020037174224853515625,
"raw_values": [
7.528999999999999914734871708787977695465087890625,
7.54999999999999982236431605997495353221893310546875,
7.5250000000000003552713678800500929355621337890625
],
"test_run_times": [
151.06000000000000227373675443232059478759765625,
138.19999999999998863131622783839702606201171875,
138.43000000000000682121026329696178436279296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 0.79700000000000004174438572590588591992855072021484375,
"raw_values": [
0.9939999999999999946709294817992486059665679931640625,
1.334000000000000074606987254810519516468048095703125,
1.6710000000000000408562073062057606875896453857421875,
0.323000000000000009325873406851314939558506011962890625,
0.329000000000000014654943925052066333591938018798828125,
0.321000000000000007549516567451064474880695343017578125,
0.3569999999999999840127884453977458178997039794921875,
0.319000000000000005773159728050814010202884674072265625,
1.5260000000000000230926389122032560408115386962890625
],
"test_run_times": [
185.6399999999999863575794734060764312744140625,
154.68999999999999772626324556767940521240234375,
164.8600000000000136424205265939235687255859375,
161.020000000000010231815394945442676544189453125,
147.900000000000005684341886080801486968994140625,
157.5,
149.330000000000012505552149377763271331787109375,
158.710000000000007958078640513122081756591796875,
160.599999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 17.586999999999999744204615126363933086395263671875,
"raw_values": [
16.065999999999998948396751075051724910736083984375,
16.397999999999999687361196265555918216705322265625,
17.943000000000001392663762089796364307403564453125,
18.06099999999999994315658113919198513031005859375,
18.03099999999999880628820392303168773651123046875,
18.306999999999998607336237910203635692596435546875,
19.2590000000000003410605131648480892181396484375,
16.623999999999998777866494492627680301666259765625,
17.592999999999999971578290569595992565155029296875
],
"test_run_times": [
308.81999999999999317878973670303821563720703125,
257.70999999999997953636921010911464691162109375,
258.31999999999999317878973670303821563720703125,
260.6499999999999772626324556767940521240234375,
261.42000000000001591615728102624416351318359375,
261.42000000000001591615728102624416351318359375,
266.5,
276.470000000000027284841053187847137451171875,
269.720000000000027284841053187847137451171875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 2.201000000000000067501559897209517657756805419921875,
"raw_values": [
2.54000000000000003552713678800500929355621337890625,
3.161000000000000031974423109204508364200592041015625,
2.467000000000000081712414612411521375179290771484375,
2.173999999999999932498440102790482342243194580078125,
3.463999999999999968025576890795491635799407958984375,
2.2660000000000000142108547152020037174224853515625,
2.266999999999999904076730672386474907398223876953125,
1.1229999999999999982236431605997495353221893310546875,
0.34599999999999997424282582869636826217174530029296875
],
"test_run_times": [
176.979999999999989768184605054557323455810546875,
142.5,
137,
126.2000000000000028421709430404007434844970703125,
130.330000000000012505552149377763271331787109375,
128.8899999999999863575794734060764312744140625,
131.18000000000000682121026329696178436279296875,
121.909999999999996589394868351519107818603515625,
115.8700000000000045474735088646411895751953125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 2.592000000000000081712414612411521375179290771484375,
"raw_values": [
0.51300000000000001154631945610162802040576934814453125,
1.2949999999999999289457264239899814128875732421875,
3.51100000000000012079226507921703159809112548828125,
1.1020000000000000905941988094127736985683441162109375,
2.717999999999999971578290569595992565155029296875,
7.45399999999999973709918776876293122768402099609375,
1.6060000000000000941469124882132746279239654541015625,
2.349000000000000198951966012828052043914794921875,
1.18599999999999994315658113919198513031005859375,
0.78700000000000003286260152890463359653949737548828125,
3.98200000000000020605739337042905390262603759765625,
4.60099999999999997868371792719699442386627197265625
],
"test_run_times": [
153.479999999999989768184605054557323455810546875,
135.19999999999998863131622783839702606201171875,
134.909999999999996589394868351519107818603515625,
128.25,
132.1200000000000045474735088646411895751953125,
123.8599999999999994315658113919198513031005859375,
123.7300000000000039790393202565610408782958984375,
128.580000000000012505552149377763271331787109375,
126.349999999999994315658113919198513031005859375,
118.68000000000000682121026329696178436279296875,
118.219999999999998863131622783839702606201171875,
119.7999999999999971578290569595992565155029296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"6f019859db95f2c96cd2dae1bc33b03525b66171": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 100 -c 1 -S",
"description": "Scaling Factor: 100 - Clients: 1 - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 133,
"raw_values": [
132.895994000000001733496901579201221466064453125,
132.52415400000001000080374069511890411376953125,
132.972747999999995727193891070783138275146484375
],
"test_run_times": [
151.06000000000000227373675443232059478759765625,
138.19999999999998863131622783839702606201171875,
138.43000000000000682121026329696178436279296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 2023,
"raw_values": [
1006.3222970000000486834323965013027191162109375,
749.9015859999999520368874073028564453125,
598.7522139999999808424036018550395965576171875,
3094.136707999999998719431459903717041015625,
3042.23105799999984810710884630680084228515625,
3113.435301999999865074642002582550048828125,
2805.02648799999997208942659199237823486328125,
3137.59626100000014048418961465358734130859375,
655.6550419999999803621903993189334869384765625
],
"test_run_times": [
185.6399999999999863575794734060764312744140625,
154.68999999999999772626324556767940521240234375,
164.8600000000000136424205265939235687255859375,
161.020000000000010231815394945442676544189453125,
147.900000000000005684341886080801486968994140625,
157.5,
149.330000000000012505552149377763271331787109375,
158.710000000000007958078640513122081756591796875,
160.599999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 57,
"raw_values": [
62.28196200000000004592948243953287601470947265625,
61.01505900000000082172846305184066295623779296875,
55.7640200000000021418600226752460002899169921875,
55.394981999999998834027792327105998992919921875,
55.50468399999999746796675026416778564453125,
54.65231299999999947658579912967979907989501953125,
51.973399999999998044586391188204288482666015625,
60.18808899999999795227267895825207233428955078125,
56.8756460000000032550815376453101634979248046875
],
"test_run_times": [
308.81999999999999317878973670303821563720703125,
257.70999999999997953636921010911464691162109375,
258.31999999999999317878973670303821563720703125,
260.6499999999999772626324556767940521240234375,
261.42000000000001591615728102624416351318359375,
261.42000000000001591615728102624416351318359375,
266.5,
276.470000000000027284841053187847137451171875,
269.720000000000027284841053187847137451171875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 726,
"raw_values": [
393.929969000000028245267458260059356689453125,
316.5329590000000052896211855113506317138671875,
405.667108999999982188455760478973388671875,
460.30213400000002366141416132450103759765625,
288.80603899999999839565134607255458831787109375,
441.48237499999999045030563138425350189208984375,
441.27858900000001085572876036167144775390625,
890.636997999999948660843074321746826171875,
2896.0450289999998858547769486904144287109375
],
"test_run_times": [
176.979999999999989768184605054557323455810546875,
142.5,
137,
126.2000000000000028421709430404007434844970703125,
130.330000000000012505552149377763271331787109375,
128.8899999999999863575794734060764312744140625,
131.18000000000000682121026329696178436279296875,
121.909999999999996589394868351519107818603515625,
115.8700000000000045474735088646411895751953125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 671,
"raw_values": [
1949.6198340000000825966708362102508544921875,
772.8784859999999525825842283666133880615234375,
284.94958600000001069929567165672779083251953125,
907.741447999999991225195117294788360595703125,
368.1821049999999786450644023716449737548828125,
134.24659800000000586805981583893299102783203125,
622.9503200000000333602656610310077667236328125,
426.0545829999999796200427226722240447998046875,
843.7536029999999982464942149817943572998046875,
1270.8941850000001068110577762126922607421875,
251.27915699999999787905835546553134918212890625,
217.498905000000007703420124016702175140380859375
],
"test_run_times": [
153.479999999999989768184605054557323455810546875,
135.19999999999998863131622783839702606201171875,
134.909999999999996589394868351519107818603515625,
128.25,
132.1200000000000045474735088646411895751953125,
123.8599999999999994315658113919198513031005859375,
123.7300000000000039790393202565610408782958984375,
128.580000000000012505552149377763271331787109375,
126.349999999999994315658113919198513031005859375,
118.68000000000000682121026329696178436279296875,
118.219999999999998863131622783839702606201171875,
119.7999999999999971578290569595992565155029296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"9f8b3c43bd723ecf7000cfde7936349cf8fded4e": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 50",
"description": "Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 549.816000000000030922819860279560089111328125,
"raw_values": [
547.453999999999950887286104261875152587890625,
546.73900000000003274180926382541656494140625,
555.2549999999999954525264911353588104248046875
],
"test_run_times": [
28.739999999999998436805981327779591083526611328125,
28.89999999999999857891452847979962825775146484375,
28.879999999999999005240169935859739780426025390625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 1781.767000000000052750692702829837799072265625,
"raw_values": [
1425.076999999999998181010596454143524169921875,
1675.6920000000000072759576141834259033203125,
1896.25700000000006184563972055912017822265625,
2298.14399999999977808329276740550994873046875,
1879.09099999999989449861459434032440185546875,
1453.9870000000000800355337560176849365234375,
1596.511999999999943611328490078449249267578125,
1684.046000000000049112713895738124847412109375,
1713.73000000000001818989403545856475830078125,
1959.329999999999927240423858165740966796875,
1857.642000000000052750692702829837799072265625,
1723.921000000000049112713895738124847412109375,
2010.384000000000014551915228366851806640625,
1791.212999999999965439201332628726959228515625,
1761.472999999999956344254314899444580078125
],
"test_run_times": [
33.530000000000001136868377216160297393798828125,
39.25,
35.659999999999996589394868351519107818603515625,
35.03999999999999914734871708787977695465087890625,
33.7999999999999971578290569595992565155029296875,
34.14999999999999857891452847979962825775146484375,
34.4500000000000028421709430404007434844970703125,
34.11999999999999744204615126363933086395263671875,
35.38000000000000255795384873636066913604736328125,
34.3299999999999982946974341757595539093017578125,
33.77000000000000312638803734444081783294677734375,
37.780000000000001136868377216160297393798828125,
35.8599999999999994315658113919198513031005859375,
34.68999999999999772626324556767940521240234375,
34.030000000000001136868377216160297393798828125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 103.8169999999999930651028989814221858978271484375,
"raw_values": [
149.388000000000005229594535194337368011474609375,
99.683999999999997498889570124447345733642578125,
95.2759999999999962483343551866710186004638671875,
96.1569999999999964757080306299030780792236328125,
112.018000000000000682121026329696178436279296875,
96.84399999999999408828443847596645355224609375,
104.0750000000000028421709430404007434844970703125,
112.9270000000000067075234255753457546234130859375,
95.8799999999999954525264911353588104248046875,
96.2950000000000017053025658242404460906982421875,
98.998999999999995225152815692126750946044921875,
96.0510000000000019326762412674725055694580078125,
96.025000000000005684341886080801486968994140625
],
"test_run_times": [
27,
27.60000000000000142108547152020037174224853515625,
26.870000000000000994759830064140260219573974609375,
26.8299999999999982946974341757595539093017578125,
27.010000000000001563194018672220408916473388671875,
26.8599999999999994315658113919198513031005859375,
27,
26.89999999999999857891452847979962825775146484375,
26.85000000000000142108547152020037174224853515625,
26.839999999999999857891452847979962825775146484375,
26.9200000000000017053025658242404460906982421875,
26.8900000000000005684341886080801486968994140625,
26.760000000000001563194018672220408916473388671875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 607.7849999999999681676854379475116729736328125,
"raw_values": [
441.0620000000000118234311230480670928955078125,
525.9840000000000372892827726900577545166015625,
448.23899999999997589839040301740169525146484375,
454.76799999999997226041159592568874359130859375,
448.730999999999994543031789362430572509765625,
439.16699999999997316990629769861698150634765625,
462.68400000000002592059900052845478057861328125,
677.8010000000000445652403868734836578369140625,
957.2450000000000045474735088646411895751953125,
815.517000000000052750692702829837799072265625,
878.6019999999999754436430521309375762939453125,
743.6219999999999572537490166723728179931640625
],
"test_run_times": [
29.1099999999999994315658113919198513031005859375,
28.449999999999999289457264239899814128875732421875,
29.239999999999998436805981327779591083526611328125,
29.949999999999999289457264239899814128875732421875,
28.4200000000000017053025658242404460906982421875,
29.0799999999999982946974341757595539093017578125,
29.1400000000000005684341886080801486968994140625,
28.969999999999998863131622783839702606201171875,
31.32000000000000028421709430404007434844970703125,
34.11999999999999744204615126363933086395263671875,
30.809999999999998721023075631819665431976318359375,
30.190000000000001278976924368180334568023681640625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 944.6699999999999590727384202182292938232421875,
"raw_values": [
709.421000000000049112713895738124847412109375,
1077.95299999999997453414835035800933837890625,
1040.285000000000081854523159563541412353515625,
1034.902000000000043655745685100555419921875,
935.625,
934.11400000000003274180926382541656494140625,
997.17200000000002546585164964199066162109375,
971.4690000000000509317032992839813232421875,
835.6779999999999972715158946812152862548828125,
932.5929999999999608917278237640857696533203125,
990.8329999999999699866748414933681488037109375,
1105.2629999999999199644662439823150634765625,
968.6409999999999627107172273099422454833984375,
706.1860000000000354702933691442012786865234375,
929.9109999999999445208231918513774871826171875
],
"test_run_times": [
31.6700000000000017053025658242404460906982421875,
31.39999999999999857891452847979962825775146484375,
31.760000000000001563194018672220408916473388671875,
31.410000000000000142108547152020037174224853515625,
31.699999999999999289457264239899814128875732421875,
31.089999999999999857891452847979962825775146484375,
31.3900000000000005684341886080801486968994140625,
31.339999999999999857891452847979962825775146484375,
31.719999999999998863131622783839702606201171875,
32.25999999999999801048033987171947956085205078125,
32.42999999999999971578290569595992565155029296875,
32.25,
31.339999999999999857891452847979962825775146484375,
32.090000000000003410605131648480892181396484375,
31.550000000000000710542735760100185871124267578125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"14d3ff99fba0150ff9823c3257fe3ec036f3d325": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 50",
"description": "Scaling Factor: 1 - Clients: 50 - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 91,
"raw_values": [
91.3930160000000029185684979893267154693603515625,
91.523381999999998015482560731470584869384765625,
90.119200000000006411937647499144077301025390625
],
"test_run_times": [
28.739999999999998436805981327779591083526611328125,
28.89999999999999857891452847979962825775146484375,
28.879999999999999005240169935859739780426025390625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 28,
"raw_values": [
35.10761500000000268073563347570598125457763671875,
29.856052999999999286728780134581029415130615234375,
26.3842590000000001282387529499828815460205078125,
21.76960199999999900910552241839468479156494140625,
26.624444000000000443151293438859283924102783203125,
34.40856899999999995998223312199115753173828125,
31.33792100000000147019818541593849658966064453125,
29.70706500000000005456968210637569427490234375,
29.193000000000001392663762089796364307403564453125,
25.5331019999999995206962921656668186187744140625,
26.934400000000000119371179607696831226348876953125,
29.019597000000000974750946625135838985443115234375,
24.88488699999999909096004557795822620391845703125,
27.930074999999998652810972998850047588348388671875,
28.401897000000001725084075587801635265350341796875
],
"test_run_times": [
33.530000000000001136868377216160297393798828125,
39.25,
35.659999999999996589394868351519107818603515625,
35.03999999999999914734871708787977695465087890625,
33.7999999999999971578290569595992565155029296875,
34.14999999999999857891452847979962825775146484375,
34.4500000000000028421709430404007434844970703125,
34.11999999999999744204615126363933086395263671875,
35.38000000000000255795384873636066913604736328125,
34.3299999999999982946974341757595539093017578125,
33.77000000000000312638803734444081783294677734375,
37.780000000000001136868377216160297393798828125,
35.8599999999999994315658113919198513031005859375,
34.68999999999999772626324556767940521240234375,
34.030000000000001136868377216160297393798828125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 489,
"raw_values": [
334.95319699999998874773154966533184051513671875,
501.92875199999997448685462586581707000732421875,
525.1196129999999584470060653984546661376953125,
520.3363219999999955689418129622936248779296875,
446.67233900000002222441253252327442169189453125,
516.65569800000002942397259175777435302734375,
480.7484279999999898791429586708545684814453125,
443.065869000000020605511963367462158203125,
521.8532050000000026557245291769504547119140625,
519.5763829999999643405317328870296478271484375,
505.3922019999999974970705807209014892578125,
520.8877149999999573992681689560413360595703125,
521.04329499999994368408806622028350830078125
],
"test_run_times": [
27,
27.60000000000000142108547152020037174224853515625,
26.870000000000000994759830064140260219573974609375,
26.8299999999999982946974341757595539093017578125,
27.010000000000001563194018672220408916473388671875,
26.8599999999999994315658113919198513031005859375,
27,
26.89999999999999857891452847979962825775146484375,
26.85000000000000142108547152020037174224853515625,
26.839999999999999857891452847979962825775146484375,
26.9200000000000017053025658242404460906982421875,
26.8900000000000005684341886080801486968994140625,
26.760000000000001563194018672220408916473388671875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 90,
"raw_values": [
113.4364560000000068384906626306474208831787109375,
95.1210559999999958336047711782157421112060546875,
111.62385299999999688225216232240200042724609375,
110.018013999999993757228367030620574951171875,
111.501562000000006946720532141625881195068359375,
113.930733000000003585228114388883113861083984375,
108.132959999999997080522007308900356292724609375,
73.8167270000000002028173184953629970550537109375,
52.26921999999999712827047915197908878326416015625,
61.34833400000000125373844639398157596588134765625,
56.943838999999996985934558324515819549560546875,
67.28138300000000526779331266880035400390625
],
"test_run_times": [
29.1099999999999994315658113919198513031005859375,
28.449999999999999289457264239899814128875732421875,
29.239999999999998436805981327779591083526611328125,
29.949999999999999289457264239899814128875732421875,
28.4200000000000017053025658242404460906982421875,
29.0799999999999982946974341757595539093017578125,
29.1400000000000005684341886080801486968994140625,
28.969999999999998863131622783839702606201171875,
31.32000000000000028421709430404007434844970703125,
34.11999999999999744204615126363933086395263671875,
30.809999999999998721023075631819665431976318359375,
30.190000000000001278976924368180334568023681640625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 54,
"raw_values": [
70.52929199999999809733708389103412628173828125,
46.41429000000000115733200800605118274688720703125,
48.099773999999996476617525331676006317138671875,
48.3444080000000013797034625895321369171142578125,
53.47467199999999820647644810378551483154296875,
53.5648580000000009704308467917144298553466796875,
50.1763279999999980418579070828855037689208984375,
51.50462499999999721467247582040727138519287109375,
59.86997900000000072395778261125087738037109375,
53.64806999999999703732100897468626499176025390625,
50.49099799999999760302671347744762897491455078125,
45.26532300000000219597495743073523044586181640625,
51.650430000000000063664629124104976654052734375,
70.8494630000000000791260390542447566986083984375,
53.803731999999996560291037894785404205322265625
],
"test_run_times": [
31.6700000000000017053025658242404460906982421875,
31.39999999999999857891452847979962825775146484375,
31.760000000000001563194018672220408916473388671875,
31.410000000000000142108547152020037174224853515625,
31.699999999999999289457264239899814128875732421875,
31.089999999999999857891452847979962825775146484375,
31.3900000000000005684341886080801486968994140625,
31.339999999999999857891452847979962825775146484375,
31.719999999999998863131622783839702606201171875,
32.25999999999999801048033987171947956085205078125,
32.42999999999999971578290569595992565155029296875,
32.25,
31.339999999999999857891452847979962825775146484375,
32.090000000000003410605131648480892181396484375,
31.550000000000000710542735760100185871124267578125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"2ac36170bdd6c9cb10a677bfdaf29f4a99669182": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 1",
"description": "Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 10.833999999999999630517777404747903347015380859375,
"raw_values": [
10.8450000000000006394884621840901672840118408203125,
10.7780000000000004689582056016661226749420166015625,
10.8789999999999995594635038287378847599029541015625
],
"test_run_times": [
28.190000000000001278976924368180334568023681640625,
28.190000000000001278976924368180334568023681640625,
28.260000000000001563194018672220408916473388671875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 32.875,
"raw_values": [
25.998000000000001108446667785756289958953857421875,
33.421999999999997044142219237983226776123046875,
31.272999999999999687361196265555918216705322265625,
29.544000000000000483169060316868126392364501953125,
35.2740000000000009094947017729282379150390625,
37.5619999999999976125764078460633754730224609375,
28.1640000000000014779288903810083866119384765625,
36.5240000000000009094947017729282379150390625,
38.9759999999999990905052982270717620849609375,
37.0739999999999980673237587325274944305419921875,
32.60300000000000153477230924181640148162841796875,
35.28399999999999891997504164464771747589111328125,
26.66100000000000136424205265939235687255859375,
28.382999999999999118927007657475769519805908203125,
36.37599999999999766941982670687139034271240234375
],
"test_run_times": [
38.27000000000000312638803734444081783294677734375,
34.159999999999996589394868351519107818603515625,
34.8599999999999994315658113919198513031005859375,
34.36999999999999744204615126363933086395263671875,
33.5,
35.8900000000000005684341886080801486968994140625,
38.36999999999999744204615126363933086395263671875,
31.969999999999998863131622783839702606201171875,
33.969999999999998863131622783839702606201171875,
33.0799999999999982946974341757595539093017578125,
35.4200000000000017053025658242404460906982421875,
34.78999999999999914734871708787977695465087890625,
31.760000000000001563194018672220408916473388671875,
32.030000000000001136868377216160297393798828125,
33.8599999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 5.58199999999999985078602549037896096706390380859375,
"raw_values": [
11.44500000000000028421709430404007434844970703125,
12.356999999999999317878973670303821563720703125,
12.2479999999999993320898283855058252811431884765625,
3.7469999999999998863131622783839702606201171875,
3.57200000000000006394884621840901672840118408203125,
2.903999999999999914734871708787977695465087890625,
3.672000000000000152766688188421539962291717529296875,
3.44099999999999983657517077517695724964141845703125,
3.29999999999999982236431605997495353221893310546875,
3.560000000000000053290705182007513940334320068359375,
3.35099999999999997868371792719699442386627197265625,
3.38600000000000012079226507921703159809112548828125
],
"test_run_times": [
27.839999999999999857891452847979962825775146484375,
33.1099999999999994315658113919198513031005859375,
31.3900000000000005684341886080801486968994140625,
27.980000000000000426325641456060111522674560546875,
26.699999999999999289457264239899814128875732421875,
26.620000000000000994759830064140260219573974609375,
26.800000000000000710542735760100185871124267578125,
26.809999999999998721023075631819665431976318359375,
26.67999999999999971578290569595992565155029296875,
27.35000000000000142108547152020037174224853515625,
27.35000000000000142108547152020037174224853515625,
27.559999999999998721023075631819665431976318359375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 14.7449999999999992184029906638897955417633056640625,
"raw_values": [
12.0020000000000006679101716144941747188568115234375,
17.58500000000000085265128291212022304534912109375,
16.89699999999999846522769075818359851837158203125,
17.071999999999999175770426518283784389495849609375,
15.8100000000000004973799150320701301097869873046875,
12.94500000000000028421709430404007434844970703125,
13.8149999999999995026200849679298698902130126953125,
12.8269999999999999573674358543939888477325439453125,
14.3559999999999998721023075631819665431976318359375,
13.9610000000000002984279490192420780658721923828125,
17.132999999999999118927007657475769519805908203125,
12.6159999999999996589394868351519107818603515625,
13.4350000000000004973799150320701301097869873046875,
16.469999999999998863131622783839702606201171875,
14.2550000000000007815970093361102044582366943359375
],
"test_run_times": [
31.10000000000000142108547152020037174224853515625,
30.410000000000000142108547152020037174224853515625,
31.53999999999999914734871708787977695465087890625,
32.9200000000000017053025658242404460906982421875,
29.019999999999999573674358543939888477325439453125,
31.230000000000000426325641456060111522674560546875,
30.300000000000000710542735760100185871124267578125,
30.690000000000001278976924368180334568023681640625,
29.32000000000000028421709430404007434844970703125,
32.2999999999999971578290569595992565155029296875,
29.309999999999998721023075631819665431976318359375,
29.660000000000000142108547152020037174224853515625,
29.82000000000000028421709430404007434844970703125,
30.3900000000000005684341886080801486968994140625,
30.21000000000000085265128291212022304534912109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 17.14399999999999835154085303656756877899169921875,
"raw_values": [
12.1790000000000002700062395888380706310272216796875,
16.839999999999999857891452847979962825775146484375,
17.992000000000000881072992342524230480194091796875,
15.742000000000000881072992342524230480194091796875,
19.769999999999999573674358543939888477325439453125,
21.88700000000000045474735088646411895751953125,
17.09700000000000130739863379858434200286865234375,
15.69200000000000017053025658242404460906982421875,
14.79899999999999948840923025272786617279052734375,
15.82900000000000062527760746888816356658935546875,
16.46600000000000108002495835535228252410888671875,
17.855000000000000426325641456060111522674560546875,
18.001999999999998891553332214243710041046142578125,
16.16799999999999926103555480949580669403076171875,
20.8479999999999989768184605054557323455810546875
],
"test_run_times": [
30.879999999999999005240169935859739780426025390625,
30.660000000000000142108547152020037174224853515625,
30.46000000000000085265128291212022304534912109375,
30.510000000000001563194018672220408916473388671875,
32.02000000000000312638803734444081783294677734375,
32.5799999999999982946974341757595539093017578125,
31.940000000000001278976924368180334568023681640625,
30.1099999999999994315658113919198513031005859375,
30.8599999999999994315658113919198513031005859375,
31.370000000000000994759830064140260219573974609375,
29.699999999999999289457264239899814128875732421875,
31.620000000000000994759830064140260219573974609375,
30.28999999999999914734871708787977695465087890625,
31.53999999999999914734871708787977695465087890625,
31.839999999999999857891452847979962825775146484375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"5b8ce179a47d4180fa20fc56acdca758a763a82e": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 1",
"description": "Scaling Factor: 1 - Clients: 1 - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 92,
"raw_values": [
92.255684999999999718056642450392246246337890625,
92.8284330000000039717633626423776149749755859375,
91.966464000000001988155418075621128082275390625
],
"test_run_times": [
28.190000000000001278976924368180334568023681640625,
28.190000000000001278976924368180334568023681640625,
28.260000000000001563194018672220408916473388671875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 31,
"raw_values": [
38.482405999999997447957866825163364410400390625,
29.93337999999999965439201332628726959228515625,
31.99002399999999823876351001672446727752685546875,
33.86410000000000053432813729159533977508544921875,
28.363506000000000994987203739583492279052734375,
26.634403999999999967940311762504279613494873046875,
35.52442099999999669535100110806524753570556640625,
27.39260900000000020781953935511410236358642578125,
25.669329999999998648263499489985406398773193359375,
26.985392000000000933823685045354068279266357421875,
30.684749000000000052068571676500141620635986328125,
28.35309300000000121144694276154041290283203125,
37.52619200000000176942194229923188686370849609375,
35.24965499999999707370079704560339450836181640625,
27.50398200000000059617377701215445995330810546875
],
"test_run_times": [
38.27000000000000312638803734444081783294677734375,
34.159999999999996589394868351519107818603515625,
34.8599999999999994315658113919198513031005859375,
34.36999999999999744204615126363933086395263671875,
33.5,
35.8900000000000005684341886080801486968994140625,
38.36999999999999744204615126363933086395263671875,
31.969999999999998863131622783839702606201171875,
33.969999999999998863131622783839702606201171875,
33.0799999999999982946974341757595539093017578125,
35.4200000000000017053025658242404460906982421875,
34.78999999999999914734871708787977695465087890625,
31.760000000000001563194018672220408916473388671875,
32.030000000000001136868377216160297393798828125,
33.8599999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 240,
"raw_values": [
87.4154549999999943565853754989802837371826171875,
80.9669489999999996143742464482784271240234375,
81.694916000000006306436262093484401702880859375,
267.02285000000000536601874046027660369873046875,
280.0835809999999810315784998238086700439453125,
344.50044200000002092565409839153289794921875,
272.48714400000000068757799454033374786376953125,
290.748659999999972569639794528484344482421875,
303.1694830000000138170435093343257904052734375,
281.0143150000000105137587524950504302978515625,
298.5961710000000266518327407538890838623046875,
295.492657000000008338247425854206085205078125
],
"test_run_times": [
27.839999999999999857891452847979962825775146484375,
33.1099999999999994315658113919198513031005859375,
31.3900000000000005684341886080801486968994140625,
27.980000000000000426325641456060111522674560546875,
26.699999999999999289457264239899814128875732421875,
26.620000000000000994759830064140260219573974609375,
26.800000000000000710542735760100185871124267578125,
26.809999999999998721023075631819665431976318359375,
26.67999999999999971578290569595992565155029296875,
27.35000000000000142108547152020037174224853515625,
27.35000000000000142108547152020037174224853515625,
27.559999999999998721023075631819665431976318359375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 69,
"raw_values": [
83.3866459999999989349817042239010334014892578125,
56.88873699999999900001057540066540241241455078125,
59.215069999999997207851265557110309600830078125,
58.6045400000000000773070496506989002227783203125,
63.27718800000000243244357989169657230377197265625,
77.2879219999999946821844787336885929107666015625,
72.4171060000000039735823520459234714508056640625,
78.0041729999999944311639410443603992462158203125,
69.6922220000000010031726560555398464202880859375,
71.66762199999999438659870065748691558837890625,
58.3954149999999998499333742074668407440185546875,
79.3041979999999995243342709727585315704345703125,
74.470517000000000962245394475758075714111328125,
60.749065000000001646185410209000110626220703125,
70.1839829999999977871993905864655971527099609375
],
"test_run_times": [
31.10000000000000142108547152020037174224853515625,
30.410000000000000142108547152020037174224853515625,
31.53999999999999914734871708787977695465087890625,
32.9200000000000017053025658242404460906982421875,
29.019999999999999573674358543939888477325439453125,
31.230000000000000426325641456060111522674560546875,
30.300000000000000710542735760100185871124267578125,
30.690000000000001278976924368180334568023681640625,
29.32000000000000028421709430404007434844970703125,
32.2999999999999971578290569595992565155029296875,
29.309999999999998721023075631819665431976318359375,
29.660000000000000142108547152020037174224853515625,
29.82000000000000028421709430404007434844970703125,
30.3900000000000005684341886080801486968994140625,
30.21000000000000085265128291212022304534912109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 59,
"raw_values": [
82.147456000000005360561772249639034271240234375,
59.41693099999999816418494447134435176849365234375,
55.61000200000000148747858474962413311004638671875,
63.5511359999999996261976775713264942169189453125,
50.6069269999999988840500009246170520782470703125,
45.7083879999999993515302776359021663665771484375,
58.52311900000000122190613183192908763885498046875,
63.7631659999999982346707838587462902069091796875,
67.602226999999999179635779000818729400634765625,
63.20357800000000025875124265439808368682861328125,
60.760255999999998266503098420798778533935546875,
56.03223799999999954479790176264941692352294921875,
55.573025000000001227817847393453121185302734375,
61.88166799999999767578628961928188800811767578125,
47.9865319999999968558768159709870815277099609375
],
"test_run_times": [
30.879999999999999005240169935859739780426025390625,
30.660000000000000142108547152020037174224853515625,
30.46000000000000085265128291212022304534912109375,
30.510000000000001563194018672220408916473388671875,
32.02000000000000312638803734444081783294677734375,
32.5799999999999982946974341757595539093017578125,
31.940000000000001278976924368180334568023681640625,
30.1099999999999994315658113919198513031005859375,
30.8599999999999994315658113919198513031005859375,
31.370000000000000994759830064140260219573974609375,
29.699999999999999289457264239899814128875732421875,
31.620000000000000994759830064140260219573974609375,
30.28999999999999914734871708787977695465087890625,
31.53999999999999914734871708787977695465087890625,
31.839999999999999857891452847979962825775146484375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"90d6249f544c1287dd70550b1a0661b9528425ba": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 1 -S",
"description": "Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency",
"scale": "ms",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 0.194000000000000005773159728050814010202884674072265625,
"raw_values": [
0.194000000000000005773159728050814010202884674072265625,
0.24099999999999999200639422269887290894985198974609375,
0.2129999999999999948929740867242799140512943267822265625,
0.2190000000000000002220446049250313080847263336181640625,
0.1640000000000000068833827526759705506265163421630859375,
0.199000000000000010214051826551440171897411346435546875,
0.2139999999999999957811525064244051463901996612548828125,
0.1419999999999999873434575192732154391705989837646484375,
0.1419999999999999873434575192732154391705989837646484375,
0.2139999999999999957811525064244051463901996612548828125,
0.185999999999999998667732370449812151491641998291015625,
0.2039999999999999868993683094231528230011463165283203125
],
"test_run_times": [
32.2999999999999971578290569595992565155029296875,
28.219999999999998863131622783839702606201171875,
28.35000000000000142108547152020037174224853515625,
28.129999999999999005240169935859739780426025390625,
28.269999999999999573674358543939888477325439453125,
28.219999999999998863131622783839702606201171875,
28.32000000000000028421709430404007434844970703125,
28.1700000000000017053025658242404460906982421875,
28.1400000000000005684341886080801486968994140625,
28.589999999999999857891452847979962825775146484375,
28.309999999999998721023075631819665431976318359375,
28.32000000000000028421709430404007434844970703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 0.24699999999999999733546474089962430298328399658203125,
"raw_values": [
0.24499999999999999555910790149937383830547332763671875,
0.2479999999999999982236431605997495353221893310546875,
0.2479999999999999982236431605997495353221893310546875
],
"test_run_times": [
39.47999999999999687361196265555918216705322265625,
33.43999999999999772626324556767940521240234375,
32.8599999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 0.182999999999999996003197111349436454474925994873046875,
"raw_values": [
0.193000000000000004884981308350688777863979339599609375,
0.13300000000000000710542735760100185871124267578125,
0.1620000000000000051070259132757200859487056732177734375,
0.182999999999999996003197111349436454474925994873046875,
0.13400000000000000799360577730112709105014801025390625,
0.1570000000000000006661338147750939242541790008544921875,
0.195000000000000006661338147750939242541790008544921875,
0.1479999999999999926725280374739668332040309906005859375,
0.186999999999999999555910790149937383830547332763671875,
0.201000000000000011990408665951690636575222015380859375,
0.2099999999999999922284388276239042170345783233642578125,
0.2439999999999999946709294817992486059665679931640625,
0.2039999999999999868993683094231528230011463165283203125,
0.2169999999999999984456877655247808434069156646728515625,
0.178999999999999992450483432548935525119304656982421875
],
"test_run_times": [
45.11999999999999744204615126363933086395263671875,
32.86999999999999744204615126363933086395263671875,
31.809999999999998721023075631819665431976318359375,
32.1700000000000017053025658242404460906982421875,
31.28999999999999914734871708787977695465087890625,
29.60000000000000142108547152020037174224853515625,
38.530000000000001136868377216160297393798828125,
32.9500000000000028421709430404007434844970703125,
37.03999999999999914734871708787977695465087890625,
30.129999999999999005240169935859739780426025390625,
32.68999999999999772626324556767940521240234375,
29.910000000000000142108547152020037174224853515625,
29.489999999999998436805981327779591083526611328125,
31.75,
29.82000000000000028421709430404007434844970703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 0.200000000000000011102230246251565404236316680908203125,
"raw_values": [
0.2119999999999999940047956670241546817123889923095703125,
0.174999999999999988897769753748434595763683319091796875,
0.193000000000000004884981308350688777863979339599609375,
0.1489999999999999935607064571740920655429363250732421875,
0.1559999999999999997779553950749686919152736663818359375,
0.171999999999999986233234494648058898746967315673828125,
0.1549999999999999988897769753748434595763683319091796875,
0.2169999999999999984456877655247808434069156646728515625,
0.245999999999999996447286321199499070644378662109375,
0.293999999999999983568699235547683201730251312255859375,
0.177999999999999991562305012848810292780399322509765625,
0.2520000000000000017763568394002504646778106689453125
],
"test_run_times": [
31.5,
31.059999999999998721023075631819665431976318359375,
30.010000000000001563194018672220408916473388671875,
30.480000000000000426325641456060111522674560546875,
30.469999999999998863131622783839702606201171875,
29.660000000000000142108547152020037174224853515625,
30.010000000000001563194018672220408916473388671875,
31.309999999999998721023075631819665431976318359375,
30.120000000000000994759830064140260219573974609375,
29.6700000000000017053025658242404460906982421875,
29.730000000000000426325641456060111522674560546875,
31.32000000000000028421709430404007434844970703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 0.25700000000000000621724893790087662637233734130859375,
"raw_values": [
0.299999999999999988897769753748434595763683319091796875,
0.321000000000000007549516567451064474880695343017578125,
0.27300000000000002042810365310288034379482269287109375,
0.26900000000000001687538997430237941443920135498046875,
0.23899999999999999023003738329862244427204132080078125,
0.192000000000000003996802888650563545525074005126953125,
0.181999999999999995115018691649311222136020660400390625,
0.298999999999999988009591334048309363424777984619140625,
0.281999999999999972910558199146180413663387298583984375,
0.2640000000000000124344978758017532527446746826171875,
0.24899999999999999911182158029987476766109466552734375,
0.2190000000000000002220446049250313080847263336181640625
],
"test_run_times": [
34.18999999999999772626324556767940521240234375,
30.17999999999999971578290569595992565155029296875,
30.82000000000000028421709430404007434844970703125,
30.230000000000000426325641456060111522674560546875,
29.690000000000001278976924368180334568023681640625,
30.4200000000000017053025658242404460906982421875,
30.489999999999998436805981327779591083526611328125,
29.9200000000000017053025658242404460906982421875,
30.980000000000000426325641456060111522674560546875,
30.300000000000000710542735760100185871124267578125,
30.620000000000000994759830064140260219573974609375,
30.46000000000000085265128291212022304534912109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
},
"2f1bfa9ab6158444920a2c0fe43a59a0a0e4e6ea": {
"identifier": "pts\/pgbench-1.10.1",
"title": "PostgreSQL pgbench",
"app_version": "13.0",
"arguments": "-s 1 -c 1 -S",
"description": "Scaling Factor: 1 - Clients: 1 - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"DB performance by FS: SATA variable rpm HD with ext4": {
"value": 5286,
"raw_values": [
5150.793937000000369152985513210296630859375,
4159.880992000000333064235746860504150390625,
4707.6629579999998895800672471523284912109375,
4569.7595780000001468579284846782684326171875,
6104.477608999999574734829366207122802734375,
5026.5009749999999257852323353290557861328125,
4683.122341000000233179889619350433349609375,
7022.8734949999998207204043865203857421875,
7035.764092999999775202013552188873291015625,
4675.094226999999591498635709285736083984375,
5373.3632410000000163563527166843414306640625,
4917.0829480000002149608917534351348876953125
],
"test_run_times": [
32.2999999999999971578290569595992565155029296875,
28.219999999999998863131622783839702606201171875,
28.35000000000000142108547152020037174224853515625,
28.129999999999999005240169935859739780426025390625,
28.269999999999999573674358543939888477325439453125,
28.219999999999998863131622783839702606201171875,
28.32000000000000028421709430404007434844970703125,
28.1700000000000017053025658242404460906982421875,
28.1400000000000005684341886080801486968994140625,
28.589999999999999857891452847979962825775146484375,
28.309999999999998721023075631819665431976318359375,
28.32000000000000028421709430404007434844970703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: Btrfs on 7200rpm SAS drive": {
"value": 4054,
"raw_values": [
4089.351633000000219908542931079864501953125,
4031.96001200000000608270056545734405517578125,
4040.94260900000017500133253633975982666015625
],
"test_run_times": [
39.47999999999999687361196265555918216705322265625,
33.43999999999999772626324556767940521240234375,
32.8599999999999994315658113919198513031005859375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4": {
"value": 5622,
"raw_values": [
5177.974688000000242027454078197479248046875,
7511.8154100000001562875695526599884033203125,
6177.4612370000004375469870865345001220703125,
5453.997930999999880441464483737945556640625,
7466.4304060000004028552211821079254150390625,
6359.69215199999962351284921169281005859375,
5130.4877520000000004074536263942718505859375,
6771.9152679999997417326085269451141357421875,
5340.612959000000046216882765293121337890625,
4987.30522399999972549267113208770751953125,
4761.8547250000001440639607608318328857421875,
4100.803178000000116298906505107879638671875,
4900.900345000000015716068446636199951171875,
4604.3155020000003787572495639324188232421875,
5589.55170100000032107345759868621826171875
],
"test_run_times": [
45.11999999999999744204615126363933086395263671875,
32.86999999999999744204615126363933086395263671875,
31.809999999999998721023075631819665431976318359375,
32.1700000000000017053025658242404460906982421875,
31.28999999999999914734871708787977695465087890625,
29.60000000000000142108547152020037174224853515625,
38.530000000000001136868377216160297393798828125,
32.9500000000000028421709430404007434844970703125,
37.03999999999999914734871708787977695465087890625,
30.129999999999999005240169935859739780426025390625,
32.68999999999999772626324556767940521240234375,
29.910000000000000142108547152020037174224853515625,
29.489999999999998436805981327779591083526611328125,
31.75,
29.82000000000000028421709430404007434844970703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS": {
"value": 5223,
"raw_values": [
4721.9679910000004383618943393230438232421875,
5727.9096170000002530287019908428192138671875,
5175.2890340000003561726771295070648193359375,
6709.6741599999995742109604179859161376953125,
6412.560408999999708612449467182159423828125,
5813.21990100000039092265069484710693359375,
6453.5342449999998279963620007038116455078125,
4603.892316999999820836819708347320556640625,
4075.2037620000000970321707427501678466796875,
3401.80049000000008163624443113803863525390625,
5616.3783299999995506368577480316162109375,
3969.674716999999873223714530467987060546875
],
"test_run_times": [
31.5,
31.059999999999998721023075631819665431976318359375,
30.010000000000001563194018672220408916473388671875,
30.480000000000000426325641456060111522674560546875,
30.469999999999998863131622783839702606201171875,
29.660000000000000142108547152020037174224853515625,
30.010000000000001563194018672220408916473388671875,
31.309999999999998721023075631819665431976318359375,
30.120000000000000994759830064140260219573974609375,
29.6700000000000017053025658242404460906982421875,
29.730000000000000426325641456060111522674560546875,
31.32000000000000028421709430404007434844970703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
},
"USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib": {
"value": 4000,
"raw_values": [
3335.66913100000010672374628484249114990234375,
3119.63674200000014025135897099971771240234375,
3660.9606290000001536100171506404876708984375,
3724.31551499999977750121615827083587646484375,
4180.5073199999997086706571280956268310546875,
5217.86023500000010244548320770263671875,
5501.2931440000002112356014549732208251953125,
3349.245492000000012922100722789764404296875,
3550.89869899999985136673785746097564697265625,
3784.93527899999980945722199976444244384765625,
4013.019134000000121886841952800750732421875,
4563.08948500000042258761823177337646484375
],
"test_run_times": [
34.18999999999999772626324556767940521240234375,
30.17999999999999971578290569595992565155029296875,
30.82000000000000028421709430404007434844970703125,
30.230000000000000426325641456060111522674560546875,
29.690000000000001278976924368180334568023681640625,
30.4200000000000017053025658242404460906982421875,
30.489999999999998436805981327779591083526611328125,
29.9200000000000017053025658242404460906982421875,
30.980000000000000426325641456060111522674560546875,
30.300000000000000710542735760100185871124267578125,
30.620000000000000994759830064140260219573974609375,
30.46000000000000085265128291212022304534912109375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm"
}
}
}
}
}
}
}