20240623pgbench

2 x INTEL XEON PLATINUM 8592+ testing with a Quanta Cloud QuantaGrid D54Q-2U S6Q-MB-MPS (3B03.TEL0P1 BIOS) and ASPEED on Ubuntu 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 2406248-NE-20240623P01
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
run0
June 23
  13 Minutes
run1
June 23
  16 Hours, 59 Minutes
Invert Behavior (Only Show Selected Data)
  8 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):

run0

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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 Notes: CPU Microcode: 0x21000070
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 + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS; IBPB: conditional; RSB filling; PBRSB-eIBRS: SW sequence; BHI: BHI_DIS_S + srbds: Not affected + tsx_async_abort: Not affected

run1

Processor: 2 x INTEL XEON PLATINUM 8592+ (128 Cores / 256 Threads), Motherboard: Quanta Cloud QuantaGrid D54Q-2U S6Q-MB-MPS (3B03.TEL0P1 BIOS), Chipset: Intel Device 1bce, Memory: 1008GB, Disk: 3841GB SAMSUNG MZQL23T8HCLS-00A07, Graphics: ASPEED, Monitor: VE247, Network: 2 x Intel X710 for 10GBASE-T + 2 x Mellanox MT2892

OS: Ubuntu 22.04, Kernel: 5.15.0-107-generic (x86_64), Vulkan: 1.3.255, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1600x1200

20240623pgbenchOpenBenchmarking.orgPhoronix Test Suite2 x INTEL XEON PLATINUM 8592+ (128 Cores / 256 Threads)Quanta Cloud QuantaGrid D54Q-2U S6Q-MB-MPS (3B03.TEL0P1 BIOS)Intel Device 1bce1008GB3841GB SAMSUNG MZQL23T8HCLS-00A07ASPEEDVE2472 x Intel X710 for 10GBASE-T + 2 x Mellanox MT2892Ubuntu 22.045.15.0-107-generic (x86_64)1.3.255GCC 11.4.0ext41600x1200ProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelVulkanCompilerFile-SystemScreen Resolution20240623pgbench 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 - CPU Microcode: 0x21000070- gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS; IBPB: conditional; RSB filling; PBRSB-eIBRS: SW sequence; BHI: BHI_DIS_S + srbds: Not affected + tsx_async_abort: Not affected

20240623pgbenchpgbench: 10000 - 1000 - Read Write - Average Latencypgbench: 10000 - 500 - Read Write - Average Latencypgbench: 10000 - 250 - Read Write - Average Latencypgbench: 10000 - 1000 - Read Only - Average Latencypgbench: 10000 - 100 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Write - Average Latencypgbench: 10000 - 500 - Read Only - Average Latencypgbench: 10000 - 250 - Read Only - Average Latencypgbench: 10000 - 100 - Read Only - Average Latencypgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Only - Average Latencypgbench: 1000 - 100 - Read Write - Average Latencypgbench: 100 - 1000 - Read Write - Average Latencypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 100 - Read Only - Average Latencypgbench: 10000 - 1000 - Read Writepgbench: 10000 - 500 - Read Writepgbench: 10000 - 250 - Read Writepgbench: 10000 - 1000 - Read Onlypgbench: 10000 - 100 - Read Writepgbench: 1000 - 1000 - Read Writepgbench: 10000 - 500 - Read Onlypgbench: 10000 - 250 - Read Onlypgbench: 10000 - 100 - Read Onlypgbench: 1000 - 500 - Read Writepgbench: 1000 - 250 - Read Writepgbench: 1000 - 1000 - Read Onlypgbench: 1000 - 100 - Read Writepgbench: 100 - 1000 - Read Writepgbench: 1000 - 500 - Read Onlypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 100 - Read Onlypgbench: 100 - 500 - Read Writepgbench: 100 - 250 - Read Writepgbench: 100 - 100 - Read Writepgbench: 100 - 250 - Read Onlypgbench: 100 - 100 - Read Onlypgbench: 100 - 1000 - Read Only - Average Latencypgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 1000 - Read Onlypgbench: 100 - 500 - Read Onlyrun0run141.13320.1026.2560.8641.83635.1670.4170.1980.07313.6694.6110.7731.31613.8210.3590.1610.0595.9772.8181.0680.2430.05424315248773996111566055446228446119883512631951373132365885422512943907598672352139340815521201701057836588870593665102811318598681.2240.617820021816037OpenBenchmarking.org

PostgreSQL

