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.

HTML result view exported from: https://openbenchmarking.org/result/2407272-NE-BARE1PSQL21&rdt&grr.

bare1psqlProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionAMD EPYC 7443P 24-Core - Matrox G200eW3 - Dellbare1psqlAMD 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.0ext41024x768OpenBenchmarking.orgKernel Details- mpt3sas.max_queue_depth=1000 - Transparent Huge Pages: madviseCompiler Details- --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 Details- CPU Microcode: 0xa0011d3Security Details- 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: 8 - 500hammerdb-postgresql: 8 - 500hammerdb-postgresql: 64 - 500hammerdb-postgresql: 64 - 500hammerdb-postgresql: 32 - 500hammerdb-postgresql: 32 - 500hammerdb-postgresql: 16 - 500hammerdb-postgresql: 16 - 500hammerdb-postgresql: 8 - 250hammerdb-postgresql: 8 - 250hammerdb-postgresql: 16 - 250hammerdb-postgresql: 16 - 250hammerdb-postgresql: 64 - 250hammerdb-postgresql: 64 - 250hammerdb-postgresql: 32 - 250hammerdb-postgresql: 32 - 250hammerdb-postgresql: 8 - 100hammerdb-postgresql: 8 - 100hammerdb-postgresql: 64 - 100hammerdb-postgresql: 64 - 100hammerdb-postgresql: 16 - 100hammerdb-postgresql: 16 - 100hammerdb-postgresql: 32 - 100hammerdb-postgresql: 32 - 100AMD EPYC 7443P 24-Core - Matrox G200eW3 - Dellbare1psql131590356794414400046254622242048972933213695492901621006619118101427896620579232737110118502069205899549224638797765614480036297312245736976883227832398903623778141033943OpenBenchmarking.org

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 1000

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 1000

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 500

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 500

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

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 500

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

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 500

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

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 500

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

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 500

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

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 500

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

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 500

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 100

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

Phoronix Test Suite v10.8.5