Glossary / TPS (Transactions Per Second)

TPS (Transactions Per Second)

Practical PostgreSQL glossary entry with a clear definition, example, and benchmarking context.

What Is TPS (Transactions Per Second)?

TPS is a metric indicating how many transactions a PostgreSQL database processes per second. It's commonly used to benchmark and evaluate system throughput under load. Higher TPS suggests better database performance under concurrent access.

Why It Matters for PostgreSQL Performance

In PostgreSQL performance work, TPS (Transactions Per Second) affects throughput, latency, or operational reliability depending on workload and configuration.

Practical Benchmarking Context

When benchmarking with pgbench, track how TPS (Transactions Per Second) changes behavior across scale factor, client concurrency, and storage conditions.

Use this term together with workload shape, concurrency level, and scale factor when interpreting pgbench outputs. Isolated values can be misleading without full run context.

Example

Reported by: pgbench and monitoring tools.

Related Resources