This is a benchmark of PostgreSQL using the integrated pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 1000 - Mode: Read Write - Average Latencyrun1918273645SE +/- 0.34, N = 341.131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 500 - Mode: Read Write - Average Latencyrun1510152025SE +/- 0.18, N = 320.101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 250 - Mode: Read Write - Average Latencyrun1246810SE +/- 0.016, N = 36.2561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 1000 - Mode: Read Only - Average Latencyrun10.19440.38880.58320.77760.972SE +/- 0.008, N = 30.8641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 100 - Mode: Read Write - Average Latencyrun10.41310.82621.23931.65242.0655SE +/- 0.008, N = 31.8361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latencyrun1816243240SE +/- 0.46, N = 335.171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average Latencyrun10.09380.18760.28140.37520.469SE +/- 0.004, N = 30.4171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 250 - Mode: Read Only - Average Latencyrun10.04460.08920.13380.17840.223SE +/- 0.001, N = 30.1981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 100 - Mode: Read Only - Average Latencyrun10.01640.03280.04920.06560.082SE +/- 0.001, N = 30.0731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latencyrun148121620SE +/- 0.16, N = 313.671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latencyrun11.03752.0753.11254.155.1875SE +/- 0.034, N = 34.6111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latencyrun10.17390.34780.52170.69560.8695SE +/- 0.010, N = 30.7731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latencyrun10.29610.59220.88831.18441.4805SE +/- 0.003, N = 31.3161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latencyrun148121620SE +/- 0.02, N = 313.821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latencyrun10.08080.16160.24240.32320.404SE +/- 0.001, N = 30.3591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latencyrun10.03620.07240.10860.14480.181SE +/- 0.001, N = 30.1611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latencyrun10.01330.02660.03990.05320.0665SE +/- 0.000, N = 30.0591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latencyrun11.34482.68964.03445.37926.724SE +/- 0.009, N = 35.9771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latencyrun10.63411.26821.90232.53643.1705SE +/- 0.022, N = 32.8181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencyrun10.24030.48060.72090.96121.2015SE +/- 0.003, N = 31.0681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencyrun10.05470.10940.16410.21880.2735SE +/- 0.002, N = 30.2431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencyrun10.01220.02440.03660.04880.061SE +/- 0.000, N = 30.0541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 1000 - Mode: Read Writerun15K10K15K20K25KSE +/- 203.86, N = 3243151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 10000 - Clients: 1000 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 500 - Mode: Read Writerun15K10K15K20K25KSE +/- 225.12, N = 3248771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 10000 - Clients: 500 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 250 - Mode: Read Writerun19K18K27K36K45KSE +/- 104.10, N = 3399611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 10000 - Clients: 250 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 1000 - Mode: Read Onlyrun1200K400K600K800K1000KSE +/- 10769.79, N = 311566051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 10000 - Clients: 1000 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 100 - Mode: Read Writerun112K24K36K48K60KSE +/- 220.61, N = 3544621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 10000 - Clients: 100 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Writerun16K12K18K24K30KSE +/- 373.27, N = 3284461. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 500 - Mode: Read Onlyrun1300K600K900K1200K1500KSE +/- 11758.54, N = 311988351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 10000 - Clients: 500 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 250 - Mode: Read Onlyrun1300K600K900K1200K1500KSE +/- 3628.85, N = 312631951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 10000 - Clients: 250 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 10000 - Clients: 100 - Mode: Read Onlyrun1300K600K900K1200K1500KSE +/- 8740.53, N = 313731321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 10000 - Clients: 100 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Writerun18K16K24K32K40KSE +/- 419.60, N = 3365881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 1000 - Clients: 500 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Writerun112K24K36K48K60KSE +/- 402.82, N = 3542251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 1000 - Clients: 250 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Onlyrun1300K600K900K1200K1500KSE +/- 15948.34, N = 312943901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 100 - Mode: Read Writerun116K32K48K64K80KSE +/- 162.77, N = 3759861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Writerun115K30K45K60K75KSE +/- 99.80, N = 3723521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 100 - Clients: 1000 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Onlyrun1300K600K900K1200K1500KSE +/- 4423.35, N = 313934081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 1000 - Clients: 500 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Onlyrun1300K600K900K1200K1500KSE +/- 14126.79, N = 315521201. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 1000 - Clients: 250 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 100 - Mode: Read Onlyrun1400K800K1200K1600K2000KSE +/- 6522.45, N = 317010571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Writerun120K40K60K80K100KSE +/- 130.34, N = 3836581. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 100 - Clients: 500 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Writerun120K40K60K80K100KSE +/- 680.73, N = 3887051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 100 - Clients: 250 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Writerun120K40K60K80K100KSE +/- 216.71, N = 3936651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 100 - Clients: 100 - Mode: Read Write

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Onlyrun1200K400K600K800K1000KSE +/- 7356.90, N = 310281131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 100 - Clients: 250 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Onlyrun1400K800K1200K1600K2000KSE +/- 11872.84, N = 318598681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 100 - Clients: 100 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latencyrun10.27540.55080.82621.10161.377SE +/- 0.023, N = 121.2241. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latencyrun10.13880.27760.41640.55520.694SE +/- 0.017, N = 90.6171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Onlyrun1200K400K600K800K1000KSE +/- 15174.23, N = 128200211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 100 - Clients: 1000 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Onlyrun1200K400K600K800K1000KSE +/- 23411.05, N = 98160371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Scaling Factor: 100 - Clients: 500 - Mode: Read Only

run0: The test run did not produce a result. E: ./pgbench: 21: pg_/bin/pgbench: not found

48 Results Shown

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

run0

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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 Notes: CPU Microcode: 0x21000070
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 + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS; IBPB: conditional; RSB filling; PBRSB-eIBRS: SW sequence; BHI: BHI_DIS_S + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 23 June 2024 11:36 by user devcloud.

run1

Processor: 2 x INTEL XEON PLATINUM 8592+ (128 Cores / 256 Threads), Motherboard: Quanta Cloud QuantaGrid D54Q-2U S6Q-MB-MPS (3B03.TEL0P1 BIOS), Chipset: Intel Device 1bce, Memory: 1008GB, Disk: 3841GB SAMSUNG MZQL23T8HCLS-00A07, Graphics: ASPEED, Monitor: VE247, Network: 2 x Intel X710 for 10GBASE-T + 2 x Mellanox MT2892

OS: Ubuntu 22.04, Kernel: 5.15.0-107-generic (x86_64), Vulkan: 1.3.255, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1600x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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 Notes: CPU Microcode: 0x21000070
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 + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS; IBPB: conditional; RSB filling; PBRSB-eIBRS: SW sequence; BHI: BHI_DIS_S + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 23 June 2024 13:18 by user devcloud.