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 Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - Processor: Intel Core i9-13900KF @ 6.20GHz (24 Cores / 32 Threads), Motherboard: ASUS ProArt Z790-CREATOR WIFI (0704 BIOS), Chipset: Intel Device 7a27, Memory: 128GB, Disk: 2048GB SAMSUNG MZVL22T0HBLB-00B00, Graphics: NVIDIA GeForce RTX 4090, Audio: Realtek ALC1220, Network: Aquantia AQC113CS NBase-T/IEEE + Intel I226-V + Intel Wi-Fi 6 AX210/AX211/AX411
OS: Arch Linux, Kernel: 6.1.5-xanmod1 (x86_64), Compiler: GCC 12.2.0 + Clang 14.0.6 + LLVM 14.0.6, File-System: ext4, Screen Resolution: 3840x2160
Kernel Notes: Transparent Huge Pages: alwaysCompiler Notes: --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=gnuProcessor Notes: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0x10eSecurity Notes: 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
pg OpenBenchmarking.org Phoronix Test Suite Intel Core i9-13900KF @ 6.20GHz (24 Cores / 32 Threads) ASUS ProArt Z790-CREATOR WIFI (0704 BIOS) Intel Device 7a27 128GB 2048GB SAMSUNG MZVL22T0HBLB-00B00 NVIDIA GeForce RTX 4090 Realtek ALC1220 Aquantia AQC113CS NBase-T/IEEE + Intel I226-V + Intel Wi-Fi 6 AX210/AX211/AX411 Arch Linux 6.1.5-xanmod1 (x86_64) GCC 12.2.0 + Clang 14.0.6 + LLVM 14.0.6 ext4 3840x2160 Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Compiler File-System Screen Resolution Pg Benchmarks System 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
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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - 3K 6K 9K 12K 15K SE +/- 123.90, N = 12 14608 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - 0.7709 1.5418 2.3127 3.0836 3.8545 SE +/- 0.030, N = 12 3.426 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - 30K 60K 90K 120K 150K SE +/- 1381.69, N = 3 126326 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - 0.0891 0.1782 0.2673 0.3564 0.4455 SE +/- 0.004, N = 3 0.396 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - 20K 40K 60K 80K 100K SE +/- 89.44, N = 3 106536 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - 0.1055 0.211 0.3165 0.422 0.5275 SE +/- 0.000, N = 3 0.469 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - 10K 20K 30K 40K 50K SE +/- 43.72, N = 3 47044 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write - Average Latency Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - 0.2392 0.4784 0.7176 0.9568 1.196 SE +/- 0.001, N = 3 1.063 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 50 - Mode: Read Write Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - 8K 16K 24K 32K 40K SE +/- 337.90, N = 3 36025 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 50 - Mode: Read Write - Average Latency Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - 0.3123 0.6246 0.9369 1.2492 1.5615 SE +/- 0.013, N = 3 1.388 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Intel Core i9-13900KF - NVIDIA GeForce RTX 4090 - Processor: Intel Core i9-13900KF @ 6.20GHz (24 Cores / 32 Threads), Motherboard: ASUS ProArt Z790-CREATOR WIFI (0704 BIOS), Chipset: Intel Device 7a27, Memory: 128GB, Disk: 2048GB SAMSUNG MZVL22T0HBLB-00B00, Graphics: NVIDIA GeForce RTX 4090, Audio: Realtek ALC1220, Network: Aquantia AQC113CS NBase-T/IEEE + Intel I226-V + Intel Wi-Fi 6 AX210/AX211/AX411
OS: Arch Linux, Kernel: 6.1.5-xanmod1 (x86_64), Compiler: GCC 12.2.0 + Clang 14.0.6 + LLVM 14.0.6, File-System: ext4, Screen Resolution: 3840x2160
Kernel Notes: Transparent Huge Pages: alwaysCompiler Notes: --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=gnuProcessor Notes: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0x10eSecurity Notes: 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
Testing initiated at 16 January 2023 14:23 by user root.