PostgreSQL And Friends On Windows Intel Core i9-7980XE testing with a ASUS PRIME X299-A and AMD Radeon R9 Fury 4095MB on Microsoft Windows 10 Pro Build 16299 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/1803182-PTS-POSTGRES76 .
PostgreSQL And Friends On Windows Processor Motherboard Memory Disk Graphics Network OS Kernel Display Driver OpenCL Vulkan Compiler File-System Screen Resolution INTEL SSDPEKKW256G8 - Intel Core i9-7980XE Intel Core i9-7980XE @ 2.59GHz (18 Cores / 36 Threads) ASUS PRIME X299-A 4 x 4096 MB 3200MHz Corsair CMK16GX4M4C3200C16 238GB INTEL SSDPEKKW256G8 AMD Radeon R9 Fury 4095MB Intel Connection I219-V Microsoft Windows 10 Pro Build 16299 10.0 (x86_64) 23.20.15017.3010 OpenCL 2.1 AMD-APP (2527.8) 1.0.65 GCC 7.1.0 + Clang 6.0.0 NTFS 3840x2160 OpenBenchmarking.org - python is not recognized as an internal or external command operable program or batch file.
PostgreSQL And Friends On Windows sqlite: Timed SQLite Insertions scimark2: Composite scimark2: Monte Carlo scimark2: Fast Fourier Transform scimark2: Sparse Matrix Multiply scimark2: Dense LU Matrix Factorization scimark2: Jacobi Successive Over-Relaxation primesieve: 1e12 Prime Number Generation perl-benchmark: Pod2html perl-benchmark: Interpreter rbenchmark: 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 pybench: Total For Average Test Times phpbench: PHP Benchmark Suite sunflow: Global Illumination + Image Synthesis INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 65.38 680.92 142.97 267.16 759.18 1036.41 1198.86 15.45 0.17877654 0.04552229 0.6949 166005.49 158971.88 6469.08 2999.05 22834.08 12756.51 363.32 838.78 152147.53 148160.87 6078.86 2922.15 1260 367619 0.99 OpenBenchmarking.org
SQLite Timed SQLite Insertions OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.22 Timed SQLite Insertions INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 15 30 45 60 75 SE +/- 0.96, N = 5 65.38
SciMark Computational Test: Composite OpenBenchmarking.org Mflops, More Is Better SciMark 2.0 Computational Test: Composite INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 150 300 450 600 750 SE +/- 0.56, N = 3 680.92
SciMark Computational Test: Monte Carlo OpenBenchmarking.org Mflops, More Is Better SciMark 2.0 Computational Test: Monte Carlo INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 30 60 90 120 150 SE +/- 0.20, N = 3 142.97
SciMark Computational Test: Fast Fourier Transform OpenBenchmarking.org Mflops, More Is Better SciMark 2.0 Computational Test: Fast Fourier Transform INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 60 120 180 240 300 SE +/- 1.49, N = 3 267.16
SciMark Computational Test: Sparse Matrix Multiply OpenBenchmarking.org Mflops, More Is Better SciMark 2.0 Computational Test: Sparse Matrix Multiply INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 160 320 480 640 800 SE +/- 1.50, N = 3 759.18
SciMark Computational Test: Dense LU Matrix Factorization OpenBenchmarking.org Mflops, More Is Better SciMark 2.0 Computational Test: Dense LU Matrix Factorization INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 200 400 600 800 1000 SE +/- 2.22, N = 3 1036.41
SciMark Computational Test: Jacobi Successive Over-Relaxation OpenBenchmarking.org Mflops, More Is Better SciMark 2.0 Computational Test: Jacobi Successive Over-Relaxation INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 300 600 900 1200 1500 SE +/- 2.43, N = 3 1198.86
Primesieve 1e12 Prime Number Generation OpenBenchmarking.org Seconds, Fewer Is Better Primesieve 6.2 1e12 Prime Number Generation INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 4 8 12 16 20 SE +/- 0.03, N = 3 15.45
Perl Benchmarks Test: Pod2html OpenBenchmarking.org Seconds, Fewer Is Better Perl Benchmarks Test: Pod2html INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 0.0402 0.0804 0.1206 0.1608 0.201 SE +/- 0.00026522, N = 3 0.17877654
Perl Benchmarks Test: Interpreter OpenBenchmarking.org Seconds, Fewer Is Better Perl Benchmarks Test: Interpreter INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 0.0102 0.0204 0.0306 0.0408 0.051 SE +/- 0.00017322, N = 3 0.04552229
R Benchmark OpenBenchmarking.org Seconds, Fewer Is Better R Benchmark INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 0.1564 0.3128 0.4692 0.6256 0.782 SE +/- 0.0040, N = 3 0.6949 1. R scripting front-end version 3.4.3 (2017-11-30)
PostgreSQL pgbench Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 40K 80K 120K 160K 200K SE +/- 570.98, N = 3 166005.49
PostgreSQL pgbench Scaling: Buffer Test - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Only INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 30K 60K 90K 120K 150K SE +/- 112.99, N = 3 158971.88
PostgreSQL pgbench Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 1400 2800 4200 5600 7000 SE +/- 44.23, N = 3 6469.08
PostgreSQL pgbench Scaling: Buffer Test - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 600 1200 1800 2400 3000 SE +/- 86.04, N = 6 2999.05
PostgreSQL pgbench Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 5K 10K 15K 20K 25K SE +/- 177.28, N = 3 22834.08
PostgreSQL pgbench Scaling: Buffer Test - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 3K 6K 9K 12K 15K SE +/- 87.05, N = 3 12756.51
PostgreSQL pgbench Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 80 160 240 320 400 SE +/- 5.76, N = 3 363.32
PostgreSQL pgbench Scaling: Buffer Test - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 200 400 600 800 1000 SE +/- 19.18, N = 6 838.78
PostgreSQL pgbench Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 30K 60K 90K 120K 150K SE +/- 307.35, N = 3 152147.53
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 30K 60K 90K 120K 150K SE +/- 421.65, N = 3 148160.87
PostgreSQL pgbench Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 1300 2600 3900 5200 6500 SE +/- 23.42, N = 3 6078.86
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 600 1200 1800 2400 3000 SE +/- 37.17, N = 3 2922.15
PyBench Total For Average Test Times OpenBenchmarking.org Milliseconds, Fewer Is Better PyBench 2018-02-16 Total For Average Test Times INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 300 600 900 1200 1500 SE +/- 3.28, N = 3 1260
PHPBench PHP Benchmark Suite OpenBenchmarking.org Score, More Is Better PHPBench 0.8.1 PHP Benchmark Suite INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 80K 160K 240K 320K 400K SE +/- 1755.06, N = 3 367619
Sunflow Rendering System Global Illumination + Image Synthesis OpenBenchmarking.org Seconds, Fewer Is Better Sunflow Rendering System 0.07.2 Global Illumination + Image Synthesis INTEL SSDPEKKW256G8 - Intel Core i9-7980XE 0.2228 0.4456 0.6684 0.8912 1.114 SE +/- 0.02, N = 3 0.99
Phoronix Test Suite v10.8.4