pgbench0001

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 2209271-NE-PGBENCH0034
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
Postgre_Scaling_1000_Clients_100_250_500_RO_RW
September 27 2022
 
ARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-00
September 27 2022
  1 Hour, 47 Minutes
Invert Hiding All Results Option
  54 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):


pgbench0001OpenBenchmarking.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 ResolutionPgbench0001 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

pgbench0001pgbench: 1000 - 100 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average LatencyPostgre_Scaling_1000_Clients_100_250_500_RO_RWARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-009164750.1096222240.402512941.950439995.682OpenBenchmarking.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: 1000 - Clients: 100 - Mode: Read OnlyARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-00200K400K600K800K1000KSE +/- 11102.60, N = 49164751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-00130K260K390K520K650KSE +/- 4590.18, N = 36222241. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read WriteARMv8 Neoverse-N1 - ASPEED - GIGABYTE MP32-AR1-009K18K27K36K45KSE +/- 84.75, N = 3439991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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