postgresql-100Scalingfactor-100Clients-rw-alma84

KVM testing on AlmaLinux 8.4 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 2110196-YANN-POSTGRE62
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
postgresql-100Scalingfactor-100Clients-rw-alma84
October 19 2021
  15 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):


postgresql-100Scalingfactor-100Clients-rw-alma84OpenBenchmarking.orgPhoronix Test SuiteCommon KVM (8 Cores)QEMU Standard PC (i440FX + PIIX 1996) (rel-1.14.0-0-g155821a1990b-prebuilt.qemu.org BIOS)Intel 440FX 82441FX PMC8GB21GB QEMU HDDbochs-drmdrmfbQEMU MonitorRed Hat Virtio deviceAlmaLinux 8.44.18.0-305.19.1.el8_4.x86_64 (x86_64)GCC 8.4.1 20200928xfs1024x768KVMProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem LayerPostgresql-100Scalingfactor-100Clients-rw-alma84 BenchmarksSystem Logs- Transparent Huge Pages: always- CPU Microcode: 0x1000065- SELinux + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Not affected + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline STIBP: disabled RSB filling + srbds: Not affected + tsx_async_abort: Not affected

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 Writepostgresql-100Scalingfactor-100Clients-rw-alma843K6K9K12K15KSE +/- 53.82, N = 3132541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencypostgresql-100Scalingfactor-100Clients-rw-alma84246810SE +/- 0.030, N = 37.5451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm