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&grt&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: 1 - 250 - Read Only pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 500 - Read Only pgbench: 1 - 500 - Read Only - Average Latency pgbench: 1 - 800 - Read Only pgbench: 1 - 800 - Read Only - Average Latency pgbench: 1 - 1000 - Read Only pgbench: 1 - 1000 - Read Only - Average Latency pgbench: 1 - 250 - Read Write pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 500 - Read Write pgbench: 1 - 500 - Read Write - Average Latency pgbench: 1 - 800 - Read Write pgbench: 1 - 800 - Read Write - Average Latency pgbench: 1 - 1000 - Read Write pgbench: 1 - 1000 - Read Write - Average Latency pgbench: 100 - 250 - Read Only pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 500 - Read Only pgbench: 100 - 500 - Read Only - Average Latency pgbench: 100 - 800 - Read Only pgbench: 100 - 800 - Read Only - Average Latency pgbench: 100 - 1000 - Read Only pgbench: 100 - 1000 - Read Only - Average Latency pgbench: 100 - 250 - Read Write pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 500 - Read Write pgbench: 100 - 500 - Read Write - Average Latency pgbench: 100 - 800 - Read Write pgbench: 100 - 800 - Read Write - Average Latency pgbench: 1000 - 250 - Read Only pgbench: 1000 - 250 - Read Only - Average Latency pgbench: 1000 - 500 - Read Only pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 800 - Read Only pgbench: 1000 - 800 - Read Only - Average Latency pgbench: 100 - 1000 - Read Write pgbench: 100 - 1000 - Read Write - Average Latency pgbench: 1000 - 1000 - Read Only pgbench: 1000 - 1000 - Read Only - Average Latency pgbench: 1000 - 250 - Read Write pgbench: 1000 - 250 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 1000 - 800 - Read Write pgbench: 1000 - 800 - Read Write - Average Latency pgbench: 1000 - 1000 - Read Write pgbench: 1000 - 1000 - Read Write - Average Latency a b c 2494898 0.100 2424319 0.206 2148559 0.372 1792086 0.558 3614 69.178 2643 189.370 1687 476.586 1302 775.622 2195660 0.114 2114985 0.236 1849541 0.433 1539681 0.650 49215 5.095 46782 10.698 43923 18.223 1466539 0.171 1351988 0.370 1136399 0.704 40100 24.982 979984 1.021 24195 10.552 16413 30.725 16367 49.008 17010 59.097 2487931 0.100 2416203 0.207 2123261 0.377 1787489 0.559 3601 69.416 2623 190.824 1547 523.030 1352 739.733 2190080 0.114 2109580 0.237 1857810 0.431 1521013 0.657 46096 5.445 45173 11.106 43487 18.404 1473104 0.170 1337223 0.374 1118360 0.715 37542 26.754 988422 1.012 18781 13.573 14298 35.253 15269 52.927 14721 68.413 2493234 0.1 2420293 0.207 2125239 0.376 1821156 0.549 3600 69.441 2782 179.727 1504 531.866 1246 802.511 2195449 0.114 2101053 0.238 1861481 0.43 1500977 0.666 38332 6.522 39751 12.578 38708 20.667 1469404 0.17 1350914 0.37 1116572 0.716 34520 28.969 986623 1.014 16719 14.953 16101 31.053 15795 50.649 17620 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 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
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 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: 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 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: 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: 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: 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: 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 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 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: 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: 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: 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 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: 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: 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: 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 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: 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 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: 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: 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: 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 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: 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 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: 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 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: 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 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: 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: 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: 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: 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: 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 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: 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 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: 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: 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: 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 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: 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: 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: 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: 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: 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
Phoronix Test Suite v10.8.5