pgbench 17

AMD Ryzen 9 9950X 16-Core testing with a ASUS ROG STRIX X670E-E GAMING WIFI (2401 BIOS) and AMD Radeon PRO W7900 45GB on Ubuntu 24.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 2409278-PTS-PGBENCH150
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 27
  12 Hours, 49 Minutes
b
September 27
  12 Hours, 28 Minutes
c
September 27
  1 Hour, 57 Minutes
Invert Behavior (Only Show Selected Data)
  9 Hours, 4 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):

a

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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-backtrace --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-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/gcc-13-13.2.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 Notes: Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xb404022
Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + 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; BHI: Not affected + srbds: Not affected + tsx_async_abort: Not affected

b

c

Processor: AMD Ryzen 9 9950X 16-Core @ 5.75GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (2401 BIOS), Chipset: AMD Device 14d8, Memory: 2 x 32GB DDR5-6400MT/s Corsair CMK64GX5M2B6400C32, Disk: 4001GB Western Digital WD_BLACK SN850X 4000GB + Western Digital WD_BLACK SN850X 2000GB + 257GB Flash Drive, Graphics: AMD Radeon PRO W7900 45GB (2200/3200MHz), Audio: AMD Navi 31 HDMI/DP, Monitor: DELL U2723QE, Network: Intel I225-V + Intel Wi-Fi 6E

OS: Ubuntu 24.04, Kernel: 6.10.1-061001-generic (x86_64), Desktop: GNOME Shell 46.0, Display Server: X Server 1.21.1.11 + Wayland, OpenGL: 4.6 Mesa 24.2.0-devel (LLVM 18.1.7 DRM 3.57), OpenCL: OpenCL 2.1 AMD-APP (3625.0), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 3840x2160

pgbench 17OpenBenchmarking.orgPhoronix Test SuiteAMD Ryzen 9 9950X 16-Core @ 5.75GHz (16 Cores / 32 Threads)ASUS ROG STRIX X670E-E GAMING WIFI (2401 BIOS)AMD Device 14d82 x 32GB DDR5-6400MT/s Corsair CMK64GX5M2B6400C324001GB Western Digital WD_BLACK SN850X 4000GB + Western Digital WD_BLACK SN850X 2000GB + 257GB Flash DriveAMD Radeon PRO W7900 45GB (2200/3200MHz)AMD Navi 31 HDMI/DPDELL U2723QEIntel I225-V + Intel Wi-Fi 6EUbuntu 24.046.10.1-061001-generic (x86_64)GNOME Shell 46.0X Server 1.21.1.11 + Wayland4.6 Mesa 24.2.0-devel (LLVM 18.1.7 DRM 3.57)OpenCL 2.1 AMD-APP (3625.0)GCC 13.2.0ext43840x2160ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLOpenCLCompilerFile-SystemScreen ResolutionPgbench 17 BenchmarksSystem Logs- Transparent Huge Pages: madvise- --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-backtrace --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-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/gcc-13-13.2.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 - Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xb404022- gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + 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; BHI: Not affected + srbds: Not affected + tsx_async_abort: Not affected

abcResult OverviewPhoronix Test Suite100%111%122%134%145%PostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQL1000 - 250 - Read Write1000 - 250 - Read Write - Average Latency100 - 250 - Read Write100 - 250 - Read Write - Average Latency1000 - 1000 - Read Write - Average Latency1000 - 1000 - Read Write100 - 500 - Read Write100 - 500 - Read Write - Average Latency100 - 1000 - Read Write100 - 1000 - Read Write - Average Latency1000 - 500 - Read Write1000 - 500 - Read Write - Average Latency100 - 800 - Read Write100 - 800 - Read Write - Average Latency1 - 800 - Read Write1 - 800 - Read Write - Average Latency1 - 1000 - Read Write1 - 1000 - Read Write - Average Latency1000 - 800 - Read Write - Average Latency1000 - 800 - Read Write1 - 500 - Read Write - Average Latency1 - 500 - Read Write100 - 1000 - Read Only100 - 1000 - Read Only - Average Latency1 - 1000 - Read Only1 - 1000 - Read Only - Average Latency1000 - 800 - Read Only1000 - 800 - Read Only - Average Latency1 - 800 - Read Only - Average Latency1 - 800 - Read Only1000 - 500 - Read Only1000 - 500 - Read Only - Average Latency1000 - 1000 - Read Only - Average Latency1000 - 1000 - Read Only100 - 500 - Read Only - Average Latency100 - 800 - Read Only - Average Latency100 - 500 - Read Only100 - 800 - Read Only1000 - 250 - Read Only - Average Latency1 - 500 - Read Only - Average Latency1000 - 250 - Read Only1 - 250 - Read Write1 - 250 - Read Write - Average Latency1 - 500 - Read Only1 - 250 - Read Only100 - 250 - Read Only100 - 250 - Read Only - Average Latency1 - 250 - Read Only - Average Latency

