pgbench_more

Loongson-3A5000-HV testing with a Loongson Loongson-LS3A5000-7A2000-1w-EVB-V1.21 (Loongson-UDK2018-V2.0.05269-beta8 BIOS) and llvmpipe on Loongnix 20 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 2305248-NE-PGBENCHMO80
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
Loongson-3A5000-HV - llvmpipe - Loongson
May 20 2023
  5 Hours, 52 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):

Loongson-3A5000-HV - llvmpipe - Loongson

Processor: Loongson-3A5000-HV (4 Cores), Motherboard: Loongson Loongson-LS3A5000-7A2000-1w-EVB-V1.21 (Loongson-UDK2018-V2.0.05269-beta8 BIOS), Chipset: Loongson LLC Hyper Transport Bridge, Memory: 16GB, Disk: QUANXING N200 256GB, Graphics: llvmpipe, Audio: Loongson LLC Device 7a37, Network: Loongson LLC Device 7a13

OS: Loongnix 20, Kernel: 4.19.0-19-loongson-3 (loongarch64), Display Server: X Server 1.20.4, OpenGL: 3.3 Mesa 18.3.6 (LLVM 8.0 256 bits), Compiler: GCC 8.3.0, File-System: xfs, Screen Resolution: 1920x1080

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=loongarch64-linux-gnu --disable-emultls --disable-host-shared --disable-libitm --disable-libquadmath --disable-libquadmath-support --disable-libsanitizer --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-languages=c,c++,fortran --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-plugin --enable-shared --enable-threads=posix --enable-tls --host=loongarch64-linux-gnu --program-prefix=loongarch64-linux-gnu- --target=loongarch64-linux-gnu --with-abi=lp64 --with-arch=loongarch64 --with-default-libstdcxx-abi=new --with-gcc-major-version-only -v

pgbench_moreOpenBenchmarking.orgPhoronix Test SuiteLoongson-3A5000-HV (4 Cores)Loongson Loongson-LS3A5000-7A2000-1w-EVB-V1.21 (Loongson-UDK2018-V2.0.05269-beta8 BIOS)Loongson LLC Hyper Transport Bridge16GBQUANXING N200 256GBllvmpipeLoongson LLC Device 7a37Loongson LLC Device 7a13Loongnix 204.19.0-19-loongson-3 (loongarch64)X Server 1.20.43.3 Mesa 18.3.6 (LLVM 8.0 256 bits)GCC 8.3.0xfs1920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDisplay ServerOpenGLCompilerFile-SystemScreen ResolutionPgbench_more BenchmarksSystem Logs- Transparent Huge Pages: always- --build=loongarch64-linux-gnu --disable-emultls --disable-host-shared --disable-libitm --disable-libquadmath --disable-libquadmath-support --disable-libsanitizer --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-languages=c,c++,fortran --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-plugin --enable-shared --enable-threads=posix --enable-tls --host=loongarch64-linux-gnu --program-prefix=loongarch64-linux-gnu- --target=loongarch64-linux-gnu --with-abi=lp64 --with-arch=loongarch64 --with-default-libstdcxx-abi=new --with-gcc-major-version-only -v

pgbench_morepgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 1000 - Read Writepgbench: 1 - 1000 - Read Write - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 100 - 1000 - Read Writepgbench: 100 - 1000 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Writepgbench: 1000 - 1000 - Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson87157.426840119.0613041649.8261506682.864485010.313480920.7963545141.047200824.9062395417.729239641.7512752181.7132684372.556OpenBenchmarking.org

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson2004006008001000SE +/- 5.08, N = 38711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson1326395265SE +/- 0.33, N = 357.431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson2004006008001000SE +/- 7.63, N = 38401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson306090120150SE +/- 1.09, N = 3119.061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson70140210280350SE +/- 3.85, N = 123041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson400800120016002000SE +/- 21.31, N = 121649.831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1000 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson306090120150SE +/- 2.91, N = 121501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson14002800420056007000SE +/- 135.30, N = 126682.861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson10002000300040005000SE +/- 57.15, N = 448501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson3691215SE +/- 0.12, N = 410.311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson10002000300040005000SE +/- 36.06, N = 348091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson510152025SE +/- 0.16, N = 320.801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson8001600240032004000SE +/- 14.39, N = 335451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson306090120150SE +/- 0.57, N = 3141.051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson400800120016002000SE +/- 23.65, N = 420081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson612182430SE +/- 0.29, N = 424.911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1000 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson5001000150020002500SE +/- 29.90, N = 423951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson90180270360450SE +/- 5.25, N = 4417.731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson5001000150020002500SE +/- 31.21, N = 323961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson1020304050SE +/- 0.54, N = 341.751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson6001200180024003000SE +/- 17.03, N = 327521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson4080120160200SE +/- 1.12, N = 3181.711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1000 - Mode: Read WriteLoongson-3A5000-HV - llvmpipe - Loongson6001200180024003000SE +/- 14.05, N = 326841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average LatencyLoongson-3A5000-HV - llvmpipe - Loongson80160240320400SE +/- 1.95, N = 3372.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Loongson-3A5000-HV - llvmpipe - Loongson

Processor: Loongson-3A5000-HV (4 Cores), Motherboard: Loongson Loongson-LS3A5000-7A2000-1w-EVB-V1.21 (Loongson-UDK2018-V2.0.05269-beta8 BIOS), Chipset: Loongson LLC Hyper Transport Bridge, Memory: 16GB, Disk: QUANXING N200 256GB, Graphics: llvmpipe, Audio: Loongson LLC Device 7a37, Network: Loongson LLC Device 7a13

OS: Loongnix 20, Kernel: 4.19.0-19-loongson-3 (loongarch64), Display Server: X Server 1.20.4, OpenGL: 3.3 Mesa 18.3.6 (LLVM 8.0 256 bits), Compiler: GCC 8.3.0, File-System: xfs, Screen Resolution: 1920x1080

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=loongarch64-linux-gnu --disable-emultls --disable-host-shared --disable-libitm --disable-libquadmath --disable-libquadmath-support --disable-libsanitizer --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-languages=c,c++,fortran --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-plugin --enable-shared --enable-threads=posix --enable-tls --host=loongarch64-linux-gnu --program-prefix=loongarch64-linux-gnu- --target=loongarch64-linux-gnu --with-abi=lp64 --with-arch=loongarch64 --with-default-libstdcxx-abi=new --with-gcc-major-version-only -v

Testing initiated at 20 May 2023 06:50 by user liupe.