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&sor&gru .
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 - 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: 1 - 100 - Read Write pgbench: 1 - 250 - Read Write pgbench: 1 - 500 - Read Write pgbench: 1 - 800 - Read Write pgbench: 100 - 50 - Read Only 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: 100 - 100 - Read Write pgbench: 100 - 250 - Read Write pgbench: 100 - 500 - Read Write pgbench: 100 - 800 - Read Write 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: 1 - 100 - Read Write - 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 - 50 - Read Only - 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: 100 - 100 - Read Write - Average Latency pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 500 - Read Write - Average Latency pgbench: 100 - 800 - Read Write - Average Latency a b c d e 1486529 1542020 1576800 3950 1566873 1376250 3664 2831 1972 1153 1419762 1433995 1446014 54436 1411056 1189288 64298 63848 55642 48907 0.034 0.065 0.159 12.658 0.319 0.581 27.296 88.824 255.747 699.694 0.035 0.070 0.173 0.919 0.354 0.673 1.555 3.916 8.986 16.358 1501437 1542655 1575894 3977 1566167 1349891 3666 2830 2050 1142 1421853 1438110 1453635 55478 1400715 1215557 64873 63052 56094 48126 0.033 0.065 0.159 12.572 0.319 0.593 27.276 88.339 244.092 703.417 0.035 0.069 0.172 0.901 0.357 0.658 1.542 3.967 8.914 16.624 1496324 1541990 1570938 3997 1559347 1370452 3682 2841 2167 1233 1432233 1427369 1438637 56198 1381803 1203557 65970 64925 55661 49372 0.033 0.065 0.159 12.508 0.321 0.584 27.156 87.991 230.704 648.713 0.035 0.07 0.174 0.89 0.362 0.665 1.516 3.851 8.983 16.204 1509879 1543912 1580324 3999 1570215 1381288 3699 2813 1854 1102 1424500 1453808 1449818 56241 1402239 1215503 65892 64950 55817 49256 0.033 0.065 0.158 12.505 0.318 0.579 27.038 88.88 269.751 725.885 0.035 0.069 0.172 0.889 0.357 0.658 1.518 3.849 8.958 16.242 1503632 1547379 1582386 4006 1551367 1408165 3683 2843 1905 1052 1419252 1437334 1454478 56298 1411872 1207903 65670 64340 56017 49192 0.033 0.065 0.158 12.48 0.322 0.568 27.152 87.933 262.421 760.403 0.035 0.07 0.172 0.888 0.354 0.662 1.523 3.886 8.926 16.263 OpenBenchmarking.org
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 d e b c a 300K 600K 900K 1200K 1500K SE +/- 1586.76, N = 3 SE +/- 14877.89, N = 3 1509879 1503632 1501437 1496324 1486529 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 e d b a c 300K 600K 900K 1200K 1500K SE +/- 1633.39, N = 3 SE +/- 5450.25, N = 3 1547379 1543912 1542655 1542020 1541990 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 e d a b c 300K 600K 900K 1200K 1500K SE +/- 2098.20, N = 3 SE +/- 3713.99, N = 3 1582386 1580324 1576800 1575894 1570938 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 e d c b a 900 1800 2700 3600 4500 SE +/- 1.27, N = 3 SE +/- 24.84, N = 3 4006 3999 3997 3977 3950 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 d a b c e 300K 600K 900K 1200K 1500K SE +/- 2910.69, N = 3 SE +/- 4064.56, N = 3 1570215 1566873 1566167 1559347 1551367 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 e d a c b 300K 600K 900K 1200K 1500K SE +/- 2756.67, N = 3 SE +/- 15531.90, N = 3 1408165 1381288 1376250 1370452 1349891 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 d e c b a 800 1600 2400 3200 4000 SE +/- 4.63, N = 3 SE +/- 13.30, N = 3 3699 3683 3682 3666 3664 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 e c a b d 600 1200 1800 2400 3000 SE +/- 59.81, N = 12 SE +/- 22.68, N = 3 2843 2841 2831 2830 2813 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 c b a e d 500 1000 1500 2000 2500 SE +/- 17.35, N = 12 SE +/- 52.08, N = 11 2167 2050 1972 1905 1854 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 c a b d e 300 600 900 1200 1500 SE +/- 33.33, N = 11 SE +/- 22.47, N = 12 1233 1153 1142 1102 1052 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 c d b a e 300K 600K 900K 1200K 1500K SE +/- 3271.06, N = 3 SE +/- 8737.73, N = 3 1432233 1424500 1421853 1419762 1419252 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 d b e a c 300K 600K 900K 1200K 1500K SE +/- 7316.19, N = 3 SE +/- 5069.29, N = 3 1453808 1438110 1437334 1433995 1427369 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 e b d a c 300K 600K 900K 1200K 1500K SE +/- 6322.18, N = 3 SE +/- 7044.20, N = 3 1454478 1453635 1449818 1446014 1438637 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 e d c b a 12K 24K 36K 48K 60K SE +/- 103.62, N = 3 SE +/- 660.01, N = 3 56298 56241 56198 55478 54436 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 e a d b c 300K 600K 900K 1200K 1500K SE +/- 6676.89, N = 3 SE +/- 4589.53, N = 3 1411872 1411056 1402239 1400715 1381803 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 b d e c a 300K 600K 900K 1200K 1500K SE +/- 4251.82, N = 3 SE +/- 7529.89, N = 3 1215557 1215503 1207903 1203557 1189288 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 c d e b a 14K 28K 42K 56K 70K SE +/- 131.20, N = 3 SE +/- 117.45, N = 3 65970 65892 65670 64873 64298 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 d c e a b 14K 28K 42K 56K 70K SE +/- 122.05, N = 3 SE +/- 896.30, N = 3 64950 64925 64340 63848 63052 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 b e d c a 12K 24K 36K 48K 60K SE +/- 146.88, N = 3 SE +/- 60.51, N = 3 56094 56017 55817 55661 55642 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 c d e a b 11K 22K 33K 44K 55K SE +/- 255.27, N = 3 SE +/- 315.44, N = 3 49372 49256 49192 48907 48126 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 b c d e a 0.0077 0.0154 0.0231 0.0308 0.0385 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.033 0.033 0.033 0.033 0.034 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: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency d e a b c 0.0358 0.0716 0.1074 0.1432 0.179 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.158 0.158 0.159 0.159 0.159 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 e d c b a 3 6 9 12 15 SE +/- 0.00, N = 3 SE +/- 0.08, N = 3 12.48 12.51 12.51 12.57 12.66 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 d a b c e 0.0725 0.145 0.2175 0.29 0.3625 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.318 0.319 0.319 0.321 0.322 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 e d a c b 0.1334 0.2668 0.4002 0.5336 0.667 SE +/- 0.001, N = 3 SE +/- 0.007, N = 3 0.568 0.579 0.581 0.584 0.593 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 d e c b a 6 12 18 24 30 SE +/- 0.03, N = 3 SE +/- 0.10, N = 3 27.04 27.15 27.16 27.28 27.30 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 e c b a d 20 40 60 80 100 SE +/- 0.71, N = 3 SE +/- 2.24, N = 12 87.93 87.99 88.34 88.82 88.88 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 c b a e d 60 120 180 240 300 SE +/- 2.06, N = 12 SE +/- 8.41, N = 11 230.70 244.09 255.75 262.42 269.75 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
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 c a b d e 160 320 480 640 800 SE +/- 19.81, N = 11 SE +/- 13.68, N = 12 648.71 699.69 703.42 725.89 760.40 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: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency b d a c e 0.0158 0.0316 0.0474 0.0632 0.079 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.069 0.069 0.070 0.070 0.070 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 b d e a c 0.0392 0.0784 0.1176 0.1568 0.196 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.172 0.172 0.172 0.173 0.174 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 e d c b a 0.2068 0.4136 0.6204 0.8272 1.034 SE +/- 0.002, N = 3 SE +/- 0.011, N = 3 0.888 0.889 0.890 0.901 0.919 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 e b d c 0.0815 0.163 0.2445 0.326 0.4075 SE +/- 0.002, N = 3 SE +/- 0.001, N = 3 0.354 0.354 0.357 0.357 0.362 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 b d e c a 0.1514 0.3028 0.4542 0.6056 0.757 SE +/- 0.002, N = 3 SE +/- 0.004, N = 3 0.658 0.658 0.662 0.665 0.673 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 c d e b a 0.3499 0.6998 1.0497 1.3996 1.7495 SE +/- 0.003, N = 3 SE +/- 0.003, N = 3 1.516 1.518 1.523 1.542 1.555 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 d c e a b 0.8926 1.7852 2.6778 3.5704 4.463 SE +/- 0.007, N = 3 SE +/- 0.057, N = 3 3.849 3.851 3.886 3.916 3.967 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 b e d c a 3 6 9 12 15 SE +/- 0.023, N = 3 SE +/- 0.010, N = 3 8.914 8.926 8.958 8.983 8.986 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 c d e a b 4 8 12 16 20 SE +/- 0.08, N = 3 SE +/- 0.11, N = 3 16.20 16.24 16.26 16.36 16.62 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
Phoronix Test Suite v10.8.5