20211003001-pgbench-tumbes-debian Debian pts/pgbench test
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2110037-JUAN-202110011 20211003001-pgbench-tumbes-debian Processor: 2 x AMD EPYC 7453 28-Core @ 2.75GHz (56 Cores / 112 Threads), Motherboard: Supermicro H12DSU-iN v1.01 (2.1 BIOS), Chipset: AMD Starship/Matisse, Memory: 16 x 64 GB DDR4-3200MT/s HMAA8GR7AJR4N-XN, Disk: 15361GB KCM6XRUL15T3 + 2 x 960GB INTEL SSDSC2KB96 + 7 x 18000GB WUH721818AL5204, Graphics: ASPEED, Network: 2 x Intel X710 for 10GBASE-T + 2 x Mellanox MT27710
OS: Debian 11, Kernel: 5.10.0-8-amd64 (x86_64), Vulkan: 1.0.2, Compiler: GCC 10.2.1 20210110, File-System: xfs, Screen Resolution: 1024x768
Kernel Notes: Transparent Huge Pages: alwaysCompiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-mutex --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-gcn/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -vProcessor Notes: Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0xa00111dSecurity Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional IBRS_FW STIBP: always-on RSB filling + srbds: Not affected + tsx_async_abort: Not affected
20211003001-pgbench-tumbes-debian OpenBenchmarking.org Phoronix Test Suite 2 x AMD EPYC 7453 28-Core @ 2.75GHz (56 Cores / 112 Threads) Supermicro H12DSU-iN v1.01 (2.1 BIOS) AMD Starship/Matisse 16 x 64 GB DDR4-3200MT/s HMAA8GR7AJR4N-XN 15361GB KCM6XRUL15T3 + 2 x 960GB INTEL SSDSC2KB96 + 7 x 18000GB WUH721818AL5204 ASPEED 2 x Intel X710 for 10GBASE-T + 2 x Mellanox MT27710 Debian 11 5.10.0-8-amd64 (x86_64) 1.0.2 GCC 10.2.1 20210110 xfs 1024x768 Processor Motherboard Chipset Memory Disk Graphics Network OS Kernel Vulkan Compiler File-System Screen Resolution 20211003001-pgbench-tumbes-debian Benchmarks System Logs - Transparent Huge Pages: always - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-mutex --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-gcn/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0xa00111d - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional IBRS_FW STIBP: always-on RSB filling + srbds: Not affected + tsx_async_abort: Not affected
20211003001-pgbench-tumbes-debian pgbench: 1 - 1 - Read Only pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Write pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 50 - Read Only pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 100 - Read Only pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 250 - Read Only pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 500 - Read Only pgbench: 1 - 500 - Read Only - Average Latency pgbench: 100 - 1 - Read Only pgbench: 100 - 1 - Read Only - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 250 - Read Write pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 500 - Read Write pgbench: 1 - 500 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 50 - Read Only pgbench: 100 - 50 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 250 - Read Only pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 50 - Read Write pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 500 - Read Only pgbench: 100 - 500 - Read Only - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 100 - 100 - Read Write pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 250 - Read Write pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 500 - Read Write pgbench: 100 - 500 - Read Write - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 250 - Read Only pgbench: 1000 - 250 - Read Only - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 500 - Read Only pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 250 - Read Write pgbench: 1000 - 250 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write pgbench: 1000 - 500 - Read Write - Average Latency 20211003001-pgbench-tumbes-debian 29134 0.034 1822 0.549 924859 0.054 1427916 0.070 1614761 0.155 631 80.784 1673899 0.299 27009 0.037 516 200.381 853 293.716 451 1168.940 1490 0.671 900530 0.056 22941 0.044 1462333 0.069 1587837 0.157 11264 4.441 1538268 0.325 1468 0.681 793870 0.063 12634 7.923 14210 17.599 14800 34.152 1224311 0.082 961572 0.260 7285 6.863 773103 0.647 10030 9.970 8408 29.739 7336 68.186 OpenBenchmarking.org
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0077 0.0154 0.0231 0.0308 0.0385 SE +/- 0.000, N = 3 0.034 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write 20211003001-pgbench-tumbes-debian 400 800 1200 1600 2000 SE +/- 8.79, N = 3 1822 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 0.1235 0.247 0.3705 0.494 0.6175 SE +/- 0.003, N = 3 0.549 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only 20211003001-pgbench-tumbes-debian 200K 400K 600K 800K 1000K SE +/- 2366.99, N = 3 924859 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0122 0.0244 0.0366 0.0488 0.061 SE +/- 0.000, N = 3 0.054 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only 20211003001-pgbench-tumbes-debian 300K 600K 900K 1200K 1500K SE +/- 10647.35, N = 12 1427916 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0158 0.0316 0.0474 0.0632 0.079 SE +/- 0.001, N = 12 0.070 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only 20211003001-pgbench-tumbes-debian 300K 600K 900K 1200K 1500K SE +/- 16583.32, N = 12 1614761 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0349 0.0698 0.1047 0.1396 0.1745 SE +/- 0.002, N = 12 0.155 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write 20211003001-pgbench-tumbes-debian 140 280 420 560 700 SE +/- 28.00, N = 9 631 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 20 40 60 80 100 SE +/- 4.26, N = 9 80.78 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only 20211003001-pgbench-tumbes-debian 400K 800K 1200K 1600K 2000K SE +/- 4945.27, N = 3 1673899 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0673 0.1346 0.2019 0.2692 0.3365 SE +/- 0.001, N = 3 0.299 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only 20211003001-pgbench-tumbes-debian 6K 12K 18K 24K 30K SE +/- 170.31, N = 3 27009 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0083 0.0166 0.0249 0.0332 0.0415 SE +/- 0.000, N = 3 0.037 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write 20211003001-pgbench-tumbes-debian 110 220 330 440 550 SE +/- 25.80, N = 12 516 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 40 80 120 160 200 SE +/- 12.35, N = 12 200.38 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write 20211003001-pgbench-tumbes-debian 200 400 600 800 1000 SE +/- 12.13, N = 12 853 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 60 120 180 240 300 SE +/- 4.29, N = 12 293.72 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write 20211003001-pgbench-tumbes-debian 100 200 300 400 500 SE +/- 30.91, N = 12 451 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 300 600 900 1200 1500 SE +/- 80.71, N = 12 1168.94 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write 20211003001-pgbench-tumbes-debian 300 600 900 1200 1500 SE +/- 17.86, N = 3 1490 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 0.151 0.302 0.453 0.604 0.755 SE +/- 0.008, N = 3 0.671 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only 20211003001-pgbench-tumbes-debian 200K 400K 600K 800K 1000K SE +/- 12563.58, N = 3 900530 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0126 0.0252 0.0378 0.0504 0.063 SE +/- 0.001, N = 3 0.056 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only 20211003001-pgbench-tumbes-debian 5K 10K 15K 20K 25K SE +/- 293.43, N = 9 22941 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0099 0.0198 0.0297 0.0396 0.0495 SE +/- 0.001, N = 9 0.044 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only 20211003001-pgbench-tumbes-debian 300K 600K 900K 1200K 1500K SE +/- 5665.39, N = 3 1462333 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0155 0.031 0.0465 0.062 0.0775 SE +/- 0.000, N = 3 0.069 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only 20211003001-pgbench-tumbes-debian 300K 600K 900K 1200K 1500K SE +/- 4065.06, N = 3 1587837 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0353 0.0706 0.1059 0.1412 0.1765 SE +/- 0.000, N = 3 0.157 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write 20211003001-pgbench-tumbes-debian 2K 4K 6K 8K 10K SE +/- 122.17, N = 4 11264 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 0.9992 1.9984 2.9976 3.9968 4.996 SE +/- 0.049, N = 4 4.441 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only 20211003001-pgbench-tumbes-debian 300K 600K 900K 1200K 1500K SE +/- 3425.13, N = 3 1538268 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0731 0.1462 0.2193 0.2924 0.3655 SE +/- 0.001, N = 3 0.325 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write 20211003001-pgbench-tumbes-debian 300 600 900 1200 1500 SE +/- 18.35, N = 3 1468 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 0.1532 0.3064 0.4596 0.6128 0.766 SE +/- 0.008, N = 3 0.681 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only 20211003001-pgbench-tumbes-debian 200K 400K 600K 800K 1000K SE +/- 4084.40, N = 3 793870 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0142 0.0284 0.0426 0.0568 0.071 SE +/- 0.001, N = 3 0.063 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write 20211003001-pgbench-tumbes-debian 3K 6K 9K 12K 15K SE +/- 122.45, N = 12 12634 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 2 4 6 8 10 SE +/- 0.077, N = 12 7.923 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write 20211003001-pgbench-tumbes-debian 3K 6K 9K 12K 15K SE +/- 178.47, N = 3 14210 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 4 8 12 16 20 SE +/- 0.22, N = 3 17.60 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Write 20211003001-pgbench-tumbes-debian 3K 6K 9K 12K 15K SE +/- 490.39, N = 12 14800 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 8 16 24 32 40 SE +/- 1.01, N = 12 34.15 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only 20211003001-pgbench-tumbes-debian 300K 600K 900K 1200K 1500K SE +/- 1461.80, N = 3 1224311 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0185 0.037 0.0555 0.074 0.0925 SE +/- 0.000, N = 3 0.082 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only 20211003001-pgbench-tumbes-debian 200K 400K 600K 800K 1000K SE +/- 6204.99, N = 3 961572 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.0585 0.117 0.1755 0.234 0.2925 SE +/- 0.002, N = 3 0.260 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write 20211003001-pgbench-tumbes-debian 1600 3200 4800 6400 8000 SE +/- 36.60, N = 3 7285 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 2 4 6 8 10 SE +/- 0.034, N = 3 6.863 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only 20211003001-pgbench-tumbes-debian 170K 340K 510K 680K 850K SE +/- 10377.16, N = 3 773103 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency 20211003001-pgbench-tumbes-debian 0.1456 0.2912 0.4368 0.5824 0.728 SE +/- 0.009, N = 3 0.647 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write 20211003001-pgbench-tumbes-debian 2K 4K 6K 8K 10K SE +/- 23.62, N = 3 10030 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 3 6 9 12 15 SE +/- 0.024, N = 3 9.970 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write 20211003001-pgbench-tumbes-debian 2K 4K 6K 8K 10K SE +/- 81.32, N = 3 8408 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 7 14 21 28 35 SE +/- 0.29, N = 3 29.74 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write 20211003001-pgbench-tumbes-debian 1600 3200 4800 6400 8000 SE +/- 87.33, N = 4 7336 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency 20211003001-pgbench-tumbes-debian 15 30 45 60 75 SE +/- 0.82, N = 4 68.19 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
20211003001-pgbench-tumbes-debian Processor: 2 x AMD EPYC 7453 28-Core @ 2.75GHz (56 Cores / 112 Threads), Motherboard: Supermicro H12DSU-iN v1.01 (2.1 BIOS), Chipset: AMD Starship/Matisse, Memory: 16 x 64 GB DDR4-3200MT/s HMAA8GR7AJR4N-XN, Disk: 15361GB KCM6XRUL15T3 + 2 x 960GB INTEL SSDSC2KB96 + 7 x 18000GB WUH721818AL5204, Graphics: ASPEED, Network: 2 x Intel X710 for 10GBASE-T + 2 x Mellanox MT27710
OS: Debian 11, Kernel: 5.10.0-8-amd64 (x86_64), Vulkan: 1.0.2, Compiler: GCC 10.2.1 20210110, File-System: xfs, Screen Resolution: 1024x768
Kernel Notes: Transparent Huge Pages: alwaysCompiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-mutex --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-gcn/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -vProcessor Notes: Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0xa00111dSecurity Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional IBRS_FW STIBP: always-on RSB filling + srbds: Not affected + tsx_async_abort: Not affected
Testing initiated at 3 October 2021 00:20 by user juanjoant.