pg

Intel Core i9-13900KF testing with a ASUS ProArt Z790-CREATOR WIFI (0704 BIOS) and NVIDIA GeForce RTX 4090 on Arch Linux via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2301168-NE-PG953829376&grr.

pgProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelCompilerFile-SystemScreen ResolutionIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -Intel Core i9-13900KF @ 6.20GHz (24 Cores / 32 Threads)ASUS ProArt Z790-CREATOR WIFI (0704 BIOS)Intel Device 7a27128GB2048GB SAMSUNG MZVL22T0HBLB-00B00NVIDIA GeForce RTX 4090Realtek ALC1220Aquantia AQC113CS NBase-T/IEEE + Intel I226-V + Intel Wi-Fi 6 AX210/AX211/AX411Arch Linux6.1.5-xanmod1 (x86_64)GCC 12.2.0 + Clang 14.0.6 + LLVM 14.0.6ext43840x2160OpenBenchmarking.org- Transparent Huge Pages: always- --disable-libssp --disable-libstdcxx-pch --disable-werror --enable-__cxa_atexit --enable-bootstrap --enable-cet=auto --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-default-ssp --enable-gnu-indirect-function --enable-gnu-unique-object --enable-languages=c,c++,ada,fortran,go,lto,objc,obj-c++,d --enable-libstdcxx-backtrace --enable-link-serialization=1 --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-build-config=bootstrap-lto --with-linker-hash-style=gnu - Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0x10e- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Vulnerable: __user pointer sanitization and usercopy barriers only; no swapgs barriers + spectre_v2: Vulnerable IBPB: disabled STIBP: disabled PBRSB-eIBRS: Vulnerable + srbds: Not affected + tsx_async_abort: Not affected

pgpgbench: 25000 - 50 - Read Write - Average Latencypgbench: 25000 - 50 - Read Writepgbench: 10000 - 50 - Read Write - Average Latencypgbench: 10000 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 50 - Read WriteIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -1.388360251.063470443.426146080.4691065360.396126326OpenBenchmarking.org

PostgreSQL

Scaling Factor: 25000 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 50 - Mode: Read Write - Average LatencyIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -0.31230.62460.93691.24921.5615SE +/- 0.013, N = 31.3881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 25000 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 50 - Mode: Read WriteIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -8K16K24K32K40KSE +/- 337.90, N = 3360251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 50 - Mode: Read Write - Average LatencyIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -0.23920.47840.71760.95681.196SE +/- 0.001, N = 31.0631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 50 - Mode: Read WriteIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -10K20K30K40K50KSE +/- 43.72, N = 3470441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -0.77091.54182.31273.08363.8545SE +/- 0.030, N = 123.4261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read WriteIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -3K6K9K12K15KSE +/- 123.90, N = 12146081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -0.10550.2110.31650.4220.5275SE +/- 0.000, N = 30.4691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -20K40K60K80K100KSE +/- 89.44, N = 31065361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -0.08910.17820.26730.35640.4455SE +/- 0.004, N = 30.3961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read WriteIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -30K60K90K120K150KSE +/- 1381.69, N = 31263261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm


Phoronix Test Suite v10.8.4