pgbench 17pgbench: 1000 - 1000 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Writepgbench: 1000 - 800 - Read Write - Average Latencypgbench: 1000 - 800 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 1000 - Read Write - Average Latencypgbench: 100 - 1000 - Read Writepgbench: 1 - 800 - Read Write - Average Latencypgbench: 1 - 800 - Read Writepgbench: 1 - 1000 - Read Write - Average Latencypgbench: 1 - 1000 - Read Writepgbench: 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: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 100 - 1000 - Read Only - Average Latencypgbench: 100 - 1000 - Read Onlypgbench: 100 - 800 - Read Only - Average Latencypgbench: 100 - 800 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 1 - 1000 - Read Only - Average Latencypgbench: 1 - 1000 - Read Onlypgbench: 1 - 800 - Read Only - Average Latencypgbench: 1 - 800 - Read Onlypgbench: 1 - 500 - Read Only - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlyabc59.0971701049.0081636730.7251641310.5522419510.69846782189.37026435.0954921524.98240100476.5861687775.622130218.223439231.0219799840.70411363990.37013519880.17114665390.65015396810.43318495410.23621149850.11421956600.55817920860.37221485590.206242431969.17836140.100249489868.4131472152.9271526935.2531429813.5731878111.10645173190.82426235.4454609626.75437542523.0301547739.733135218.404434871.0129884220.71511183600.37413372230.17014731040.65715210130.43118578100.23721095800.11421900800.55917874890.37721232610.207241620369.41636010.100248793156.7551762050.6491579531.0531610114.9531671912.57839751179.72727826.5223833228.96934520531.8661504802.511124620.667387081.0149866230.71611165720.3713509140.1714694040.66615009770.4318614810.23821010530.11421954490.54918211560.37621252390.207242029369.44136000.12493234OpenBenchmarking.org

