postgres-esxljdb2-32cpu-localdisk-10000-500

VMware testing on Red Hat Enterprise Linux 9.4 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 2411114-NE-POSTGRESE52
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
32 x INTEL XEON GOLD 6548N - VMware SVGA II - Intel
November 10
  6 Hours, 32 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):


postgres-esxljdb2-32cpu-localdisk-10000-500OpenBenchmarking.orgPhoronix Test Suite32 x INTEL XEON GOLD 6548N (63 Cores)Intel VMware7 1 440BX (VMW71.00V.21100432.B64.2301110304 BIOS)Intel 440BX/ZX/DX25 x 16 GB DRAM VMware Virtual RAM VMW-16384MB322GB Virtual diskVMware SVGA IIVMware VMXNET3Red Hat Enterprise Linux 9.45.14.0-427.42.1.el9_4.x86_64 (x86_64)GCC 11.4.1 20231218xfs1280x800VMwareProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem LayerPostgres-esxljdb2-32cpu-localdisk-10000-500 BenchmarksSystem Logs- Transparent Huge Pages: always- --build=x86_64-redhat-linux --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-host-bind-now --enable-host-pie --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-link-serialization=1 --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-arch_64=x86-64-v2 --with-build-config=bootstrap-lto --with-gcc-major-version-only --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver --without-isl - CPU Microcode: 0x21000240- gather_data_sampling: Not affected + itlb_multihit: KVM: Mitigation of VMX unsupported + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Unknown: No mitigations + 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; RSB filling; PBRSB-eIBRS: SW sequence; BHI: SW loop KVM: SW loop + srbds: Not affected + tsx_async_abort: Not affected

postgres-esxljdb2-32cpu-localdisk-10000-500pgbench: 10000 - 500 - Read Onlypgbench: 10000 - 500 - Read Only - Average Latencypgbench: 10000 - 500 - Read Writepgbench: 10000 - 500 - Read Write - Average Latency32 x INTEL XEON GOLD 6548N - VMware SVGA II - Intel9497870.526971351.566OpenBenchmarking.org

PostgreSQL

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 10000 - Clients: 500 - Mode: Read Only32 x INTEL XEON GOLD 6548N - VMware SVGA II - Intel200K400K600K800K1000KSE +/- 955.00, N = 39497871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average Latency32 x INTEL XEON GOLD 6548N - VMware SVGA II - Intel0.11840.23680.35520.47360.592SE +/- 0.000, N = 30.5261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 10000 - Clients: 500 - Mode: Read Write32 x INTEL XEON GOLD 6548N - VMware SVGA II - Intel2K4K6K8K10KSE +/- 177.80, N = 697131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 10000 - Clients: 500 - Mode: Read Write - Average Latency32 x INTEL XEON GOLD 6548N - VMware SVGA II - Intel1224364860SE +/- 0.96, N = 651.571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm