pgbench threadripper AMD Ryzen Threadripper 3990X 64-Core testing with a Gigabyte TRX40 AORUS PRO WIFI (F6 BIOS) and AMD Radeon RX 5700 8GB on Pop 22.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2409274-PTS-PGBENCHT12&grr .
pgbench threadripper Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL Vulkan Compiler File-System Screen Resolution a b c AMD Ryzen Threadripper 3990X 64-Core @ 2.90GHz (64 Cores / 128 Threads) Gigabyte TRX40 AORUS PRO WIFI (F6 BIOS) AMD Starship/Matisse 4 x 32GB DDR4-3000MT/s CMK64GX4M2D3000C16 Samsung SSD 970 EVO Plus 500GB AMD Radeon RX 5700 8GB AMD Navi 10 HDMI Audio DELL P2415Q Intel I211 + Intel Wi-Fi 6 AX200 Pop 22.04 6.8.0-76060800daily20240311-generic (x86_64) GNOME Shell 42.5 X Server 1.21.1.4 4.6 Mesa 24.0.3-1pop1~1711635559~22.04~7a9f319 (LLVM 15.0.7 DRM 3.57) 1.3.274 GCC 11.4.0 ext4 1920x1080 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler Details - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.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-build-config=bootstrap-lto-lean --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: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0x830107a 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: Mitigation of untrained return thunk; SMT enabled with STIBP protection + spec_rstack_overflow: Mitigation of Safe RET + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
pgbench threadripper pgbench: 1000 - 1000 - Read Write - Average Latency pgbench: 1000 - 1000 - Read Write pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write pgbench: 1000 - 800 - Read Write - Average Latency pgbench: 1000 - 800 - Read Write pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 500 - Read Only 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: 100 - 1000 - Read Write - Average Latency pgbench: 100 - 1000 - Read Write pgbench: 100 - 1000 - Read Only - Average Latency pgbench: 100 - 1000 - Read Only pgbench: 100 - 500 - Read Only - Average Latency pgbench: 100 - 500 - Read Only pgbench: 100 - 800 - Read Only - Average Latency pgbench: 100 - 800 - Read Only pgbench: 100 - 500 - Read Write - Average Latency pgbench: 100 - 500 - Read Write a b c 159.151 6291 101.414 4959 135.900 5895 0.393 1272106 126.082 6345 0.787 1271459 0.624 1282126 169.269 5909 0.576 1735325 0.292 1710788 0.462 1732617 82.709 6047 158.000 6342 95.674 5275 136.372 5868 0.390 1281990 134.493 5949 0.788 1269406 0.624 1282059 158.932 6296 0.572 1748316 0.289 1728678 0.456 1754518 82.672 6049 160.719 6227 97.768 5159 139.772 5737 0.393 1273452 138.773 5770 0.792 1262802 0.626 1278511 166.226 6017 0.579 1726046 0.287 1742417 0.462 1731931 87.067 5744 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 a b c 40 80 120 160 200 SE +/- 2.01, N = 9 SE +/- 2.53, N = 9 SE +/- 1.64, N = 9 159.15 158.00 160.72 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 1400 2800 4200 5600 7000 SE +/- 77.90, N = 9 SE +/- 103.25, N = 9 SE +/- 63.82, N = 9 6291 6342 6227 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 20 40 60 80 100 SE +/- 2.59, N = 9 SE +/- 3.11, N = 9 SE +/- 3.11, N = 9 101.41 95.67 97.77 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 1100 2200 3300 4400 5500 SE +/- 139.75, N = 9 SE +/- 187.17, N = 9 SE +/- 178.61, N = 9 4959 5275 5159 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 30 60 90 120 150 SE +/- 1.80, N = 9 SE +/- 1.39, N = 3 SE +/- 2.30, N = 9 135.90 136.37 139.77 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 1300 2600 3900 5200 6500 SE +/- 73.84, N = 9 SE +/- 60.39, N = 3 SE +/- 98.24, N = 9 5895 5868 5737 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.0884 0.1768 0.2652 0.3536 0.442 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 SE +/- 0.002, N = 3 0.393 0.390 0.393 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 +/- 3331.75, N = 3 SE +/- 2899.78, N = 3 SE +/- 5124.61, N = 3 1272106 1281990 1273452 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 30 60 90 120 150 SE +/- 0.25, N = 3 SE +/- 0.89, N = 3 SE +/- 1.21, N = 12 126.08 134.49 138.77 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 1400 2800 4200 5600 7000 SE +/- 12.54, N = 3 SE +/- 39.50, N = 3 SE +/- 50.09, N = 12 6345 5949 5770 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.1782 0.3564 0.5346 0.7128 0.891 SE +/- 0.004, N = 3 SE +/- 0.003, N = 3 SE +/- 0.004, N = 3 0.787 0.788 0.792 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 300K 600K 900K 1200K 1500K SE +/- 6024.58, N = 3 SE +/- 4271.90, N = 3 SE +/- 5516.76, N = 3 1271459 1269406 1262802 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.1409 0.2818 0.4227 0.5636 0.7045 SE +/- 0.002, N = 3 SE +/- 0.003, N = 3 SE +/- 0.001, N = 3 0.624 0.624 0.626 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 300K 600K 900K 1200K 1500K SE +/- 3571.64, N = 3 SE +/- 5818.14, N = 3 SE +/- 2847.82, N = 3 1282126 1282059 1278511 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 40 80 120 160 200 SE +/- 1.78, N = 3 SE +/- 1.22, N = 11 SE +/- 1.68, N = 3 169.27 158.93 166.23 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 1300 2600 3900 5200 6500 SE +/- 61.90, N = 3 SE +/- 46.91, N = 11 SE +/- 61.41, N = 3 5909 6296 6017 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.1303 0.2606 0.3909 0.5212 0.6515 SE +/- 0.002, N = 3 SE +/- 0.002, N = 3 SE +/- 0.001, N = 3 0.576 0.572 0.579 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 400K 800K 1200K 1600K 2000K SE +/- 5765.99, N = 3 SE +/- 6318.21, N = 3 SE +/- 3269.51, N = 3 1735325 1748316 1726046 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.0657 0.1314 0.1971 0.2628 0.3285 SE +/- 0.002, N = 3 SE +/- 0.002, N = 3 SE +/- 0.001, N = 3 0.292 0.289 0.287 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 400K 800K 1200K 1600K 2000K SE +/- 9315.92, N = 3 SE +/- 10547.48, N = 3 SE +/- 7256.18, N = 3 1710788 1728678 1742417 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.104 0.208 0.312 0.416 0.52 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.462 0.456 0.462 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 +/- 2394.10, N = 3 SE +/- 3407.91, N = 3 SE +/- 4749.36, N = 3 1732617 1754518 1731931 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 20 40 60 80 100 SE +/- 1.07, N = 3 SE +/- 0.65, N = 3 SE +/- 0.93, N = 3 82.71 82.67 87.07 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 1300 2600 3900 5200 6500 SE +/- 77.02, N = 3 SE +/- 47.24, N = 3 SE +/- 61.01, N = 3 6047 6049 5744 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm
Phoronix Test Suite v10.8.5