pgtest2

3A6000

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2311254-NE-PGTEST20292
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
3A6000
November 24 2023
  4 Hours, 53 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):

3A6000

Processor: Loongson-3A6000-HV @ 2.50GHz (4 Cores / 8 Threads), Motherboard: O.E.M (Loongson-UDK2018-V4.0.05569-stable202308 BIOS), Chipset: Loongson LLC Hyper Transport Bridge, Memory: 16GB, Disk: SSD 512GB, Graphics: llvmpipe, Audio: Loongson LLC Device 7a37, Network: Realtek RTL8111/8168/8411

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: 1536x864

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
Processor Notes: Scaling Governor: acpi-cpufreq performance

pgtest2OpenBenchmarking.orgPhoronix Test SuiteLoongson-3A6000-HV @ 2.50GHz (4 Cores / 8 Threads)O.E.M (Loongson-UDK2018-V4.0.05569-stable202308 BIOS)Loongson LLC Hyper Transport Bridge16GBSSD 512GBllvmpipeLoongson LLC Device 7a37Realtek RTL8111/8168/8411Loongnix 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.0xfs1536x864ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDisplay ServerOpenGLCompilerFile-SystemScreen ResolutionPgtest2 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 - Scaling Governor: acpi-cpufreq performance

pgtest2pgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latency3A6000302470.03321890.4571556490.3211577130.634255619.564276880.036220745.32019160.5231449810.3451449360.690115804.356111659.001OpenBenchmarking.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: 1 - Mode: Read Only3A60006K12K18K24K30KSE +/- 108.37, N = 3302471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency3A60000.00740.01480.02220.02960.037SE +/- 0.000, N = 30.0331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Write3A60005001000150020002500SE +/- 8.10, N = 321891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Only3A600030K60K90K120K150KSE +/- 772.93, N = 31556491. (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 Only - Average Latency3A60000.07220.14440.21660.28880.361SE +/- 0.002, N = 30.3211. (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 Only3A600030K60K90K120K150KSE +/- 1735.37, N = 31577131. (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 Only - Average Latency3A60000.14270.28540.42810.57080.7135SE +/- 0.007, N = 30.6341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Write3A60005001000150020002500SE +/- 25.26, N = 325561. (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 Latency3A6000510152025SE +/- 0.19, N = 319.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Only3A60006K12K18K24K30KSE +/- 32.53, N = 3276881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency3A60000.00810.01620.02430.03240.0405SE +/- 0.000, N = 30.0361. (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 Write3A60005001000150020002500SE +/- 13.74, N = 322071. (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 Latency3A60001020304050SE +/- 0.28, N = 345.321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Write3A6000400800120016002000SE +/- 28.62, N = 1219161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency3A60000.11770.23540.35310.47080.5885SE +/- 0.009, N = 120.5231. (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 Only3A600030K60K90K120K150KSE +/- 543.16, N = 31449811. (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 Only - Average Latency3A60000.07760.15520.23280.31040.388SE +/- 0.001, N = 30.3451. (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 Only3A600030K60K90K120K150KSE +/- 1316.88, N = 31449361. (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 Only - Average Latency3A60000.15530.31060.46590.62120.7765SE +/- 0.006, N = 30.6901. (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 Write3A60002K4K6K8K10KSE +/- 346.17, N = 12115801. (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 Latency3A60000.98011.96022.94033.92044.9005SE +/- 0.117, N = 124.3561. (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 Write3A60002K4K6K8K10KSE +/- 233.58, N = 12111651. (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 Latency3A60003691215SE +/- 0.190, N = 129.0011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

3A6000

Processor: Loongson-3A6000-HV @ 2.50GHz (4 Cores / 8 Threads), Motherboard: O.E.M (Loongson-UDK2018-V4.0.05569-stable202308 BIOS), Chipset: Loongson LLC Hyper Transport Bridge, Memory: 16GB, Disk: SSD 512GB, Graphics: llvmpipe, Audio: Loongson LLC Device 7a37, Network: Realtek RTL8111/8168/8411

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: 1536x864

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
Processor Notes: Scaling Governor: acpi-cpufreq performance

Testing initiated at 24 November 2023 19:36 by user liupe.