pts/pgbench
PostgreSQL OLTP benchmark measuring transaction throughput and latency under pgbench.
Benchmark Profile
Type: Macro
Kernel subsystem: Filesystem I/O, memory management, scheduler
Coverage: Inferred from database transaction throughput and latency
Topology: Single role: executer
Overview
pgbench executes a TPC-B-like OLTP workload on PostgreSQL, sweeping scaling factor (dataset size), client count, and read/write mode. Sensitive to lock contention, memory pressure, and I/O subsystem changes.
Fastpath Parameters
Name |
Description |
|---|---|
test-profile |
PTS test profile string, e.g. ‘pts/pgbench-1.15.0’. |
preset-options |
PTS preset option indices controlling the sweep. Indices are into the option lists: scaling-factor (0=1, 1=100), clients (0=1, 3=250, 6=1000), run-mode (0=Read Write, 1=Read Only). Format: ‘pgbench.scaling-factor=<idx>;pgbench.clients=<idx>;pgbench.run-mode=<idx>’ |
rc-regex |
Regex to extract result class name components from pgbench output. |
rc-template |
Template to format the result class name, e.g. ‘Scale: {0} Clients: {1} {2}{3}{4}’. |
Result Classes
Result class names encode scaling factor, client count, and mode, for example ‘Scale: 1 Clients: 250 Read Write’ or ‘Scale: 1 Clients: 250 Read Write - Average Latency’.
Fastpath Metadata
Field |
Value |
|---|---|
Suite |
pts |
Name |
pgbench |
Type |
database |
Container Image |
registry.gitlab.arm.com/tooling/fastpath/containers/pts:v1.0 |
Documentation Path |
documentation/user-guide/benchmarkcatalog/pts-pgbench.rst |
Documentation URL |
https://fastpath.docs.arm.com/user-guide/benchmarkcatalog/pts-pgbench.html |