pgbench-rvapc04-01

AMD Athlon 3000G testing with a ASRock B450 Gaming-ITX/ac (P3.70 BIOS) and AMD Picasso 2GB on Fedora 31 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 1912259-HU-PGBENCHRV67
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
pgbench-rvapc04-01
December 25 2019
  4 Hours, 6 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):


pgbench-rvapc04-01OpenBenchmarking.orgPhoronix Test SuiteAMD Athlon 3000G @ 3.50GHz (2 Cores / 4 Threads)ASRock B450 Gaming-ITX/ac (P3.70 BIOS)AMD Raven/Raven26144MB120GB KINGSTON SA400M8AMD Picasso 2GB (1100MHz)AMD Raven/Raven2/FenghuangIntel I211 + Intel Dual Band-AC 3168NGWFedora 315.3.16-300.fc31.x86_64 (x86_64)X Server 1.20.6modesetting 1.20.6GCC 9.2.1 20190827ext4ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDisplay ServerDisplay DriverCompilerFile-SystemPgbench-rvapc04-01 BenchmarksSystem Logs- --build=x86_64-redhat-linux --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,fortran,objc,obj-c++,ada,go,d,lto --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=i686 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver - Scaling Governor: acpi-cpufreq ondemand - CPU Microcode: 0x8108109 - SELinux + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional STIBP: disabled RSB filling + tsx_async_abort: Not affected

pgbench-rvapc04-01pgbench: Mostly RAM - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Single Thread - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: Mostly RAM - Single Thread - Read Writepgbench: Buffer Test - Single Thread - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - Read Writepgbench-rvapc04-0113805.14549245602.1118571209.8443522592.4664282714.62079715525.891585426.732238616.17808820903.58357944084.1847891672.2461154675.088777OpenBenchmarking.org

PostgreSQL pgbench

This is a simple benchmark of PostgreSQL using pgbench. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Mostly RAM - Test: Normal Load - Mode: Read Onlypgbench-rvapc04-013K6K9K12K15KSE +/- 94.98, N = 313805.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Normal Load - Mode: Read Onlypgbench-rvapc04-0110K20K30K40K50KSE +/- 124.68, N = 345602.111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Mostly RAM - Test: Normal Load - Mode: Read Writepgbench-rvapc04-0130060090012001500SE +/- 17.74, N = 31209.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Normal Load - Mode: Read Writepgbench-rvapc04-016001200180024003000SE +/- 12.88, N = 32592.471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Mostly RAM - Test: Single Thread - Mode: Read Onlypgbench-rvapc04-016001200180024003000SE +/- 8.25, N = 32714.621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Single Thread - Mode: Read Onlypgbench-rvapc04-013K6K9K12K15KSE +/- 42.94, N = 315525.891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Mostly RAM - Test: Single Thread - Mode: Read Writepgbench-rvapc04-0190180270360450SE +/- 6.68, N = 3426.731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Single Thread - Mode: Read Writepgbench-rvapc04-01130260390520650SE +/- 0.40, N = 3616.181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Onlypgbench-rvapc04-014K8K12K16K20KSE +/- 150.45, N = 320903.581. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Onlypgbench-rvapc04-019K18K27K36K45KSE +/- 144.39, N = 344084.181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Writepgbench-rvapc04-01400800120016002000SE +/- 22.02, N = 31672.251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Writepgbench-rvapc04-0110002000300040005000SE +/- 22.13, N = 34675.091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm