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&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: 64 - 500 hammerdb-postgresql: 64 - 500 hammerdb-postgresql: 128 - 500 hammerdb-postgresql: 128 - 500 hammerdb-postgresql: 256 - 500 hammerdb-postgresql: 256 - 500 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: 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: 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: 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: 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 - 100 - Read Write pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 250 - Read Write pgbench: 1000 - 250 - Read Write - Average Latency 1 2 3 371360 853808 174055 400264 90348 207845 15821 0.065 486 2.155 849228 0.059 724311 0.139 1949229 0.163 825 60.607 15491 0.066 795 126.025 713 352.233 1451 0.948 643046 0.079 12947 0.081 428957 0.236 1054863 0.239 22951 2.181 836 1.638 591122 0.087 30017 3.337 26590 9.445 389594 0.258 933329 0.283 16713 2.993 19356 5.175 21026 11.943 350142 805842 164956 379302 88045 202571 16620 0.061 534 1.988 842550 0.059 757418 0.135 1980181 0.161 826 60.547 14934 0.068 780 128.379 713 351.860 1349 1.017 671002 0.077 12838 0.081 426771 0.237 1040353 0.242 22934 2.186 781 1.724 589634 0.087 29997 3.340 26536 9.455 356549 0.286 983996 0.256 16485 3.036 18765 5.339 20801 12.074 350229 805441 152722 351396 88613 204133 16687 0.061 501 2.039 848101 0.059 738956 0.136 1898545 0.160 822 60.851 12751 0.081 772 129.786 707 355.168 968 1.337 644658 0.079 14208 0.070 429246 0.234 1035713 0.243 22619 2.217 846 1.533 685264 0.073 29736 3.369 26310 9.543 OpenBenchmarking.org
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
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: 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: 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
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 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 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: 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 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: 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: 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: 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: 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: 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 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: 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: 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: 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: 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: 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: 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: 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 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: 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: 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: 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: 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: 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: 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: 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 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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
Phoronix Test Suite v10.8.5