pgbench1 AMD Ryzen 9 5950X 16-Core testing with a X570S PG Riptide and NVIDIA RTX A2000 6GB on FreeBSD 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 2309174-NE-PGBENCH1350 AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - Processor: AMD Ryzen 9 5950X 16-Core @ 3.40GHz (32 Cores), Motherboard: X570S PG Riptide, Chipset: AMD [AMD] Starship/Matisse Root Complex, Memory: 64GB, Disk: 2 x Generic NVMe Device, Graphics: NVIDIA RTX A2000 6GB, Audio: NVIDIA (0x228e) HDA, Monitor: Mi Monitor
OS: FreeBSD, Kernel: 13.2-STABLE (x86_64), Desktop: KDE Plasma 5.27.8, Display Server: X Server 1.21.1.8, Display Driver: NVIDIA 535.104.05, OpenGL: 4.6.0, Compiler: GCC 12.2.0 + Clang 16.0.6, File-System: zfs, Screen Resolution: 3440x1440
Environment Notes: RUSTFLAGS="-C target-cpu=native" CGO_LDFLAGS="-s -w"Compiler Notes: --build=x86_64-portbld-freebsd13.2 --disable-nls --enable-gnu-indirect-function --enable-host-shared --enable-languages=c,c++,objc,fortran,jit --enable-multilib --enable-plugin --localstatedir=/var --mandir=/usr/local/man --with-as=/usr/local/bin/as --with-build-config=bootstrap-lto-noplugin --with-gmp=/usr/local --with-gxx-libcxx-include-dir=/usr/include/c++/v1 --with-ld=/usr/local/bin/ld --without-zstd
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 16 Scaling Factor: 1 - Clients: 1 - Mode: Read Only AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 15K 30K 45K 60K 75K SE +/- 3660.10, N = 12 72206 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 0.0034 0.0068 0.0102 0.0136 0.017 SE +/- 0.001, N = 12 0.015 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 1 - Mode: Read Write AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 100 200 300 400 500 SE +/- 1.34, N = 3 465 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 0.484 0.968 1.452 1.936 2.42 SE +/- 0.006, N = 3 2.151 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 300K 600K 900K 1200K 1500K SE +/- 3636.46, N = 3 1417743 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 0.0079 0.0158 0.0237 0.0316 0.0395 SE +/- 0.000, N = 3 0.035 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 300K 600K 900K 1200K 1500K SE +/- 2358.18, N = 3 1174697 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 0.0191 0.0382 0.0573 0.0764 0.0955 SE +/- 0.000, N = 3 0.085 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 110 220 330 440 550 SE +/- 1.47, N = 3 487 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 20 40 60 80 100 SE +/- 0.31, N = 3 102.73 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Only AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 20K 40K 60K 80K 100K SE +/- 359.32, N = 3 78190 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 0.0029 0.0058 0.0087 0.0116 0.0145 SE +/- 0.000, N = 3 0.013 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 100 200 300 400 500 SE +/- 1.06, N = 3 480 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 50 100 150 200 250 SE +/- 0.46, N = 3 208.27 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Write AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 100 200 300 400 500 SE +/- 1.30, N = 3 445 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 0.5054 1.0108 1.5162 2.0216 2.527 SE +/- 0.007, N = 3 2.246 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 300K 600K 900K 1200K 1500K SE +/- 4070.87, N = 3 1257811 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 0.009 0.018 0.027 0.036 0.045 SE +/- 0.00, N = 3 0.04 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 200K 400K 600K 800K 1000K SE +/- 4400.14, N = 3 1107171 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 0.0203 0.0406 0.0609 0.0812 0.1015 SE +/- 0.000, N = 3 0.090 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 1600 3200 4800 6400 8000 SE +/- 141.53, N = 12 7587 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 2 4 6 8 10 SE +/- 0.126, N = 12 6.616 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 2K 4K 6K 8K 10K SE +/- 327.52, N = 12 9994 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - 3 6 9 12 15 SE +/- 0.34, N = 12 10.13 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lexecinfo -lm
AMD Ryzen 9 5950X 16-Core - NVIDIA RTX A2000 6GB - Processor: AMD Ryzen 9 5950X 16-Core @ 3.40GHz (32 Cores), Motherboard: X570S PG Riptide, Chipset: AMD [AMD] Starship/Matisse Root Complex, Memory: 64GB, Disk: 2 x Generic NVMe Device, Graphics: NVIDIA RTX A2000 6GB, Audio: NVIDIA (0x228e) HDA, Monitor: Mi Monitor
OS: FreeBSD, Kernel: 13.2-STABLE (x86_64), Desktop: KDE Plasma 5.27.8, Display Server: X Server 1.21.1.8, Display Driver: NVIDIA 535.104.05, OpenGL: 4.6.0, Compiler: GCC 12.2.0 + Clang 16.0.6, File-System: zfs, Screen Resolution: 3440x1440
Environment Notes: RUSTFLAGS="-C target-cpu=native" CGO_LDFLAGS="-s -w"Compiler Notes: --build=x86_64-portbld-freebsd13.2 --disable-nls --enable-gnu-indirect-function --enable-host-shared --enable-languages=c,c++,objc,fortran,jit --enable-multilib --enable-plugin --localstatedir=/var --mandir=/usr/local/man --with-as=/usr/local/bin/as --with-build-config=bootstrap-lto-noplugin --with-gmp=/usr/local --with-gxx-libcxx-include-dir=/usr/include/c++/v1 --with-ld=/usr/local/bin/ld --without-zstd
Testing initiated at 17 September 2023 22:36 by user user.