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&grr&sor .
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: 1000 - 1000 - Read Write - Average Latency pgbench: 1000 - 1000 - Read Write pgbench: 1000 - 800 - Read Write - Average Latency pgbench: 1000 - 800 - Read Write pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write pgbench: 1000 - 250 - Read Write - Average Latency pgbench: 1000 - 250 - Read Write pgbench: 100 - 500 - Read Write - Average Latency pgbench: 100 - 500 - Read Write pgbench: 1 - 500 - Read Write - Average Latency pgbench: 1 - 500 - Read Write pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 250 - Read Write pgbench: 100 - 1000 - Read Write - Average Latency pgbench: 100 - 1000 - Read Write pgbench: 1 - 800 - Read Write - Average Latency pgbench: 1 - 800 - Read Write pgbench: 1 - 1000 - Read Write - Average Latency pgbench: 1 - 1000 - Read Write pgbench: 100 - 800 - Read Write - Average Latency pgbench: 100 - 800 - Read Write pgbench: 1000 - 1000 - Read Only - Average Latency pgbench: 1000 - 1000 - Read Only pgbench: 1000 - 800 - Read Only - Average Latency pgbench: 1000 - 800 - Read Only pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 500 - Read Only pgbench: 1000 - 250 - Read Only - Average Latency pgbench: 1000 - 250 - Read Only pgbench: 100 - 1000 - Read Only - Average Latency pgbench: 100 - 1000 - Read Only pgbench: 100 - 800 - Read Only - Average Latency pgbench: 100 - 800 - Read Only pgbench: 100 - 500 - Read Only - Average Latency pgbench: 100 - 500 - Read Only pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 250 - Read Only pgbench: 1 - 1000 - Read Only - Average Latency pgbench: 1 - 1000 - Read Only pgbench: 1 - 800 - Read Only - Average Latency pgbench: 1 - 800 - Read Only pgbench: 1 - 500 - Read Only - Average Latency pgbench: 1 - 500 - Read Only pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 250 - Read Write pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 250 - Read Only a b c 59.097 17010 49.008 16367 30.725 16413 10.552 24195 10.698 46782 189.370 2643 5.095 49215 24.982 40100 476.586 1687 775.622 1302 18.223 43923 1.021 979984 0.704 1136399 0.370 1351988 0.171 1466539 0.650 1539681 0.433 1849541 0.236 2114985 0.114 2195660 0.558 1792086 0.372 2148559 0.206 2424319 69.178 3614 0.100 2494898 68.413 14721 52.927 15269 35.253 14298 13.573 18781 11.106 45173 190.824 2623 5.445 46096 26.754 37542 523.030 1547 739.733 1352 18.404 43487 1.012 988422 0.715 1118360 0.374 1337223 0.170 1473104 0.657 1521013 0.431 1857810 0.237 2109580 0.114 2190080 0.559 1787489 0.377 2123261 0.207 2416203 69.416 3601 0.100 2487931 56.755 17620 50.649 15795 31.053 16101 14.953 16719 12.578 39751 179.727 2782 6.522 38332 28.969 34520 531.866 1504 802.511 1246 20.667 38708 1.014 986623 0.716 1116572 0.37 1350914 0.17 1469404 0.666 1500977 0.43 1861481 0.238 2101053 0.114 2195449 0.549 1821156 0.376 2125239 0.207 2420293 69.441 3600 0.1 2493234 OpenBenchmarking.org
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 c a b 15 30 45 60 75 SE +/- 1.31, N = 12 SE +/- 1.72, N = 12 56.76 59.10 68.41 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 c a b 4K 8K 12K 16K 20K SE +/- 363.42, N = 12 SE +/- 376.89, N = 12 17620 17010 14721 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 c b 12 24 36 48 60 SE +/- 0.75, N = 12 SE +/- 1.57, N = 12 49.01 50.65 52.93 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 c b 4K 8K 12K 16K 20K SE +/- 259.50, N = 12 SE +/- 476.46, N = 12 16367 15795 15269 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 c b 8 16 24 32 40 SE +/- 0.83, N = 12 SE +/- 0.93, N = 12 30.73 31.05 35.25 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 c b 4K 8K 12K 16K 20K SE +/- 470.97, N = 12 SE +/- 396.90, N = 12 16413 16101 14298 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: 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: 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: 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: 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 c a b 40 80 120 160 200 SE +/- 1.96, N = 12 SE +/- 1.82, N = 12 179.73 189.37 190.82 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 c a b 600 1200 1800 2400 3000 SE +/- 26.98, N = 12 SE +/- 24.95, N = 12 2782 2643 2623 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: 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: 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: 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: 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: 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 - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency b a c 200 400 600 800 1000 SE +/- 7.48, N = 3 SE +/- 26.61, N = 9 739.73 775.62 802.51 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 b a c 300 600 900 1200 1500 SE +/- 13.81, N = 3 SE +/- 45.33, N = 9 1352 1302 1246 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: 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: 1000 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency b c a 0.2297 0.4594 0.6891 0.9188 1.1485 SE +/- 0.001, N = 3 SE +/- 0.000, N = 3 1.012 1.014 1.021 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 b c a 200K 400K 600K 800K 1000K SE +/- 915.22, N = 3 SE +/- 417.48, N = 3 988422 986623 979984 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: 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: 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 c b 0.0842 0.1684 0.2526 0.3368 0.421 SE +/- 0.000, N = 3 SE +/- 0.001, N = 3 0.370 0.370 0.374 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 c b 300K 600K 900K 1200K 1500K SE +/- 1084.14, N = 3 SE +/- 3236.90, N = 3 1351988 1350914 1337223 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 b c a 0.0385 0.077 0.1155 0.154 0.1925 SE +/- 0.000, N = 3 SE +/- 0.001, N = 3 0.170 0.170 0.171 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 b c a 300K 600K 900K 1200K 1500K SE +/- 1078.77, N = 3 SE +/- 4725.59, N = 3 1473104 1469404 1466539 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: 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: 800 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency c b a 0.0974 0.1948 0.2922 0.3896 0.487 SE +/- 0.002, N = 3 SE +/- 0.001, N = 3 0.430 0.431 0.433 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 c b a 400K 800K 1200K 1600K 2000K SE +/- 9393.57, N = 3 SE +/- 5849.59, N = 3 1861481 1857810 1849541 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: 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: 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: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Only a c b 500K 1000K 1500K 2000K 2500K SE +/- 1687.85, N = 3 SE +/- 3331.36, N = 3 2195660 2195449 2190080 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 c a b 0.1258 0.2516 0.3774 0.5032 0.629 SE +/- 0.004, N = 3 SE +/- 0.007, N = 3 0.549 0.558 0.559 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 c a b 400K 800K 1200K 1600K 2000K SE +/- 14228.54, N = 3 SE +/- 22211.60, N = 3 1821156 1792086 1787489 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 c b 0.0848 0.1696 0.2544 0.3392 0.424 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.372 0.376 0.377 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 c b 500K 1000K 1500K 2000K 2500K SE +/- 7009.02, N = 3 SE +/- 2523.67, N = 3 2148559 2125239 2123261 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: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Only a c b 500K 1000K 1500K 2000K 2500K SE +/- 2047.09, N = 3 SE +/- 2420.49, N = 3 2424319 2420293 2416203 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: 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: 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: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Only a c b 500K 1000K 1500K 2000K 2500K SE +/- 4585.03, N = 3 SE +/- 4949.97, N = 3 2494898 2493234 2487931 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
Phoronix Test Suite v10.8.5