pgbench 17 AMD Ryzen 9 9950X 16-Core testing with a ASUS ROG STRIX X670E-E GAMING WIFI (2401 BIOS) and AMD Radeon PRO W7900 45GB on Ubuntu 24.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2409278-PTS-PGBENCH150&gru&sro .
pgbench 17 Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL OpenCL Compiler File-System Screen Resolution a b c AMD Ryzen 9 9950X 16-Core @ 5.75GHz (16 Cores / 32 Threads) ASUS ROG STRIX X670E-E GAMING WIFI (2401 BIOS) AMD Device 14d8 2 x 32GB DDR5-6400MT/s Corsair CMK64GX5M2B6400C32 4001GB Western Digital WD_BLACK SN850X 4000GB + Western Digital WD_BLACK SN850X 2000GB + 257GB Flash Drive AMD Radeon PRO W7900 45GB (2200/3200MHz) AMD Navi 31 HDMI/DP DELL U2723QE Intel I225-V + Intel Wi-Fi 6E Ubuntu 24.04 6.10.1-061001-generic (x86_64) GNOME Shell 46.0 X Server 1.21.1.11 + Wayland 4.6 Mesa 24.2.0-devel (LLVM 18.1.7 DRM 3.57) OpenCL 2.1 AMD-APP (3625.0) GCC 13.2.0 ext4 3840x2160 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-backtrace --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-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/gcc-13-13.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-epp powersave (EPP: balance_performance) - CPU Microcode: 0xb404022 Security Details - gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: 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 Enhanced / Automatic IBRS; IBPB: conditional; STIBP: always-on; RSB filling; PBRSB-eIBRS: Not affected; BHI: Not affected + srbds: Not affected + tsx_async_abort: Not affected
pgbench 17 pgbench: 1 - 250 - Read Only pgbench: 1 - 500 - Read Only pgbench: 1 - 800 - Read Only pgbench: 1 - 1000 - Read Only pgbench: 1 - 250 - Read Write pgbench: 1 - 500 - Read Write pgbench: 1 - 800 - Read Write pgbench: 1 - 1000 - Read Write pgbench: 100 - 250 - Read Only pgbench: 100 - 500 - Read Only pgbench: 100 - 800 - Read Only pgbench: 100 - 1000 - Read Only pgbench: 100 - 250 - Read Write pgbench: 100 - 500 - Read Write pgbench: 100 - 800 - Read Write pgbench: 1000 - 250 - Read Only pgbench: 1000 - 500 - Read Only pgbench: 1000 - 800 - Read Only pgbench: 100 - 1000 - 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 - 250 - Read Only - Average Latency pgbench: 1 - 500 - Read Only - Average Latency pgbench: 1 - 800 - Read Only - 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: 1 - 1000 - Read Write - Average Latency pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 500 - Read Only - Average Latency pgbench: 100 - 800 - Read Only - 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 - 250 - Read Only - 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 - 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 2494898 2424319 2148559 1792086 3614 2643 1687 1302 2195660 2114985 1849541 1539681 49215 46782 43923 1466539 1351988 1136399 40100 979984 24195 16413 16367 17010 0.100 0.206 0.372 0.558 69.178 189.370 476.586 775.622 0.114 0.236 0.433 0.650 5.095 10.698 18.223 0.171 0.370 0.704 24.982 1.021 10.552 30.725 49.008 59.097 2487931 2416203 2123261 1787489 3601 2623 1547 1352 2190080 2109580 1857810 1521013 46096 45173 43487 1473104 1337223 1118360 37542 988422 18781 14298 15269 14721 0.100 0.207 0.377 0.559 69.416 190.824 523.030 739.733 0.114 0.237 0.431 0.657 5.445 11.106 18.404 0.170 0.374 0.715 26.754 1.012 13.573 35.253 52.927 68.413 2493234 2420293 2125239 1821156 3600 2782 1504 1246 2195449 2101053 1861481 1500977 38332 39751 38708 1469404 1350914 1116572 34520 986623 16719 16101 15795 17620 0.1 0.207 0.376 0.549 69.441 179.727 531.866 802.511 0.114 0.238 0.43 0.666 6.522 12.578 20.667 0.17 0.37 0.716 28.969 1.014 14.953 31.053 50.649 56.755 OpenBenchmarking.org
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Only a b c 500K 1000K 1500K 2000K 2500K SE +/- 4585.03, N = 3 SE +/- 4949.97, N = 3 2494898 2487931 2493234 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Only a b c 500K 1000K 1500K 2000K 2500K SE +/- 2047.09, N = 3 SE +/- 2420.49, N = 3 2424319 2416203 2420293 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Only a b c 500K 1000K 1500K 2000K 2500K SE +/- 7009.02, N = 3 SE +/- 2523.67, N = 3 2148559 2123261 2125239 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 1000 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only a b c 400K 800K 1200K 1600K 2000K SE +/- 14228.54, N = 3 SE +/- 22211.60, N = 3 1792086 1787489 1821156 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Write a b c 800 1600 2400 3200 4000 SE +/- 20.50, N = 3 SE +/- 2.88, N = 3 3614 3601 3600 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Write a b c 600 1200 1800 2400 3000 SE +/- 26.98, N = 12 SE +/- 24.95, N = 12 2643 2623 2782 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Write a b c 400 800 1200 1600 2000 SE +/- 39.53, N = 9 SE +/- 54.21, N = 12 1687 1547 1504 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 1000 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write a b c 300 600 900 1200 1500 SE +/- 45.33, N = 9 SE +/- 13.81, N = 3 1302 1352 1246 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Only a b c 500K 1000K 1500K 2000K 2500K SE +/- 1687.85, N = 3 SE +/- 3331.36, N = 3 2195660 2190080 2195449 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Only a b c 500K 1000K 1500K 2000K 2500K SE +/- 1961.44, N = 3 SE +/- 5278.88, N = 3 2114985 2109580 2101053 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Only a b c 400K 800K 1200K 1600K 2000K SE +/- 5849.59, N = 3 SE +/- 9393.57, N = 3 1849541 1857810 1861481 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 1000 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only a b c 300K 600K 900K 1200K 1500K SE +/- 15024.56, N = 3 SE +/- 8728.08, N = 3 1539681 1521013 1500977 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Write a b c 11K 22K 33K 44K 55K SE +/- 939.45, N = 9 SE +/- 859.18, N = 12 49215 46096 38332 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Write a b c 10K 20K 30K 40K 50K SE +/- 423.61, N = 12 SE +/- 767.55, N = 12 46782 45173 39751 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Write a b c 9K 18K 27K 36K 45K SE +/- 432.88, N = 6 SE +/- 623.85, N = 3 43923 43487 38708 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only a b c 300K 600K 900K 1200K 1500K SE +/- 4725.59, N = 3 SE +/- 1078.77, N = 3 1466539 1473104 1469404 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only a b c 300K 600K 900K 1200K 1500K SE +/- 1084.14, N = 3 SE +/- 3236.90, N = 3 1351988 1337223 1350914 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 800 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only a b c 200K 400K 600K 800K 1000K SE +/- 2328.08, N = 3 SE +/- 3974.94, N = 3 1136399 1118360 1116572 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 1000 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write a b c 9K 18K 27K 36K 45K SE +/- 495.47, N = 12 SE +/- 895.95, N = 9 40100 37542 34520 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only a b c 200K 400K 600K 800K 1000K SE +/- 417.48, N = 3 SE +/- 915.22, N = 3 979984 988422 986623 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write a b c 5K 10K 15K 20K 25K SE +/- 1066.06, N = 12 SE +/- 866.55, N = 12 24195 18781 16719 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write a b c 4K 8K 12K 16K 20K SE +/- 470.97, N = 12 SE +/- 396.90, N = 12 16413 14298 16101 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 800 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write a b c 4K 8K 12K 16K 20K SE +/- 259.50, N = 12 SE +/- 476.46, N = 12 16367 15269 15795 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write a b c 4K 8K 12K 16K 20K SE +/- 363.42, N = 12 SE +/- 376.89, N = 12 17010 14721 17620 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency a b c 0.0225 0.045 0.0675 0.09 0.1125 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.100 0.100 0.100 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency a b c 0.0466 0.0932 0.1398 0.1864 0.233 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.206 0.207 0.207 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency a b c 0.0848 0.1696 0.2544 0.3392 0.424 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.372 0.377 0.376 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency a b c 0.1258 0.2516 0.3774 0.5032 0.629 SE +/- 0.004, N = 3 SE +/- 0.007, N = 3 0.558 0.559 0.549 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency a b c 15 30 45 60 75 SE +/- 0.39, N = 3 SE +/- 0.06, N = 3 69.18 69.42 69.44 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency a b c 40 80 120 160 200 SE +/- 1.96, N = 12 SE +/- 1.82, N = 12 189.37 190.82 179.73 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency a b c 110 220 330 440 550 SE +/- 11.98, N = 9 SE +/- 15.74, N = 12 476.59 523.03 531.87 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency a b c 200 400 600 800 1000 SE +/- 26.61, N = 9 SE +/- 7.48, N = 3 775.62 739.73 802.51 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency a b c 0.0257 0.0514 0.0771 0.1028 0.1285 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.114 0.114 0.114 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency a b c 0.0536 0.1072 0.1608 0.2144 0.268 SE +/- 0.000, N = 3 SE +/- 0.001, N = 3 0.236 0.237 0.238 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency a b c 0.0974 0.1948 0.2922 0.3896 0.487 SE +/- 0.001, N = 3 SE +/- 0.002, N = 3 0.433 0.431 0.430 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency a b c 0.1499 0.2998 0.4497 0.5996 0.7495 SE +/- 0.006, N = 3 SE +/- 0.004, N = 3 0.650 0.657 0.666 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency a b c 2 4 6 8 10 SE +/- 0.098, N = 9 SE +/- 0.107, N = 12 5.095 5.445 6.522 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency a b c 3 6 9 12 15 SE +/- 0.10, N = 12 SE +/- 0.20, N = 12 10.70 11.11 12.58 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency a b c 5 10 15 20 25 SE +/- 0.18, N = 6 SE +/- 0.26, N = 3 18.22 18.40 20.67 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency a b c 0.0385 0.077 0.1155 0.154 0.1925 SE +/- 0.001, N = 3 SE +/- 0.000, N = 3 0.171 0.170 0.170 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency a b c 0.0842 0.1684 0.2526 0.3368 0.421 SE +/- 0.000, N = 3 SE +/- 0.001, N = 3 0.370 0.374 0.370 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency a b c 0.1611 0.3222 0.4833 0.6444 0.8055 SE +/- 0.001, N = 3 SE +/- 0.003, N = 3 0.704 0.715 0.716 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency a b c 7 14 21 28 35 SE +/- 0.33, N = 12 SE +/- 0.61, N = 9 24.98 26.75 28.97 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency a b c 0.2297 0.4594 0.6891 0.9188 1.1485 SE +/- 0.000, N = 3 SE +/- 0.001, N = 3 1.021 1.012 1.014 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency a b c 4 8 12 16 20 SE +/- 0.46, N = 12 SE +/- 0.52, N = 12 10.55 13.57 14.95 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency a b c 8 16 24 32 40 SE +/- 0.83, N = 12 SE +/- 0.93, N = 12 30.73 35.25 31.05 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency a b c 12 24 36 48 60 SE +/- 0.75, N = 12 SE +/- 1.57, N = 12 49.01 52.93 50.65 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency a b c 15 30 45 60 75 SE +/- 1.31, N = 12 SE +/- 1.72, N = 12 59.10 68.41 56.76 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
Phoronix Test Suite v10.8.5