BlackFlash - Postgres

Postgres pgbench with all options

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1809108-RA-0222266351
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
BF-PSQL
September 09 2018
  10 Minutes

BF-PSQL

Processor: Intel Xeon Gold 6142 @ 2.60GHz (64 Cores), Motherboard: Supermicro Super Server 0123456789, Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 97024MB, Disk: DC P3700 SSD [2.5" SFF], Graphics: ASPEED ASPEED Family, Audio: NVIDIA GF119 HDA

OS: FreeBSD, Kernel: 12.0-CURRENT (x86_64), Compiler: Clang 6.0.0 (SVN 323338), File-System: zfs, Screen Resolution: 1920x1200

Security Notes: KPTI Protection

BlackFlash - PostgresOpenBenchmarking.orgPhoronix Test SuiteIntel Xeon Gold 6142 @ 2.60GHz (64 Cores)Supermicro Super Server 0123456789Intel Sky Lake-E DMI3 Registers97024MBDC P3700 SSD [2.5" SFF]ASPEED ASPEED FamilyNVIDIA GF119 HDAFreeBSD12.0-CURRENT (x86_64)Clang 6.0.0 (SVN 323338)zfs1920x1200ProcessorMotherboardChipsetMemoryDiskGraphicsAudioOSKernelCompilerFile-SystemScreen ResolutionBlackFlash - Postgres PerformanceSystem Logs- KPTI Protection

PostgreSQL pgbench

This is a simple benchmark of PostgreSQL using pgbench. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read OnlyBF-PSQL20K40K60K80K100KSE +/- 1069.79, N = 379885.771. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lcrypt -lm

BF-PSQL

Processor: Intel Xeon Gold 6142 @ 2.60GHz (64 Cores), Motherboard: Supermicro Super Server 0123456789, Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 97024MB, Disk: DC P3700 SSD [2.5" SFF], Graphics: ASPEED ASPEED Family, Audio: NVIDIA GF119 HDA

OS: FreeBSD, Kernel: 12.0-CURRENT (x86_64), Compiler: Clang 6.0.0 (SVN 323338), File-System: zfs, Screen Resolution: 1920x1200

Security Notes: KPTI Protection

Testing initiated at 9 September 2018 16:40 by user root.