PostgreSQL

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latencycba1530456075SE +/- 1.72, N = 12SE +/- 1.31, N = 1256.7668.4159.101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read Writecba4K8K12K16K20KSE +/- 376.89, N = 12SE +/- 363.42, N = 121762014721170101. (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 Latencycba1224364860SE +/- 1.57, N = 12SE +/- 0.75, N = 1250.6552.9349.011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 800 - Mode: Read Writecba4K8K12K16K20KSE +/- 476.46, N = 12SE +/- 259.50, N = 121579515269163671. (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 Latencycba816243240SE +/- 0.93, N = 12SE +/- 0.83, N = 1231.0535.2530.731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 500 - Mode: Read Writecba4K8K12K16K20KSE +/- 396.90, N = 12SE +/- 470.97, N = 121610114298164131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latencycba48121620SE +/- 0.52, N = 12SE +/- 0.46, N = 1214.9513.5710.551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 250 - Mode: Read Writecba5K10K15K20K25KSE +/- 866.55, N = 12SE +/- 1066.06, N = 121671918781241951. (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 Latencycba3691215SE +/- 0.20, N = 12SE +/- 0.10, N = 1212.5811.1110.701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 500 - Mode: Read Writecba10K20K30K40K50KSE +/- 767.55, N = 12SE +/- 423.61, N = 123975145173467821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latencycba4080120160200SE +/- 1.82, N = 12SE +/- 1.96, N = 12179.73190.82189.371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 500 - Mode: Read Writecba6001200180024003000SE +/- 24.95, N = 12SE +/- 26.98, N = 122782262326431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latencycba246810SE +/- 0.107, N = 12SE +/- 0.098, N = 96.5225.4455.0951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 250 - Mode: Read Writecba11K22K33K44K55KSE +/- 859.18, N = 12SE +/- 939.45, N = 93833246096492151. (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 Latencycba714212835SE +/- 0.61, N = 9SE +/- 0.33, N = 1228.9726.7524.981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 1000 - Mode: Read Writecba9K18K27K36K45KSE +/- 895.95, N = 9SE +/- 495.47, N = 123452037542401001. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latencycba110220330440550SE +/- 15.74, N = 12SE +/- 11.98, N = 9531.87523.03476.591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 800 - Mode: Read Writecba400800120016002000SE +/- 54.21, N = 12SE +/- 39.53, N = 91504154716871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latencycba2004006008001000SE +/- 7.48, N = 3SE +/- 26.61, N = 9802.51739.73775.621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 1000 - Mode: Read Writecba30060090012001500SE +/- 13.81, N = 3SE +/- 45.33, N = 91246135213021. (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 Latencycba510152025SE +/- 0.26, N = 3SE +/- 0.18, N = 620.6718.4018.221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 800 - Mode: Read Writecba9K18K27K36K45KSE +/- 623.85, N = 3SE +/- 432.88, N = 63870843487439231. (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 Latencycba0.22970.45940.68910.91881.1485SE +/- 0.001, N = 3SE +/- 0.000, N = 31.0141.0121.0211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read Onlycba200K400K600K800K1000KSE +/- 915.22, N = 3SE +/- 417.48, N = 39866239884229799841. (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 Latencycba0.16110.32220.48330.64440.8055SE +/- 0.003, N = 3SE +/- 0.001, N = 30.7160.7150.7041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 800 - Mode: Read Onlycba200K400K600K800K1000KSE +/- 3974.94, N = 3SE +/- 2328.08, N = 31116572111836011363991. (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 Latencycba0.08420.16840.25260.33680.421SE +/- 0.001, N = 3SE +/- 0.000, N = 30.3700.3740.3701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latencycba0.03850.0770.11550.1540.1925SE +/- 0.000, N = 3SE +/- 0.001, N = 30.1700.1700.1711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 250 - Mode: Read Onlycba300K600K900K1200K1500KSE +/- 1078.77, N = 3SE +/- 4725.59, N = 31469404147310414665391. (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 Latencycba0.14990.29980.44970.59960.7495SE +/- 0.004, N = 3SE +/- 0.006, N = 30.6660.6570.6501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 1000 - Mode: Read Onlycba300K600K900K1200K1500KSE +/- 8728.08, N = 3SE +/- 15024.56, N = 31500977152101315396811. (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 Latencycba0.09740.19480.29220.38960.487SE +/- 0.002, N = 3SE +/- 0.001, N = 30.4300.4310.4331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 800 - Mode: Read Onlycba400K800K1200K1600K2000KSE +/- 9393.57, N = 3SE +/- 5849.59, N = 31861481185781018495411. (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.05360.10720.16080.21440.268SE +/- 0.001, N = 3SE +/- 0.000, N = 30.2380.2370.2361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

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

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 250 - Mode: Read Onlycba500K1000K1500K2000K2500KSE +/- 3331.36, N = 3SE +/- 1687.85, N = 32195449219008021956601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 1000 - Mode: Read Onlycba400K800K1200K1600K2000KSE +/- 22211.60, N = 3SE +/- 14228.54, N = 31821156178748917920861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 800 - Mode: Read Onlycba500K1000K1500K2000K2500KSE +/- 2523.67, N = 3SE +/- 7009.02, N = 32125239212326121485591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 500 - Mode: Read Onlycba500K1000K1500K2000K2500KSE +/- 2420.49, N = 3SE +/- 2047.09, N = 32420293241620324243191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latencycba1530456075SE +/- 0.06, N = 3SE +/- 0.39, N = 369.4469.4269.181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 250 - Mode: Read Writecba8001600240032004000SE +/- 2.88, N = 3SE +/- 20.50, N = 33600360136141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latencycba0.02250.0450.06750.090.1125SE +/- 0.000, N = 3SE +/- 0.000, N = 30.1000.1000.1001. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 250 - Mode: Read Onlycba500K1000K1500K2000K2500KSE +/- 4949.97, N = 3SE +/- 4585.03, N = 32493234248793124948981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

48 Results Shown

PostgreSQL:
  1000 - 1000 - Read Write - Average Latency
  1000 - 1000 - Read Write
  1000 - 800 - Read Write - Average Latency
  1000 - 800 - Read Write
  1000 - 500 - Read Write - Average Latency
  1000 - 500 - Read Write
  1000 - 250 - Read Write - Average Latency
  1000 - 250 - Read Write
  100 - 500 - Read Write - Average Latency
  100 - 500 - Read Write
  1 - 500 - Read Write - Average Latency
  1 - 500 - Read Write
  100 - 250 - Read Write - Average Latency
  100 - 250 - Read Write
  100 - 1000 - Read Write - Average Latency
  100 - 1000 - Read Write
  1 - 800 - Read Write - Average Latency
  1 - 800 - Read Write
  1 - 1000 - Read Write - Average Latency
  1 - 1000 - Read Write
  100 - 800 - Read Write - Average Latency
  100 - 800 - Read Write
  1000 - 1000 - Read Only - Average Latency
  1000 - 1000 - Read Only
  1000 - 800 - Read Only - Average Latency
  1000 - 800 - Read Only
  1000 - 500 - Read Only - Average Latency
  1000 - 500 - Read Only
  1000 - 250 - Read Only - Average Latency
  1000 - 250 - Read Only
  100 - 1000 - Read Only - Average Latency
  100 - 1000 - Read Only
  100 - 800 - Read Only - Average Latency
  100 - 800 - Read Only
  100 - 500 - Read Only - Average Latency
  100 - 500 - Read Only
  100 - 250 - Read Only - Average Latency
  100 - 250 - Read Only
  1 - 1000 - Read Only - Average Latency
  1 - 1000 - Read Only
  1 - 800 - Read Only - Average Latency
  1 - 800 - Read Only
  1 - 500 - Read Only - Average Latency
  1 - 500 - Read Only
  1 - 250 - Read Write - Average Latency
  1 - 250 - Read Write
  1 - 250 - Read Only - Average Latency
  1 - 250 - Read Only

a

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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-backtrace --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-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/gcc-13-13.2.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 Notes: Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xb404022
Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + 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; BHI: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 27 September 2024 02:28 by user pts.

b

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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-backtrace --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-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/gcc-13-13.2.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 Notes: Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xb404022
Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + 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; BHI: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 27 September 2024 09:25 by user pts.

c

Processor: AMD Ryzen 9 9950X 16-Core @ 5.75GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (2401 BIOS), Chipset: AMD Device 14d8, Memory: 2 x 32GB DDR5-6400MT/s Corsair CMK64GX5M2B6400C32, Disk: 4001GB Western Digital WD_BLACK SN850X 4000GB + Western Digital WD_BLACK SN850X 2000GB + 257GB Flash Drive, Graphics: AMD Radeon PRO W7900 45GB (2200/3200MHz), Audio: AMD Navi 31 HDMI/DP, Monitor: DELL U2723QE, Network: Intel I225-V + Intel Wi-Fi 6E

OS: Ubuntu 24.04, Kernel: 6.10.1-061001-generic (x86_64), Desktop: GNOME Shell 46.0, Display Server: X Server 1.21.1.11 + Wayland, OpenGL: 4.6 Mesa 24.2.0-devel (LLVM 18.1.7 DRM 3.57), OpenCL: OpenCL 2.1 AMD-APP (3625.0), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 3840x2160

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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-backtrace --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-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/gcc-13-13.2.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 Notes: Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xb404022
Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + 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; BHI: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 27 September 2024 16:06 by user pts.