postgresql 16 ryzen AMD Ryzen 9 7950X 16-Core testing with a ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS) and AMD Radeon 16GB on Ubuntu 23.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2309153-PTS-POSTGRES77&grr&rdt .
postgresql 16 ryzen Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL Compiler File-System Screen Resolution a b c d e AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads) ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS) AMD Device 14d8 32GB Western Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GB AMD Radeon 16GB (2124/1218MHz) AMD Device ab30 ASUS MG28U Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 Ubuntu 23.04 6.5.0-060500daily20230909-generic (x86_64) GNOME Shell 44.3 X Server 1.21.1.7 + Wayland 4.6 Mesa 23.3~git2308310600.c8687a~oibaf~l (git-c8687a4 2023-08-31 lunar-oibaf-ppa) (LLVM 15.0.7 DRM 3.54) GCC 12.3.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-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-DAPbBt/gcc-12-12.3.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-12-DAPbBt/gcc-12-12.3.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: performance) - CPU Microcode: 0xa601203 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 + retbleed: Not affected + spec_rstack_overflow: Mitigation of safe RET no microcode + 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 + srbds: Not affected + tsx_async_abort: Not affected
postgresql 16 ryzen pgbench: 1 - 800 - Read Write - Average Latency pgbench: 1 - 800 - Read Write pgbench: 1 - 500 - Read Write - Average Latency pgbench: 1 - 500 - Read Write pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 250 - Read Write 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 - 800 - Read Write - Average Latency pgbench: 100 - 800 - Read Write pgbench: 100 - 500 - Read Write - Average Latency pgbench: 100 - 500 - Read Write pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 250 - Read Write pgbench: 100 - 50 - Read Only - Average Latency pgbench: 100 - 50 - Read Only pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 250 - Read Only pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 100 - Read Write pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 1 - 500 - Read Only - Average Latency pgbench: 1 - 500 - Read Only pgbench: 1 - 800 - Read Only - Average Latency pgbench: 1 - 800 - Read Only pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 250 - Read Only pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 50 - Read Only pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 100 - Read Only a b c d e 699.694 1153 255.747 1972 88.824 2831 0.673 1189288 0.354 1411056 16.358 48907 8.986 55642 3.916 63848 0.035 1419762 0.173 1446014 1.555 64298 0.919 54436 0.070 1433995 0.319 1566873 0.581 1376250 27.296 3664 0.159 1576800 12.658 3950 0.034 1486529 0.065 1542020 703.417 1142 244.092 2050 88.339 2830 0.658 1215557 0.357 1400715 16.624 48126 8.914 56094 3.967 63052 0.035 1421853 0.172 1453635 1.542 64873 0.901 55478 0.069 1438110 0.319 1566167 0.593 1349891 27.276 3666 0.159 1575894 12.572 3977 0.033 1501437 0.065 1542655 648.713 1233 230.704 2167 87.991 2841 0.665 1203557 0.362 1381803 16.204 49372 8.983 55661 3.851 64925 0.035 1432233 0.174 1438637 1.516 65970 0.89 56198 0.07 1427369 0.321 1559347 0.584 1370452 27.156 3682 0.159 1570938 12.508 3997 0.033 1496324 0.065 1541990 725.885 1102 269.751 1854 88.88 2813 0.658 1215503 0.357 1402239 16.242 49256 8.958 55817 3.849 64950 0.035 1424500 0.172 1449818 1.518 65892 0.889 56241 0.069 1453808 0.318 1570215 0.579 1381288 27.038 3699 0.158 1580324 12.505 3999 0.033 1509879 0.065 1543912 760.403 1052 262.421 1905 87.933 2843 0.662 1207903 0.354 1411872 16.263 49192 8.926 56017 3.886 64340 0.035 1419252 0.172 1454478 1.523 65670 0.888 56298 0.07 1437334 0.322 1551367 0.568 1408165 27.152 3683 0.158 1582386 12.48 4006 0.033 1503632 0.065 1547379 OpenBenchmarking.org
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency a b c d e 160 320 480 640 800 SE +/- 19.81, N = 11 SE +/- 13.68, N = 12 699.69 703.42 648.71 725.89 760.40 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write a b c d e 300 600 900 1200 1500 SE +/- 33.33, N = 11 SE +/- 22.47, N = 12 1153 1142 1233 1102 1052 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency a b c d e 60 120 180 240 300 SE +/- 8.41, N = 11 SE +/- 2.06, N = 12 255.75 244.09 230.70 269.75 262.42 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write a b c d e 500 1000 1500 2000 2500 SE +/- 52.08, N = 11 SE +/- 17.35, N = 12 1972 2050 2167 1854 1905 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency a b c d e 20 40 60 80 100 SE +/- 2.24, N = 12 SE +/- 0.71, N = 3 88.82 88.34 87.99 88.88 87.93 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write a b c d e 600 1200 1800 2400 3000 SE +/- 59.81, N = 12 SE +/- 22.68, N = 3 2831 2830 2841 2813 2843 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency a b c d e 0.1514 0.3028 0.4542 0.6056 0.757 SE +/- 0.004, N = 3 SE +/- 0.002, N = 3 0.673 0.658 0.665 0.658 0.662 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only a b c d e 300K 600K 900K 1200K 1500K SE +/- 7529.89, N = 3 SE +/- 4251.82, N = 3 1189288 1215557 1203557 1215503 1207903 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency a b c d e 0.0815 0.163 0.2445 0.326 0.4075 SE +/- 0.002, N = 3 SE +/- 0.001, N = 3 0.354 0.357 0.362 0.357 0.354 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only a b c d e 300K 600K 900K 1200K 1500K SE +/- 6676.89, N = 3 SE +/- 4589.53, N = 3 1411056 1400715 1381803 1402239 1411872 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency a b c d e 4 8 12 16 20 SE +/- 0.08, N = 3 SE +/- 0.11, N = 3 16.36 16.62 16.20 16.24 16.26 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 800 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write a b c d e 11K 22K 33K 44K 55K SE +/- 255.27, N = 3 SE +/- 315.44, N = 3 48907 48126 49372 49256 49192 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency a b c d e 3 6 9 12 15 SE +/- 0.010, N = 3 SE +/- 0.023, N = 3 8.986 8.914 8.983 8.958 8.926 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write a b c d e 12K 24K 36K 48K 60K SE +/- 60.51, N = 3 SE +/- 146.88, N = 3 55642 56094 55661 55817 56017 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency a b c d e 0.8926 1.7852 2.6778 3.5704 4.463 SE +/- 0.007, N = 3 SE +/- 0.057, N = 3 3.916 3.967 3.851 3.849 3.886 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write a b c d e 14K 28K 42K 56K 70K SE +/- 122.05, N = 3 SE +/- 896.30, N = 3 63848 63052 64925 64950 64340 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency a b c d e 0.0079 0.0158 0.0237 0.0316 0.0395 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.035 0.035 0.035 0.035 0.035 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only a b c d e 300K 600K 900K 1200K 1500K SE +/- 8737.73, N = 3 SE +/- 3271.06, N = 3 1419762 1421853 1432233 1424500 1419252 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency a b c d e 0.0392 0.0784 0.1176 0.1568 0.196 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.173 0.172 0.174 0.172 0.172 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only a b c d e 300K 600K 900K 1200K 1500K SE +/- 7044.20, N = 3 SE +/- 6322.18, N = 3 1446014 1453635 1438637 1449818 1454478 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency a b c d e 0.3499 0.6998 1.0497 1.3996 1.7495 SE +/- 0.003, N = 3 SE +/- 0.003, N = 3 1.555 1.542 1.516 1.518 1.523 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write a b c d e 14K 28K 42K 56K 70K SE +/- 117.45, N = 3 SE +/- 131.20, N = 3 64298 64873 65970 65892 65670 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency a b c d e 0.2068 0.4136 0.6204 0.8272 1.034 SE +/- 0.011, N = 3 SE +/- 0.002, N = 3 0.919 0.901 0.890 0.889 0.888 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write a b c d e 12K 24K 36K 48K 60K SE +/- 660.01, N = 3 SE +/- 103.62, N = 3 54436 55478 56198 56241 56298 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency a b c d e 0.0158 0.0316 0.0474 0.0632 0.079 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.070 0.069 0.070 0.069 0.070 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 100 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only a b c d e 300K 600K 900K 1200K 1500K SE +/- 5069.29, N = 3 SE +/- 7316.19, N = 3 1433995 1438110 1427369 1453808 1437334 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency a b c d e 0.0725 0.145 0.2175 0.29 0.3625 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.319 0.319 0.321 0.318 0.322 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only a b c d e 300K 600K 900K 1200K 1500K SE +/- 2910.69, N = 3 SE +/- 4064.56, N = 3 1566873 1566167 1559347 1570215 1551367 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency a b c d e 0.1334 0.2668 0.4002 0.5336 0.667 SE +/- 0.001, N = 3 SE +/- 0.007, N = 3 0.581 0.593 0.584 0.579 0.568 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 800 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only a b c d e 300K 600K 900K 1200K 1500K SE +/- 2756.67, N = 3 SE +/- 15531.90, N = 3 1376250 1349891 1370452 1381288 1408165 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency a b c d e 6 12 18 24 30 SE +/- 0.10, N = 3 SE +/- 0.03, N = 3 27.30 27.28 27.16 27.04 27.15 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write a b c d e 800 1600 2400 3200 4000 SE +/- 13.30, N = 3 SE +/- 4.63, N = 3 3664 3666 3682 3699 3683 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency a b c d e 0.0358 0.0716 0.1074 0.1432 0.179 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.159 0.159 0.159 0.158 0.158 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only a b c d e 300K 600K 900K 1200K 1500K SE +/- 2098.20, N = 3 SE +/- 3713.99, N = 3 1576800 1575894 1570938 1580324 1582386 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency a b c d e 3 6 9 12 15 SE +/- 0.08, N = 3 SE +/- 0.00, N = 3 12.66 12.57 12.51 12.51 12.48 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write a b c d e 900 1800 2700 3600 4500 SE +/- 24.84, N = 3 SE +/- 1.27, N = 3 3950 3977 3997 3999 4006 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency a b c d e 0.0077 0.0154 0.0231 0.0308 0.0385 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.034 0.033 0.033 0.033 0.033 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only a b c d e 300K 600K 900K 1200K 1500K SE +/- 14877.89, N = 3 SE +/- 1586.76, N = 3 1486529 1501437 1496324 1509879 1503632 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency a b c d e 0.0146 0.0292 0.0438 0.0584 0.073 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.065 0.065 0.065 0.065 0.065 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
PostgreSQL Scaling Factor: 1 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only a b c d e 300K 600K 900K 1200K 1500K SE +/- 5450.25, N = 3 SE +/- 1633.39, N = 3 1542020 1542655 1541990 1543912 1547379 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
Phoronix Test Suite v10.8.5