bare1psql

AMD EPYC 7443P 24-Core testing with a Dell PowerEdge C6525 0978PJ (2.14.1 BIOS) and Matrox G200eW3 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 2407272-NE-BARE1PSQL21
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

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
Disable Color Branding
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
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
AMD EPYC 7443P 24-Core - Matrox G200eW3 - Dell
July 25
 
bare1psql
July 25
  7 Hours, 12 Minutes
Invert Hiding All Results Option
  3 Hours, 36 Minutes
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):


bare1psqlOpenBenchmarking.orgPhoronix Test SuiteAMD EPYC 7443P 24-Core (24 Cores / 48 Threads)Dell PowerEdge C6525 0978PJ (2.14.1 BIOS)AMD Starship/Matisse8 x 32 GB DDR4-3200MT/s M393A4K40EB3-CWE2 x 1920GB Dell Ent NVMe CM6 RI 1.92TB + 2 x 480GB MZ7LH480HBHQ0D3Matrox G200eW32 x Broadcom BCM57414 NetXtreme-E 10Gb/25GbUbuntu 24.046.8.0-38-generic (x86_64)GCC 13.2.0ext41024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionBare1psql BenchmarksSystem Logs- mpt3sas.max_queue_depth=1000 - 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 - CPU Microcode: 0xa0011d3- 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: 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; IBRS_FW; STIBP: always-on; RSB filling; PBRSB-eIBRS: Not affected; BHI: Not affected + srbds: Not affected + tsx_async_abort: Not affected

bare1psqlhammerdb-postgresql: 8 - 1000hammerdb-postgresql: 8 - 1000hammerdb-postgresql: 64 - 500hammerdb-postgresql: 64 - 500hammerdb-postgresql: 64 - 250hammerdb-postgresql: 64 - 250hammerdb-postgresql: 64 - 100hammerdb-postgresql: 64 - 100hammerdb-postgresql: 32 - 500hammerdb-postgresql: 32 - 500hammerdb-postgresql: 32 - 250hammerdb-postgresql: 32 - 250hammerdb-postgresql: 32 - 100hammerdb-postgresql: 32 - 100hammerdb-postgresql: 16 - 500hammerdb-postgresql: 16 - 500hammerdb-postgresql: 16 - 250hammerdb-postgresql: 16 - 250hammerdb-postgresql: 16 - 100hammerdb-postgresql: 16 - 100hammerdb-postgresql: 8 - 500hammerdb-postgresql: 8 - 500hammerdb-postgresql: 8 - 250hammerdb-postgresql: 8 - 250hammerdb-postgresql: 8 - 100hammerdb-postgresql: 8 - 100AMD EPYC 7443P 24-Core - Matrox G200eW3 - Dellbare1psql131590356794422420489729332069205899549224573697688321369549290162246387977656237781410339432100661911810232737110118502278323989036144000462546214278966205791448003629731OpenBenchmarking.org

HammerDB - PostgreSQL

This is a benchmark of the PostgreSQL database server, making use of the HammerDB benchmarking / load testing tool. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 1000bare1psql300K600K900K1200K1500K13159031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 1000bare1psql120K240K360K480K600K5679441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 500bare1psql500K1000K1500K2000K2500K22420481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 500bare1psql200K400K600K800K1000K9729331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 250bare1psql400K800K1200K1600K2000K20692051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 250bare1psql200K400K600K800K1000K8995491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 100bare1psql500K1000K1500K2000K2500K22457361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 100bare1psql200K400K600K800K1000K9768831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 500bare1psql500K1000K1500K2000K2500K21369541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 500bare1psql200K400K600K800K1000K9290161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 250bare1psql500K1000K1500K2000K2500K22463871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 250bare1psql200K400K600K800K1000K9776561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 100bare1psql500K1000K1500K2000K2500K23778141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 100bare1psql200K400K600K800K1000K10339431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 500bare1psql400K800K1200K1600K2000K21006611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 500bare1psql200K400K600K800K1000K9118101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 250bare1psql500K1000K1500K2000K2500K23273711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 250bare1psql200K400K600K800K1000K10118501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 100bare1psql500K1000K1500K2000K2500K22783231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 100bare1psql200K400K600K800K1000K9890361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 500bare1psql300K600K900K1200K1500K14400041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 500bare1psql130K260K390K520K650K6254621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 250bare1psql300K600K900K1200K1500K14278961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 250bare1psql130K260K390K520K650K6205791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 100bare1psql300K600K900K1200K1500K14480031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 100bare1psql130K260K390K520K650K6297311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

26 Results Shown

HammerDB - PostgreSQL:
  8 - 1000:
    Transactions Per Minute
    New Orders Per Minute
  64 - 500:
    Transactions Per Minute
    New Orders Per Minute
  64 - 250:
    Transactions Per Minute
    New Orders Per Minute
  64 - 100:
    Transactions Per Minute
    New Orders Per Minute
  32 - 500:
    Transactions Per Minute
    New Orders Per Minute
  32 - 250:
    Transactions Per Minute
    New Orders Per Minute
  32 - 100:
    Transactions Per Minute
    New Orders Per Minute
  16 - 500:
    Transactions Per Minute
    New Orders Per Minute
  16 - 250:
    Transactions Per Minute
    New Orders Per Minute
  16 - 100:
    Transactions Per Minute
    New Orders Per Minute
  8 - 500:
    Transactions Per Minute
    New Orders Per Minute
  8 - 250:
    Transactions Per Minute
    New Orders Per Minute
  8 - 100:
    Transactions Per Minute
    New Orders Per Minute