1013-04

sql

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

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
1013-04
October 13 2021
  27 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

1013-04

Processor: Phytium D2000/8 E8C @ 2.30GHz (8 Cores), Motherboard: GreatWall GW-001Y1A-FTH v1.0 (KunLun BIOS V4.0 BIOS), Memory: 8GB, Disk: 512GB Western Digital PC SN530 SDBPNPZ-512G + 15GB DataTraveler 2.0, Graphics: AMD Caicos 2GB, Audio: Realtek ALC269VB

OS: Kylin v10, Kernel: 5.4.18-23-generic (aarch64), Display Server: X Server 1.20.8, OpenGL: 3.3 Mesa 20.0.8 (LLVM 9.0.1), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1920x1080

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --build=aarch64-linux-gnu --disable-libquadmath --disable-libquadmath-support --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-fix-cortex-a53-843419 --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-plugin --enable-shared --enable-threads=posix --host=aarch64-linux-gnu --program-prefix=aarch64-linux-gnu- --target=aarch64-linux-gnu --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-target-system-zlib=auto -v
Processor Notes: Scaling Governor: scpi-cpufreq performance
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Vulnerable + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Vulnerable + tsx_async_abort: Not affected

1013-04OpenBenchmarking.orgPhoronix Test SuitePhytium D2000/8 E8C @ 2.30GHz (8 Cores)GreatWall GW-001Y1A-FTH v1.0 (KunLun BIOS V4.0 BIOS)8GB512GB Western Digital PC SN530 SDBPNPZ-512G + 15GB DataTraveler 2.0AMD Caicos 2GBRealtek ALC269VBKylin v105.4.18-23-generic (aarch64)X Server 1.20.83.3 Mesa 20.0.8 (LLVM 9.0.1)GCC 9.3.0ext41920x1080ProcessorMotherboardMemoryDiskGraphicsAudioOSKernelDisplay ServerOpenGLCompilerFile-SystemScreen Resolution1013-04 BenchmarksSystem Logs- Transparent Huge Pages: madvise- --build=aarch64-linux-gnu --disable-libquadmath --disable-libquadmath-support --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-fix-cortex-a53-843419 --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-plugin --enable-shared --enable-threads=posix --host=aarch64-linux-gnu --program-prefix=aarch64-linux-gnu- --target=aarch64-linux-gnu --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-target-system-zlib=auto -v - Scaling Governor: scpi-cpufreq performance- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Vulnerable + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Vulnerable + tsx_async_abort: Not affected

1013-04pgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 1 - Read Write1013-040.096103970.8691152OpenBenchmarking.org

PostgreSQL pgbench

This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency1013-040.02160.04320.06480.08640.108SE +/- 0.001, N = 30.0961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only1013-042K4K6K8K10KSE +/- 72.75, N = 3103971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency1013-040.19550.3910.58650.7820.9775SE +/- 0.002, N = 30.8691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write1013-042004006008001000SE +/- 2.62, N = 311521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

1013-04

Processor: Phytium D2000/8 E8C @ 2.30GHz (8 Cores), Motherboard: GreatWall GW-001Y1A-FTH v1.0 (KunLun BIOS V4.0 BIOS), Memory: 8GB, Disk: 512GB Western Digital PC SN530 SDBPNPZ-512G + 15GB DataTraveler 2.0, Graphics: AMD Caicos 2GB, Audio: Realtek ALC269VB

OS: Kylin v10, Kernel: 5.4.18-23-generic (aarch64), Display Server: X Server 1.20.8, OpenGL: 3.3 Mesa 20.0.8 (LLVM 9.0.1), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1920x1080

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --build=aarch64-linux-gnu --disable-libquadmath --disable-libquadmath-support --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-fix-cortex-a53-843419 --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-plugin --enable-shared --enable-threads=posix --host=aarch64-linux-gnu --program-prefix=aarch64-linux-gnu- --target=aarch64-linux-gnu --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-target-system-zlib=auto -v
Processor Notes: Scaling Governor: scpi-cpufreq performance
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Vulnerable + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Vulnerable + tsx_async_abort: Not affected

Testing initiated at 13 October 2021 03:00 by user zkxx.