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&grr&sro .
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: 256 - 500 hammerdb-postgresql: 256 - 500 hammerdb-postgresql: 64 - 500 hammerdb-postgresql: 64 - 500 pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 1000 - 250 - Read Only - Average Latency pgbench: 1000 - 250 - Read Only pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 250 - Read Only pgbench: 100 - 1 - Read Only - Average Latency pgbench: 100 - 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 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 100 - Read Only pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Only pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 100 - 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: 1 - 250 - Read Only - Average Latency pgbench: 1 - 250 - Read Only pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 50 - Read Only pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 250 - Read Write 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 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 50 - Read Write 1 2 3 400264 174055 207845 90348 853808 371360 1.638 836 0.087 591122 0.258 389594 0.081 12947 0.283 933329 0.236 428957 0.239 1054863 0.066 15491 0.079 643046 0.948 1451 2.181 22951 0.139 724311 0.065 15821 5.175 19356 2.993 16713 11.943 21026 0.163 1949229 2.155 486 0.059 849228 9.445 26590 3.337 30017 352.233 713 126.025 795 60.607 825 379302 164956 202571 88045 805842 350142 1.724 781 0.087 589634 0.286 356549 0.081 12838 0.256 983996 0.237 426771 0.242 1040353 0.068 14934 0.077 671002 1.017 1349 2.186 22934 0.135 757418 0.061 16620 5.339 18765 3.036 16485 12.074 20801 0.161 1980181 1.988 534 0.059 842550 9.455 26536 3.340 29997 351.860 713 128.379 780 60.547 826 351396 152722 204133 88613 805441 350229 1.533 846 0.073 685264 0.070 14208 0.234 429246 0.243 1035713 0.081 12751 0.079 644658 1.337 968 2.217 22619 0.136 738956 0.061 16687 0.160 1898545 2.039 501 0.059 848101 9.543 26310 3.369 29736 355.168 707 129.786 772 60.851 822 OpenBenchmarking.org
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: 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: 256 - Warehouses: 500 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 256 - Warehouses: 500 1 2 3 40K 80K 120K 160K 200K SE +/- 2323.95, N = 3 SE +/- 2471.49, N = 4 SE +/- 1370.58, N = 3 207845 202571 204133 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 2 3 20K 40K 60K 80K 100K SE +/- 919.75, N = 3 SE +/- 1061.78, N = 4 SE +/- 562.62, N = 3 90348 88045 88613 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
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 2 3 80K 160K 240K 320K 400K SE +/- 4713.31, N = 3 SE +/- 1280.11, N = 3 SE +/- 1150.94, N = 3 371360 350142 350229 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 1 2 3 0.3879 0.7758 1.1637 1.5516 1.9395 SE +/- 0.248, N = 12 SE +/- 0.300, N = 9 SE +/- 0.255, N = 9 1.638 1.724 1.533 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 1 2 3 200 400 600 800 1000 SE +/- 150.44, N = 12 SE +/- 150.92, N = 9 SE +/- 166.40, N = 9 836 781 846 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 1 2 3 0.0196 0.0392 0.0588 0.0784 0.098 SE +/- 0.004, N = 12 SE +/- 0.004, N = 12 SE +/- 0.001, N = 3 0.087 0.087 0.073 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 1 2 3 150K 300K 450K 600K 750K SE +/- 27070.57, N = 12 SE +/- 26949.89, N = 12 SE +/- 6256.41, N = 3 591122 589634 685264 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: 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 1 2 3 0.0182 0.0364 0.0546 0.0728 0.091 SE +/- 0.007, N = 9 SE +/- 0.005, N = 12 SE +/- 0.001, N = 3 0.081 0.081 0.070 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 1 2 3 3K 6K 9K 12K 15K SE +/- 933.19, N = 9 SE +/- 741.11, N = 12 SE +/- 126.23, N = 3 12947 12838 14208 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 1 2 0.0637 0.1274 0.1911 0.2548 0.3185 SE +/- 0.027, N = 10 SE +/- 0.002, N = 3 0.283 0.256 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 1 2 200K 400K 600K 800K 1000K SE +/- 51783.85, N = 10 SE +/- 9141.86, N = 3 933329 983996 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 1 2 3 0.0533 0.1066 0.1599 0.2132 0.2665 SE +/- 0.006, N = 15 SE +/- 0.006, N = 15 SE +/- 0.004, N = 15 0.236 0.237 0.234 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 1 2 3 90K 180K 270K 360K 450K SE +/- 11127.37, N = 15 SE +/- 12327.08, N = 15 SE +/- 7685.33, N = 15 428957 426771 429246 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: 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: 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: 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 1 2 3 0.0178 0.0356 0.0534 0.0712 0.089 SE +/- 0.004, N = 12 SE +/- 0.004, N = 15 SE +/- 0.003, N = 15 0.079 0.077 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 1 2 3 140K 280K 420K 560K 700K SE +/- 25734.09, N = 12 SE +/- 26723.10, N = 15 SE +/- 22700.84, N = 15 643046 671002 644658 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: 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: 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 1 2 3 0.0313 0.0626 0.0939 0.1252 0.1565 SE +/- 0.002, N = 15 SE +/- 0.005, N = 15 SE +/- 0.002, N = 15 0.139 0.135 0.136 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 1 2 3 160K 320K 480K 640K 800K SE +/- 12075.57, N = 15 SE +/- 32720.77, N = 15 SE +/- 10782.84, N = 15 724311 757418 738956 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 1 2 3 0.0146 0.0292 0.0438 0.0584 0.073 SE +/- 0.003, N = 15 SE +/- 0.002, N = 15 SE +/- 0.002, N = 15 0.065 0.061 0.061 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 1 2 3 4K 8K 12K 16K 20K SE +/- 653.03, N = 15 SE +/- 559.03, N = 15 SE +/- 591.67, N = 15 15821 16620 16687 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: 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: 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 1 2 3 0.0367 0.0734 0.1101 0.1468 0.1835 SE +/- 0.002, N = 15 SE +/- 0.003, N = 15 SE +/- 0.003, N = 13 0.163 0.161 0.160 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 1 2 3 400K 800K 1200K 1600K 2000K SE +/- 22907.70, N = 15 SE +/- 19399.45, N = 15 SE +/- 22748.90, N = 13 1949229 1980181 1898545 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 1 2 3 0.4849 0.9698 1.4547 1.9396 2.4245 SE +/- 0.127, N = 12 SE +/- 0.107, N = 15 SE +/- 0.078, N = 15 2.155 1.988 2.039 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 1 2 3 120 240 360 480 600 SE +/- 34.42, N = 12 SE +/- 43.50, N = 15 SE +/- 19.51, N = 15 486 534 501 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: 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 2 3 200K 400K 600K 800K 1000K SE +/- 9704.81, N = 13 SE +/- 9073.88, N = 3 SE +/- 6190.25, N = 15 849228 842550 848101 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: 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: 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 1 2 3 80 160 240 320 400 SE +/- 4.43, N = 3 SE +/- 3.63, N = 5 SE +/- 4.20, N = 3 352.23 351.86 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 1 2 3 150 300 450 600 750 SE +/- 9.01, N = 3 SE +/- 7.26, N = 5 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: 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
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 1 2 3 14 28 42 56 70 SE +/- 0.22, N = 3 SE +/- 0.23, N = 3 SE +/- 0.48, N = 3 60.61 60.55 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 1 2 3 200 400 600 800 1000 SE +/- 3.01, N = 3 SE +/- 3.13, N = 3 SE +/- 6.51, N = 3 825 826 822 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.5