pgbench core i9 Intel Core i9-7960X testing with a MSI X299 SLI PLUS (MS-7A93) v1.0 (1.A0 BIOS) and Gigabyte AMD Radeon RX 550/550X 2GB on Ubuntu 19.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/1910078-PTS-PGBENCHC60&gru .
pgbench core i9 Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X Intel Core i9-7960X @ 4.40GHz (16 Cores / 32 Threads) MSI X299 SLI PLUS (MS-7A93) v1.0 (1.A0 BIOS) Intel Sky Lake-E DMI3 Registers 16384MB 256GB INTEL SSDPEKKW256G8 Gigabyte AMD Radeon RX 550/550X 2GB (1206/1750MHz) Realtek ALC1220 ASUS VP28U Intel I219-V + Intel I211 Ubuntu 19.04 5.0.20-050020-generic (x86_64) GNOME Shell 3.32.0 X Server 1.20.4 modesetting 1.20.4 4.5 Mesa 19.0.2 (LLVM 8.0.0) GCC 8.3.0 ext4 3840x2160 OpenBenchmarking.org - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v - Scaling Governor: intel_pstate powersave - l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling
pgbench core i9 pgbench: Mostly RAM - Normal Load - Read Only pgbench: Buffer Test - Normal Load - Read Only pgbench: Mostly RAM - Normal Load - Read Write pgbench: Buffer Test - Normal Load - Read Write pgbench: Mostly RAM - Single Thread - Read Only pgbench: Buffer Test - Single Thread - Read Only pgbench: Mostly RAM - Single Thread - Read Write pgbench: Buffer Test - Single Thread - Read Write pgbench: Mostly RAM - Heavy Contention - Read Only pgbench: Buffer Test - Heavy Contention - Read Only pgbench: Mostly RAM - Heavy Contention - Read Write pgbench: Buffer Test - Heavy Contention - Read Write Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 66175.71 447153.05 3201.59 11511.44 4668.62 28952.55 597.70 1474.43 66807.33 445421.54 3443.55 12906.75 OpenBenchmarking.org
PostgreSQL pgbench Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 14K 28K 42K 56K 70K SE +/- 426.52, N = 3 66175.71 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Normal Load - Mode: Read Only Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 100K 200K 300K 400K 500K SE +/- 222.64, N = 3 447153.05 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 700 1400 2100 2800 3500 SE +/- 89.32, N = 9 3201.59 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 2K 4K 6K 8K 10K SE +/- 535.37, N = 12 11511.44 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 1000 2000 3000 4000 5000 SE +/- 9.89, N = 3 4668.62 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 6K 12K 18K 24K 30K SE +/- 69.28, N = 3 28952.55 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 130 260 390 520 650 SE +/- 119.21, N = 7 597.70 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 300 600 900 1200 1500 SE +/- 27.26, N = 15 1474.43 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 14K 28K 42K 56K 70K SE +/- 71.08, N = 3 66807.33 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 100K 200K 300K 400K 500K SE +/- 1238.42, N = 3 445421.54 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 700 1400 2100 2800 3500 SE +/- 71.07, N = 9 3443.55 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write Intel Core i9-7960X - Gigabyte AMD Radeon RX 550/550X 3K 6K 9K 12K 15K SE +/- 167.16, N = 3 12906.75 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
Phoronix Test Suite v10.8.4