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.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2409274-PTS-PGBENCHT12
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results
Show Result Confidence Charts
Allow Limiting Results To Certain Suite(s)

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Toggle/Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
a
September 26
  7 Hours, 20 Minutes
b
September 26
  6 Hours, 57 Minutes
c
September 27
  8 Hours, 1 Minute
Invert Behavior (Only Show Selected Data)
  7 Hours, 26 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


pgbench threadripperOpenBenchmarking.orgPhoronix Test SuiteAMD Ryzen Threadripper 3990X 64-Core @ 2.90GHz (64 Cores / 128 Threads)Gigabyte TRX40 AORUS PRO WIFI (F6 BIOS)AMD Starship/Matisse4 x 32GB DDR4-3000MT/s CMK64GX4M2D3000C16Samsung SSD 970 EVO Plus 500GBAMD Radeon RX 5700 8GBAMD Navi 10 HDMI AudioDELL P2415QIntel I211 + Intel Wi-Fi 6 AX200Pop 22.046.8.0-76060800daily20240311-generic (x86_64)GNOME Shell 42.5X Server 1.21.1.44.6 Mesa 24.0.3-1pop1~1711635559~22.04~7a9f319 (LLVM 15.0.7 DRM 3.57)1.3.274GCC 11.4.0ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionPgbench Threadripper BenchmarksSystem Logs- Transparent Huge Pages: madvise- --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 - Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0x830107a- 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

abcResult OverviewPhoronix Test Suite100%103%105%108%110%PostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQL100 - 800 - Read Write - Average Latency100 - 800 - Read Write100 - 1000 - Read Write100 - 1000 - Read Write - Average Latency1000 - 500 - Read Write1000 - 500 - Read Write - Average Latency100 - 500 - Read Write - Average Latency100 - 500 - Read Write1000 - 800 - Read Write - Average Latency1000 - 800 - Read Write100 - 500 - Read Only1000 - 1000 - Read Write100 - 500 - Read Only - Average Latency1000 - 1000 - Read Write - Average Latency100 - 800 - Read Only - Average Latency100 - 800 - Read Only100 - 1000 - Read Only100 - 1000 - Read Only - Average Latency1000 - 500 - Read Only1000 - 500 - Read Only - Average Latency1000 - 1000 - Read Only1000 - 1000 - Read Only - Average Latency1000 - 800 - Read Only - Average Latency1000 - 800 - Read Only

pgbench threadripperpgbench: 1000 - 1000 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 800 - Read Write - Average Latencypgbench: 1000 - 800 - Read Writepgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 100 - 800 - Read Write - Average Latencypgbench: 100 - 800 - Read Writepgbench: 1000 - 1000 - Read Only - Average Latencypgbench: 1000 - 1000 - Read Onlypgbench: 1000 - 800 - Read Only - Average Latencypgbench: 1000 - 800 - Read Onlypgbench: 100 - 1000 - Read Write - Average Latencypgbench: 100 - 1000 - Read Writepgbench: 100 - 1000 - Read Only - Average Latencypgbench: 100 - 1000 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 800 - Read Only - Average Latencypgbench: 100 - 800 - Read Onlypgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 500 - Read Writeabc159.1516291101.4144959135.90058950.3931272106126.08263450.78712714590.6241282126169.26959090.57617353250.29217107880.462173261782.7096047158.000634295.6745275136.37258680.3901281990134.49359490.78812694060.6241282059158.93262960.57217483160.28917286780.456175451882.6726049160.719622797.7685159139.77257370.3931273452138.77357700.79212628020.6261278511166.22660170.57917260460.28717424170.462173193187.0675744OpenBenchmarking.org

