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.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2301168-NE-PG953829376
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
Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 -
January 16 2023
  4 Hours, 39 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):


pgOpenBenchmarking.orgPhoronix Test SuiteIntel 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.6ext43840x2160ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelCompilerFile-SystemScreen ResolutionPg BenchmarksSystem Logs- 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: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 50 - Read WriteIntel Core i9-13900KF - NVIDIA GeForce RTX 4090 -1.388360251.063470440.4691065360.3961263263.42614608OpenBenchmarking.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 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

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

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

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

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

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

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

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

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

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