pgbench 15 amd epyc genoa Tests for a future article. 2 x AMD EPYC 9654 96-Core testing with a AMD Titanite_4G (RTI1002E BIOS) and ASPEED on Ubuntu 23.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2301061-NE-PGBENCH1514&gru&sor .
pgbench 15 amd epyc genoa Processor Motherboard Chipset Memory Disk Graphics Monitor Network OS Kernel Desktop Display Server Vulkan Compiler File-System Screen Resolution a b c 2 x AMD EPYC 9654 96-Core @ 3.71GHz (192 Cores / 384 Threads) AMD Titanite_4G (RTI1002E BIOS) AMD Device 14a4 24 x 64 GB DDR5-4800MT/s Samsung M321R8GA0BB0-CQKEG 800GB INTEL SSDPF21Q800GB ASPEED VGA HDMI Broadcom NetXtreme BCM5720 PCIe Ubuntu 23.04 5.19.0-21-generic (x86_64) GNOME Shell 43.1 X Server 1.21.1.4 1.3.224 GCC 12.2.0 ext4 1920x1080 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler Details - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-12-l0Aoyl/gcc-12-12.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-12-l0Aoyl/gcc-12-12.2.0/debian/tmp-gcn/usr --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: amd-pstate performance (Boost: Enabled) - CPU Microcode: 0xa10110d Security Details - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
pgbench 15 amd epyc genoa pgbench: 1 - 1 - Read Only pgbench: 1 - 1 - Read Write pgbench: 1 - 50 - Read Only pgbench: 1 - 100 - Read Only pgbench: 1 - 250 - Read Only pgbench: 1 - 50 - Read Write pgbench: 1 - 500 - Read Only pgbench: 1 - 800 - Read Only pgbench: 100 - 1 - Read Only pgbench: 1 - 100 - Read Write pgbench: 1 - 1000 - Read Only pgbench: 1 - 250 - Read Write pgbench: 1 - 500 - Read Write pgbench: 1 - 800 - Read Write pgbench: 100 - 1 - Read Write pgbench: 100 - 50 - Read Only pgbench: 1000 - 1 - Read Only pgbench: 1 - 1000 - Read Write pgbench: 100 - 100 - Read Only pgbench: 100 - 250 - Read Only pgbench: 100 - 50 - Read Write pgbench: 100 - 500 - Read Only pgbench: 100 - 800 - Read Only pgbench: 1000 - 1 - Read Write pgbench: 1000 - 50 - Read Only pgbench: 100 - 100 - Read Write pgbench: 100 - 1000 - Read Only pgbench: 100 - 250 - Read Write pgbench: 100 - 500 - Read Write pgbench: 100 - 800 - Read Write pgbench: 1000 - 100 - Read Only pgbench: 1000 - 250 - Read Only pgbench: 1000 - 50 - Read Write pgbench: 1000 - 500 - Read Only pgbench: 1000 - 800 - Read Only pgbench: 100 - 1000 - Read Write pgbench: 1000 - 100 - Read Write pgbench: 1000 - 1000 - Read Only pgbench: 1000 - 250 - Read Write pgbench: 1000 - 500 - Read Write pgbench: 1000 - 800 - Read Write pgbench: 1000 - 1000 - Read Write pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 500 - Read Only - Average Latency pgbench: 1 - 800 - Read Only - Average Latency pgbench: 100 - 1 - Read Only - Average Latency pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 1000 - Read Only - Average Latency pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 500 - Read Write - Average Latency pgbench: 1 - 800 - Read Write - Average Latency pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 50 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 1 - 1000 - Read Write - Average Latency pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 500 - Read Only - Average Latency pgbench: 100 - 800 - Read Only - Average Latency pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 1000 - Read Only - Average Latency pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 500 - Read Write - Average Latency pgbench: 100 - 800 - Read Write - Average Latency pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 250 - Read Only - Average Latency pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 800 - Read Only - Average Latency pgbench: 100 - 1000 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 1000 - Read Only - Average Latency pgbench: 1000 - 250 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 1000 - 800 - Read Write - Average Latency pgbench: 1000 - 1000 - Read Write - Average Latency a b c 87304 9567 2028157 2696964 3223038 9936 3695503 3657326 75129 6115 3685575 2507 1006 649 8430 2012527 63191 500 2647361 3169687 82377 3440685 3643262 7462 1787790 37917 3538947 21103 21235 15089 1483866 1103071 10969 984445 821536 14503 5726 749819 14880 11923 14230 18425 0.011 0.105 0.025 0.037 0.078 5.032 0.135 0.219 0.013 16.353 0.271 99.701 497.051 1231.743 0.119 0.025 0.016 2001.096 0.038 0.079 0.607 0.145 0.22 0.134 0.028 2.637 0.283 11.847 23.546 53.017 0.067 0.227 4.558 0.508 0.974 68.95 17.465 1.334 16.801 41.935 56.221 54.275 85898 9169 2026910 2680970 3231805 8211 3674114 3702208 75335 5781 3656198 2512 870 525 7474 2021663 63765 450 2642652 3142114 23560 3508837 3360556 6643 1769501 18407 3340417 17036 15879 15322 1561366 1314231 13264 947071 887845 14779 10439 817159 14380 14732 13950 15592 0.012 0.109 0.025 0.037 0.077 6.095 0.136 0.216 0.013 17.297 0.274 99.553 589.607 1537.878 0.136 0.025 0.016 2276.451 0.038 0.080 2.226 0.143 0.238 0.157 0.028 5.717 0.300 15.163 32.008 52.697 0.064 0.19 3.77 0.528 0.901 67.661 9.579 1.224 17.386 33.941 57.348 64.134 86780 9039 2032038 2669998 3192427 8966 3738366 3665600 75450 6339 3674827 2344 940 578 5716 2008485 63284 488 2662034 3153143 21284 3392306 3259643 4014 1771860 25258 3328025 0.012 0.111 0.025 0.037 0.078 5.577 0.134 0.218 0.013 15.775 0.272 106.656 532.149 1385.163 0.175 0.025 0.016 2047.155 0.038 0.079 2.349 0.147 0.245 0.249 0.028 3.959 0.3 OpenBenchmarking.org
PostgreSQL Scaling Factor: 1 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only a c b 20K 40K 60K 80K 100K SE +/- 374.83, N = 3 87304 86780 85898 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write a b c 2K 4K 6K 8K 10K SE +/- 121.70, N = 12 9567 9169 9039 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only c a b 400K 800K 1200K 1600K 2000K SE +/- 9540.73, N = 3 2032038 2028157 2026910 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only a b c 600K 1200K 1800K 2400K 3000K SE +/- 1904.84, N = 3 2696964 2680970 2669998 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only b a c 700K 1400K 2100K 2800K 3500K SE +/- 26513.10, N = 3 3231805 3223038 3192427 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write a c b 2K 4K 6K 8K 10K SE +/- 73.71, N = 12 9936 8966 8211 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only c a b 800K 1600K 2400K 3200K 4000K SE +/- 1799.50, N = 3 3738366 3695503 3674114 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Only b c a 800K 1600K 2400K 3200K 4000K SE +/- 14555.68, N = 3 3702208 3665600 3657326 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only c b a 16K 32K 48K 64K 80K SE +/- 24.26, N = 3 75450 75335 75129 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write c a b 1400 2800 4200 5600 7000 SE +/- 18.94, N = 3 6339 6115 5781 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 1000 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only a c b 800K 1600K 2400K 3200K 4000K SE +/- 16731.26, N = 3 3685575 3674827 3656198 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write b a c 500 1000 1500 2000 2500 SE +/- 30.91, N = 3 2512 2507 2344 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write a c b 200 400 600 800 1000 SE +/- 41.56, N = 12 1006 940 870 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Write a c b 140 280 420 560 700 SE +/- 18.36, N = 9 649 578 525 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write a b c 2K 4K 6K 8K 10K SE +/- 249.51, N = 12 8430 7474 5716 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only b a c 400K 800K 1200K 1600K 2000K SE +/- 9704.88, N = 3 2021663 2012527 2008485 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only b c a 14K 28K 42K 56K 70K SE +/- 207.34, N = 3 63765 63284 63191 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 1000 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write a c b 110 220 330 440 550 SE +/- 26.04, N = 9 500 488 450 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only c a b 600K 1200K 1800K 2400K 3000K SE +/- 17718.14, N = 3 2662034 2647361 2642652 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only a c b 700K 1400K 2100K 2800K 3500K SE +/- 7595.12, N = 3 3169687 3153143 3142114 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write a b c 20K 40K 60K 80K 100K SE +/- 2022.12, N = 9 82377 23560 21284 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only b a c 800K 1600K 2400K 3200K 4000K SE +/- 13843.59, N = 3 3508837 3440685 3392306 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Only a b c 800K 1600K 2400K 3200K 4000K SE +/- 45519.88, N = 3 3643262 3360556 3259643 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write a b c 1600 3200 4800 6400 8000 SE +/- 342.89, N = 12 7462 6643 4014 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only a c b 400K 800K 1200K 1600K 2000K SE +/- 3848.13, N = 3 1787790 1771860 1769501 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write a c b 8K 16K 24K 32K 40K SE +/- 1169.81, N = 12 37917 25258 18407 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 1000 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only a b c 800K 1600K 2400K 3200K 4000K SE +/- 38430.80, N = 12 3538947 3340417 3328025 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write a b 5K 10K 15K 20K 25K SE +/- 969.74, N = 12 21103 17036 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write a b 5K 10K 15K 20K 25K SE +/- 587.65, N = 12 21235 15879 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Write b a 3K 6K 9K 12K 15K SE +/- 447.85, N = 12 15322 15089 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only b a 300K 600K 900K 1200K 1500K 1561366 1483866 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only b a 300K 600K 900K 1200K 1500K 1314231 1103071 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write b a 3K 6K 9K 12K 15K 13264 10969 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only a b 200K 400K 600K 800K 1000K 984445 947071 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 800 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only b a 200K 400K 600K 800K 1000K 887845 821536 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 1000 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write b a 3K 6K 9K 12K 15K 14779 14503 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write b a 2K 4K 6K 8K 10K 10439 5726 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only b a 200K 400K 600K 800K 1000K 817159 749819 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write a b 3K 6K 9K 12K 15K 14880 14380 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write b a 3K 6K 9K 12K 15K 14732 11923 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 800 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write a b 3K 6K 9K 12K 15K 14230 13950 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write a b 4K 8K 12K 16K 20K 18425 15592 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency a b c 0.0027 0.0054 0.0081 0.0108 0.0135 SE +/- 0.000, N = 3 0.011 0.012 0.012 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency a b c 0.025 0.05 0.075 0.1 0.125 SE +/- 0.002, N = 12 0.105 0.109 0.111 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency a b c 0.0056 0.0112 0.0168 0.0224 0.028 SE +/- 0.000, N = 3 0.025 0.025 0.025 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency a b c 0.0083 0.0166 0.0249 0.0332 0.0415 SE +/- 0.000, N = 3 0.037 0.037 0.037 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency b a c 0.0176 0.0352 0.0528 0.0704 0.088 SE +/- 0.001, N = 3 0.077 0.078 0.078 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency a c b 2 4 6 8 10 SE +/- 0.056, N = 12 5.032 5.577 6.095 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency c a b 0.0306 0.0612 0.0918 0.1224 0.153 SE +/- 0.000, N = 3 0.134 0.135 0.136 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency b c a 0.0493 0.0986 0.1479 0.1972 0.2465 SE +/- 0.001, N = 3 0.216 0.218 0.219 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency a b c 0.0029 0.0058 0.0087 0.0116 0.0145 SE +/- 0.000, N = 3 0.013 0.013 0.013 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency c a b 4 8 12 16 20 SE +/- 0.06, N = 3 15.78 16.35 17.30 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency a c b 0.0617 0.1234 0.1851 0.2468 0.3085 SE +/- 0.001, N = 3 0.271 0.272 0.274 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency b a c 20 40 60 80 100 SE +/- 1.21, N = 3 99.55 99.70 106.66 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency a c b 130 260 390 520 650 SE +/- 29.00, N = 12 497.05 532.15 589.61 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency a c b 300 600 900 1200 1500 SE +/- 51.32, N = 9 1231.74 1385.16 1537.88 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency a b c 0.0394 0.0788 0.1182 0.1576 0.197 SE +/- 0.005, N = 12 0.119 0.136 0.175 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency a b c 0.0056 0.0112 0.0168 0.0224 0.028 SE +/- 0.000, N = 3 0.025 0.025 0.025 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency a b c 0.0036 0.0072 0.0108 0.0144 0.018 SE +/- 0.000, N = 3 0.016 0.016 0.016 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency a c b 500 1000 1500 2000 2500 SE +/- 119.97, N = 9 2001.10 2047.16 2276.45 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency a b c 0.0086 0.0172 0.0258 0.0344 0.043 SE +/- 0.000, N = 3 0.038 0.038 0.038 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency a c b 0.018 0.036 0.054 0.072 0.09 SE +/- 0.000, N = 3 0.079 0.079 0.080 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency a b c 0.5285 1.057 1.5855 2.114 2.6425 SE +/- 0.155, N = 9 0.607 2.226 2.349 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency b a c 0.0331 0.0662 0.0993 0.1324 0.1655 SE +/- 0.000, N = 3 0.143 0.145 0.147 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency a b c 0.0551 0.1102 0.1653 0.2204 0.2755 SE +/- 0.003, N = 3 0.220 0.238 0.245 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency a b c 0.056 0.112 0.168 0.224 0.28 SE +/- 0.012, N = 12 0.134 0.157 0.249 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency a b c 0.0063 0.0126 0.0189 0.0252 0.0315 SE +/- 0.000, N = 3 0.028 0.028 0.028 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency a c b 1.2863 2.5726 3.8589 5.1452 6.4315 SE +/- 0.417, N = 12 2.637 3.959 5.717 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency a b c 0.0675 0.135 0.2025 0.27 0.3375 SE +/- 0.003, N = 12 0.283 0.300 0.300 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency a b 4 8 12 16 20 SE +/- 0.78, N = 12 11.85 15.16 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency a b 7 14 21 28 35 SE +/- 1.28, N = 12 23.55 32.01 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency b a 12 24 36 48 60 SE +/- 1.51, N = 12 52.70 53.02 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency b a 0.0151 0.0302 0.0453 0.0604 0.0755 0.064 0.067 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency b a 0.0511 0.1022 0.1533 0.2044 0.2555 0.190 0.227 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency b a 1.0256 2.0512 3.0768 4.1024 5.128 3.770 4.558 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency a b 0.1188 0.2376 0.3564 0.4752 0.594 0.508 0.528 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency b a 0.2192 0.4384 0.6576 0.8768 1.096 0.901 0.974 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency b a 15 30 45 60 75 67.66 68.95 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency b a 4 8 12 16 20 9.579 17.465 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency b a 0.3002 0.6004 0.9006 1.2008 1.501 1.224 1.334 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency a b 4 8 12 16 20 16.80 17.39 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency b a 10 20 30 40 50 33.94 41.94 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency a b 13 26 39 52 65 56.22 57.35 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency a b 14 28 42 56 70 54.28 64.13 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Phoronix Test Suite v10.8.4