PostgreSQL

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latencybac4080120160200SE +/- 2.53, N = 9SE +/- 2.01, N = 9SE +/- 1.64, N = 9158.00159.15160.721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read Writebac14002800420056007000SE +/- 103.25, N = 9SE +/- 77.90, N = 9SE +/- 63.82, N = 96342629162271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latencybca20406080100SE +/- 3.11, N = 9SE +/- 3.11, N = 9SE +/- 2.59, N = 995.6797.77101.411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 500 - Mode: Read Writebca11002200330044005500SE +/- 187.17, N = 9SE +/- 178.61, N = 9SE +/- 139.75, N = 95275515949591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latencyabc306090120150SE +/- 1.80, N = 9SE +/- 1.39, N = 3SE +/- 2.30, N = 9135.90136.37139.771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 800 - Mode: Read Writeabc13002600390052006500SE +/- 73.84, N = 9SE +/- 60.39, N = 3SE +/- 98.24, N = 95895586857371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latencybac0.08840.17680.26520.35360.442SE +/- 0.001, N = 3SE +/- 0.001, N = 3SE +/- 0.002, N = 30.3900.3930.3931. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 500 - Mode: Read Onlybca300K600K900K1200K1500KSE +/- 2899.78, N = 3SE +/- 5124.61, N = 3SE +/- 3331.75, N = 31281990127345212721061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latencyabc306090120150SE +/- 0.25, N = 3SE +/- 0.89, N = 3SE +/- 1.21, N = 12126.08134.49138.771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 800 - Mode: Read Writeabc14002800420056007000SE +/- 12.54, N = 3SE +/- 39.50, N = 3SE +/- 50.09, N = 126345594957701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latencyabc0.17820.35640.53460.71280.891SE +/- 0.004, N = 3SE +/- 0.003, N = 3SE +/- 0.004, N = 30.7870.7880.7921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read Onlyabc300K600K900K1200K1500KSE +/- 6024.58, N = 3SE +/- 4271.90, N = 3SE +/- 5516.76, N = 31271459126940612628021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latencyabc0.14090.28180.42270.56360.7045SE +/- 0.002, N = 3SE +/- 0.003, N = 3SE +/- 0.001, N = 30.6240.6240.6261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 800 - Mode: Read Onlyabc300K600K900K1200K1500KSE +/- 3571.64, N = 3SE +/- 5818.14, N = 3SE +/- 2847.82, N = 31282126128205912785111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latencybca4080120160200SE +/- 1.22, N = 11SE +/- 1.68, N = 3SE +/- 1.78, N = 3158.93166.23169.271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 1000 - Mode: Read Writebca13002600390052006500SE +/- 46.91, N = 11SE +/- 61.41, N = 3SE +/- 61.90, N = 36296601759091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latencybac0.13030.26060.39090.52120.6515SE +/- 0.002, N = 3SE +/- 0.002, N = 3SE +/- 0.001, N = 30.5720.5760.5791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 1000 - Mode: Read Onlybac400K800K1200K1600K2000KSE +/- 6318.21, N = 3SE +/- 5765.99, N = 3SE +/- 3269.51, N = 31748316173532517260461. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latencycba0.06570.13140.19710.26280.3285SE +/- 0.001, N = 3SE +/- 0.002, N = 3SE +/- 0.002, N = 30.2870.2890.2921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 500 - Mode: Read Onlycba400K800K1200K1600K2000KSE +/- 7256.18, N = 3SE +/- 10547.48, N = 3SE +/- 9315.92, N = 31742417172867817107881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latencybac0.1040.2080.3120.4160.52SE +/- 0.001, N = 3SE +/- 0.001, N = 3SE +/- 0.001, N = 30.4560.4620.4621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 800 - Mode: Read Onlybac400K800K1200K1600K2000KSE +/- 3407.91, N = 3SE +/- 2394.10, N = 3SE +/- 4749.36, N = 31754518173261717319311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latencybac20406080100SE +/- 0.65, N = 3SE +/- 1.07, N = 3SE +/- 0.93, N = 382.6782.7187.071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 500 - Mode: Read Writebac13002600390052006500SE +/- 47.24, N = 3SE +/- 77.02, N = 3SE +/- 61.01, N = 36049604757441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm