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

VMware testing on Red Hat Enterprise Linux 9.4 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2411114-NE-POSTGRESE52&grr.

postgres-esxljdb2-32cpu-localdisk-10000-500ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem Layer32 x INTEL XEON GOLD 6548N - VMware SVGA II - Intel32 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 20231218xfs1280x800VMwareOpenBenchmarking.org- 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 Write - Average Latencypgbench: 10000 - 500 - Read Writepgbench: 10000 - 500 - Read Only - Average Latencypgbench: 10000 - 500 - Read Only32 x INTEL XEON GOLD 6548N - VMware SVGA II - Intel51.56697130.526949787OpenBenchmarking.org

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

Phoronix Test Suite v10.8.5