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&gru .
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: 100 - 500 - Read Only pgbench: 100 - 800 - Read Only pgbench: 100 - 1000 - Read Only pgbench: 100 - 500 - Read Write pgbench: 100 - 800 - Read Write pgbench: 1000 - 500 - Read Only pgbench: 1000 - 800 - Read Only pgbench: 100 - 1000 - Read Write pgbench: 1000 - 1000 - Read Only pgbench: 1000 - 500 - Read Write pgbench: 1000 - 800 - Read Write pgbench: 1000 - 1000 - Read Write pgbench: 100 - 500 - Read Only - Average Latency pgbench: 100 - 800 - Read Only - Average Latency pgbench: 100 - 1000 - Read Only - Average Latency pgbench: 100 - 500 - Read Write - Average Latency pgbench: 100 - 800 - Read Write - Average Latency pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 800 - Read Only - Average Latency pgbench: 100 - 1000 - Read Write - Average Latency pgbench: 1000 - 1000 - Read Only - Average Latency pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 1000 - 800 - Read Write - Average Latency pgbench: 1000 - 1000 - Read Write - Average Latency a b c 1710788 1732617 1735325 6047 6345 1272106 1282126 5909 1271459 4959 5895 6291 0.292 0.462 0.576 82.709 126.082 0.393 0.624 169.269 0.787 101.414 135.900 159.151 1728678 1754518 1748316 6049 5949 1281990 1282059 6296 1269406 5275 5868 6342 0.289 0.456 0.572 82.672 134.493 0.390 0.624 158.932 0.788 95.674 136.372 158.000 1742417 1731931 1726046 5744 5770 1273452 1278511 6017 1262802 5159 5737 6227 0.287 0.462 0.579 87.067 138.773 0.393 0.626 166.226 0.792 97.768 139.772 160.719 OpenBenchmarking.org
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 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: 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 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
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: 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: 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 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: 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: 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 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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
Phoronix Test Suite v10.8.5