postgesql Xeon Ice Lake 2 x Intel Xeon Platinum 8380 testing with a Intel M50CYP2SB2U (SE5C6200.86B.0022.D08.2103221623 BIOS) and ASPEED on Ubuntu 20.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2105049-IB-POSTGESQL94&grs&sor .
postgesql Xeon Ice Lake Processor Motherboard Chipset Memory Disk Graphics Network OS Kernel Desktop Display Server Compiler File-System Screen Resolution 1 2 3 2 x Intel Xeon Platinum 8380 @ 3.40GHz (80 Cores / 160 Threads) Intel M50CYP2SB2U (SE5C6200.86B.0022.D08.2103221623 BIOS) Intel Device 0998 16 x 32 GB DDR4-3200MT/s Hynix HMA84GR7CJR4N-XN 2 x 7682GB INTEL SSDPF2KX076TZ + 2 x 800GB INTEL SSDPF21Q800GB + 3841GB Micron_9300_MTFDHAL3T8TDP + 960GB INTEL SSDSC2KG96 ASPEED 2 x Intel X710 for 10GBASE-T + 2 x Intel E810-C for QSFP Ubuntu 20.04 5.11.0-051100-generic (x86_64) GNOME Shell 3.36.4 X Server 1.20.8 GCC 9.3.0 ext4 1024x768 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler Details - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Processor Details - Scaling Governor: intel_pstate powersave - CPU Microcode: 0xd000270 Security Details - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected
postgesql Xeon Ice Lake hammerdb-postgresql: 128 - 500 hammerdb-postgresql: 128 - 500 hammerdb-postgresql: 64 - 500 hammerdb-postgresql: 64 - 500 pgbench: 1 - 250 - Read Only pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write hammerdb-postgresql: 256 - 500 hammerdb-postgresql: 256 - 500 pgbench: 100 - 250 - Read Only pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 1000 - 250 - Read Write - Average Latency pgbench: 1000 - 250 - Read Write pgbench: 100 - 250 - Read Write pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 100 - Read Write pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 250 - Read Write pgbench: 1 - 50 - Read Only pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1000 - 250 - Read Only - Average Latency pgbench: 1000 - 250 - Read Only pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 100 - 50 - Read Only - Average Latency pgbench: 100 - 50 - Read Only pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 100 - 1 - Read Only - Average Latency pgbench: 100 - 1 - Read Only pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 100 - Read Only pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Only 1 2 3 174055 400264 371360 853808 1949229 5.175 19356 126.025 795 90348 207845 1054863 0.239 2.181 22951 2.993 16713 11.943 21026 26590 9.445 3.337 30017 352.233 713 849228 60.607 825 0.059 0.283 933329 0.258 389594 0.087 591122 1.638 836 0.236 428957 0.081 12947 0.079 643046 0.948 1451 0.066 15491 0.163 0.139 724311 2.155 486 0.065 15821 164956 379302 350142 805842 1980181 5.339 18765 128.379 780 88045 202571 1040353 0.242 2.186 22934 3.036 16485 12.074 20801 26536 9.455 3.340 29997 351.860 713 842550 60.547 826 0.059 0.256 983996 0.286 356549 0.087 589634 1.724 781 0.237 426771 0.081 12838 0.077 671002 1.017 1349 0.068 14934 0.161 0.135 757418 1.988 534 0.061 16620 152722 351396 350229 805441 1898545 129.786 772 88613 204133 1035713 0.243 2.217 22619 26310 9.543 3.369 29736 355.168 707 848101 60.851 822 0.059 0.073 685264 1.533 846 0.234 429246 0.070 14208 0.079 644658 1.337 968 0.081 12751 0.160 0.136 738956 2.039 501 0.061 16687 OpenBenchmarking.org
HammerDB - PostgreSQL Virtual Users: 128 - Warehouses: 500 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 128 - Warehouses: 500 1 2 3 40K 80K 120K 160K 200K SE +/- 3455.38, N = 9 SE +/- 1672.66, N = 3 SE +/- 1942.00, N = 9 174055 164956 152722 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
HammerDB - PostgreSQL Virtual Users: 128 - Warehouses: 500 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 128 - Warehouses: 500 1 2 3 90K 180K 270K 360K 450K SE +/- 7933.14, N = 9 SE +/- 3831.17, N = 3 SE +/- 4450.18, N = 9 400264 379302 351396 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 500 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 64 - Warehouses: 500 1 3 2 80K 160K 240K 320K 400K SE +/- 4713.31, N = 3 SE +/- 1150.94, N = 3 SE +/- 1280.11, N = 3 371360 350229 350142 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 500 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 64 - Warehouses: 500 1 2 3 200K 400K 600K 800K 1000K SE +/- 10776.53, N = 3 SE +/- 3121.14, N = 3 SE +/- 2611.46, N = 3 853808 805842 805441 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only 2 1 3 400K 800K 1200K 1600K 2000K SE +/- 19399.45, N = 15 SE +/- 22907.70, N = 15 SE +/- 22748.90, N = 13 1980181 1949229 1898545 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency 1 2 1.2013 2.4026 3.6039 4.8052 6.0065 SE +/- 0.009, N = 3 SE +/- 0.068, N = 3 5.175 5.339 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write 1 2 4K 8K 12K 16K 20K SE +/- 32.22, N = 3 SE +/- 242.26, N = 3 19356 18765 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency 1 2 3 30 60 90 120 150 SE +/- 0.53, N = 3 SE +/- 0.80, N = 3 SE +/- 0.58, N = 3 126.03 128.38 129.79 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write 1 2 3 200 400 600 800 1000 SE +/- 3.47, N = 3 SE +/- 4.91, N = 3 SE +/- 3.47, N = 3 795 780 772 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
HammerDB - PostgreSQL Virtual Users: 256 - Warehouses: 500 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 256 - Warehouses: 500 1 3 2 20K 40K 60K 80K 100K SE +/- 919.75, N = 3 SE +/- 562.62, N = 3 SE +/- 1061.78, N = 4 90348 88613 88045 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
HammerDB - PostgreSQL Virtual Users: 256 - Warehouses: 500 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 256 - Warehouses: 500 1 3 2 40K 80K 120K 160K 200K SE +/- 2323.95, N = 3 SE +/- 1370.58, N = 3 SE +/- 2471.49, N = 4 207845 204133 202571 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only 1 2 3 200K 400K 600K 800K 1000K SE +/- 9590.23, N = 15 SE +/- 10007.33, N = 15 SE +/- 8974.99, N = 15 1054863 1040353 1035713 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency 1 2 3 0.0547 0.1094 0.1641 0.2188 0.2735 SE +/- 0.002, N = 15 SE +/- 0.002, N = 15 SE +/- 0.002, N = 15 0.239 0.242 0.243 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency 1 2 3 0.4988 0.9976 1.4964 1.9952 2.494 SE +/- 0.031, N = 3 SE +/- 0.028, N = 15 SE +/- 0.028, N = 15 2.181 2.186 2.217 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write 1 2 3 5K 10K 15K 20K 25K SE +/- 319.99, N = 3 SE +/- 297.21, N = 15 SE +/- 286.02, N = 15 22951 22934 22619 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency 1 2 0.6831 1.3662 2.0493 2.7324 3.4155 SE +/- 0.019, N = 3 SE +/- 0.043, N = 3 2.993 3.036 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write 1 2 4K 8K 12K 16K 20K SE +/- 108.48, N = 3 SE +/- 230.69, N = 3 16713 16485 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency 1 2 3 6 9 12 15 SE +/- 0.11, N = 3 SE +/- 0.06, N = 3 11.94 12.07 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write 1 2 5K 10K 15K 20K 25K SE +/- 186.69, N = 3 SE +/- 99.30, N = 3 21026 20801 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write 1 2 3 6K 12K 18K 24K 30K SE +/- 79.50, N = 3 SE +/- 68.43, N = 3 SE +/- 37.07, N = 3 26590 26536 26310 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency 1 2 3 3 6 9 12 15 SE +/- 0.028, N = 3 SE +/- 0.025, N = 3 SE +/- 0.011, N = 3 9.445 9.455 9.543 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency 1 2 3 0.758 1.516 2.274 3.032 3.79 SE +/- 0.004, N = 3 SE +/- 0.007, N = 3 SE +/- 0.039, N = 3 3.337 3.340 3.369 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write 1 2 3 6K 12K 18K 24K 30K SE +/- 35.14, N = 3 SE +/- 61.06, N = 3 SE +/- 335.68, N = 3 30017 29997 29736 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency 2 1 3 80 160 240 320 400 SE +/- 3.63, N = 5 SE +/- 4.43, N = 3 SE +/- 4.20, N = 3 351.86 352.23 355.17 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write 2 1 3 150 300 450 600 750 SE +/- 7.26, N = 5 SE +/- 9.01, N = 3 SE +/- 8.38, N = 3 713 713 707 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only 1 3 2 200K 400K 600K 800K 1000K SE +/- 9704.81, N = 13 SE +/- 6190.25, N = 15 SE +/- 9073.88, N = 3 849228 848101 842550 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency 2 1 3 14 28 42 56 70 SE +/- 0.23, N = 3 SE +/- 0.22, N = 3 SE +/- 0.48, N = 3 60.55 60.61 60.85 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write 2 1 3 200 400 600 800 1000 SE +/- 3.13, N = 3 SE +/- 3.01, N = 3 SE +/- 6.51, N = 3 826 825 822 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency 1 2 3 0.0133 0.0266 0.0399 0.0532 0.0665 SE +/- 0.001, N = 13 SE +/- 0.001, N = 3 SE +/- 0.000, N = 15 0.059 0.059 0.059 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency 2 1 0.0637 0.1274 0.1911 0.2548 0.3185 SE +/- 0.002, N = 3 SE +/- 0.027, N = 10 0.256 0.283 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only 2 1 200K 400K 600K 800K 1000K SE +/- 9141.86, N = 3 SE +/- 51783.85, N = 10 983996 933329 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency 1 2 0.0644 0.1288 0.1932 0.2576 0.322 SE +/- 0.006, N = 9 SE +/- 0.013, N = 9 0.258 0.286 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only 1 2 80K 160K 240K 320K 400K SE +/- 8197.67, N = 9 SE +/- 15971.15, N = 9 389594 356549 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency 3 1 2 0.0196 0.0392 0.0588 0.0784 0.098 SE +/- 0.001, N = 3 SE +/- 0.004, N = 12 SE +/- 0.004, N = 12 0.073 0.087 0.087 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only 3 1 2 150K 300K 450K 600K 750K SE +/- 6256.41, N = 3 SE +/- 27070.57, N = 12 SE +/- 26949.89, N = 12 685264 591122 589634 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency 3 1 2 0.3879 0.7758 1.1637 1.5516 1.9395 SE +/- 0.255, N = 9 SE +/- 0.248, N = 12 SE +/- 0.300, N = 9 1.533 1.638 1.724 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write 3 1 2 200 400 600 800 1000 SE +/- 166.40, N = 9 SE +/- 150.44, N = 12 SE +/- 150.92, N = 9 846 836 781 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency 3 1 2 0.0533 0.1066 0.1599 0.2132 0.2665 SE +/- 0.004, N = 15 SE +/- 0.006, N = 15 SE +/- 0.006, N = 15 0.234 0.236 0.237 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only 3 1 2 90K 180K 270K 360K 450K SE +/- 7685.33, N = 15 SE +/- 11127.37, N = 15 SE +/- 12327.08, N = 15 429246 428957 426771 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency 3 1 2 0.0182 0.0364 0.0546 0.0728 0.091 SE +/- 0.001, N = 3 SE +/- 0.007, N = 9 SE +/- 0.005, N = 12 0.070 0.081 0.081 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only 3 1 2 3K 6K 9K 12K 15K SE +/- 126.23, N = 3 SE +/- 933.19, N = 9 SE +/- 741.11, N = 12 14208 12947 12838 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency 2 1 3 0.0178 0.0356 0.0534 0.0712 0.089 SE +/- 0.004, N = 15 SE +/- 0.004, N = 12 SE +/- 0.003, N = 15 0.077 0.079 0.079 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only 2 3 1 140K 280K 420K 560K 700K SE +/- 26723.10, N = 15 SE +/- 22700.84, N = 15 SE +/- 25734.09, N = 12 671002 644658 643046 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency 1 2 3 0.3008 0.6016 0.9024 1.2032 1.504 SE +/- 0.179, N = 12 SE +/- 0.156, N = 15 SE +/- 0.174, N = 15 0.948 1.017 1.337 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write 1 2 3 300 600 900 1200 1500 SE +/- 211.12, N = 12 SE +/- 186.99, N = 15 SE +/- 132.74, N = 15 1451 1349 968 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency 1 2 3 0.0182 0.0364 0.0546 0.0728 0.091 SE +/- 0.003, N = 15 SE +/- 0.003, N = 12 SE +/- 0.004, N = 15 0.066 0.068 0.081 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only 1 2 3 3K 6K 9K 12K 15K SE +/- 609.75, N = 15 SE +/- 493.96, N = 12 SE +/- 603.35, N = 15 15491 14934 12751 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency 3 2 1 0.0367 0.0734 0.1101 0.1468 0.1835 SE +/- 0.003, N = 13 SE +/- 0.003, N = 15 SE +/- 0.002, N = 15 0.160 0.161 0.163 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency 2 3 1 0.0313 0.0626 0.0939 0.1252 0.1565 SE +/- 0.005, N = 15 SE +/- 0.002, N = 15 SE +/- 0.002, N = 15 0.135 0.136 0.139 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only 2 3 1 160K 320K 480K 640K 800K SE +/- 32720.77, N = 15 SE +/- 10782.84, N = 15 SE +/- 12075.57, N = 15 757418 738956 724311 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency 2 3 1 0.4849 0.9698 1.4547 1.9396 2.4245 SE +/- 0.107, N = 15 SE +/- 0.078, N = 15 SE +/- 0.127, N = 12 1.988 2.039 2.155 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write 2 3 1 120 240 360 480 600 SE +/- 43.50, N = 15 SE +/- 19.51, N = 15 SE +/- 34.42, N = 12 534 501 486 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency 2 3 1 0.0146 0.0292 0.0438 0.0584 0.073 SE +/- 0.002, N = 15 SE +/- 0.002, N = 15 SE +/- 0.003, N = 15 0.061 0.061 0.065 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only 3 2 1 4K 8K 12K 16K 20K SE +/- 591.67, N = 15 SE +/- 559.03, N = 15 SE +/- 653.03, N = 15 16687 16620 15821 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.5