postgres100100

ARMv8 Neoverse-N1 testing with a GIGABYTE MP32-AR1-00 v01010101 (F18w16 SCP: 1.08.20211002 BIOS) and ASPEED on Debian unstable 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 2209306-NE-POSTGRES138
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
Performance Per
Dollar
Date
Run
  Test
  Duration
ARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-00
September 30 2022
  29 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):

ARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-00

Processor: ARMv8 Neoverse-N1 @ 3.00GHz (80 Cores), Motherboard: GIGABYTE MP32-AR1-00 v01010101 (F18w16 SCP: 1.08.20211002 BIOS), Chipset: Ampere Computing LLC Altra PCI Root Complex A, Memory: 256GB, Disk: 2 x 3841GB SAMSUNG MZQL23T8HCLS-00A07, Graphics: ASPEED, Network: 2 x Intel I350

OS: Debian unstable, Kernel: 5.19.0-2-arm64 (aarch64), Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 800x600

Kernel Notes: Transparent Huge Pages: always
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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc=auto --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: cppc_cpufreq performance (Boost: Disabled)
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of CSV2 BHB + srbds: Not affected + tsx_async_abort: Not affected

postgres100100OpenBenchmarking.orgPhoronix Test SuiteARMv8 Neoverse-N1 @ 3.00GHz (80 Cores)GIGABYTE MP32-AR1-00 v01010101 (F18w16 SCPAmpere Computing LLC Altra PCI Root Complex A256GB2 x 3841GB SAMSUNG MZQL23T8HCLS-00A07ASPEED2 x Intel I350Debian unstable5.19.0-2-arm64 (aarch64)GCC 12.2.0ext4800x600ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionPostgres100100 BenchmarksSystem Logs- Transparent Huge Pages: always- --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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc=auto --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: cppc_cpufreq performance (Boost: Disabled)- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of CSV2 BHB + srbds: Not affected + tsx_async_abort: Not affected

postgres100100pgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average LatencyARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-0012090820.083566961.764OpenBenchmarking.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.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-00300K600K900K1200K1500KSE +/- 4305.17, N = 312090821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-000.01870.03740.05610.07480.0935SE +/- 0.000, N = 30.0831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read WriteARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-0012K24K36K48K60KSE +/- 195.42, N = 3566961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-000.39690.79381.19071.58761.9845SE +/- 0.006, N = 31.7641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

ARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-00

Processor: ARMv8 Neoverse-N1 @ 3.00GHz (80 Cores), Motherboard: GIGABYTE MP32-AR1-00 v01010101 (F18w16 SCP: 1.08.20211002 BIOS), Chipset: Ampere Computing LLC Altra PCI Root Complex A, Memory: 256GB, Disk: 2 x 3841GB SAMSUNG MZQL23T8HCLS-00A07, Graphics: ASPEED, Network: 2 x Intel I350

OS: Debian unstable, Kernel: 5.19.0-2-arm64 (aarch64), Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 800x600

Kernel Notes: Transparent Huge Pages: always
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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc=auto --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: cppc_cpufreq performance (Boost: Disabled)
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of CSV2 BHB + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 30 September 2022 14:31 by user jhi.