PostgreSQL QoS Resource Governor

We are pleased to announce the first beta release of Pg_QoS, a PostgreSQL extension that provides Quality of Service (QoS) style resource governance for sessions and queries.

Project Overview

Pg_QoS helps ensure more stable operation of the entire PostgreSQL instance/cluster by limiting resource usage, so that different workloads interfere with each other less.

Enforce per-role and per-database limits via ALTER ROLE/DATABASE SET qos.*

Per-database/role:

• Limit CPU usage by binding the backend to N CPU cores (Linux only); planner integration ensures parallel workers stay within that cap
• Track and cap concurrent transactions and statements (SELECT/UPDATE/DELETE/INSERT)
• Limit for setting work_mem parameter

Requirements

• PostgreSQL 15 or newer (officially supported)
• Build toolchain and server headers (pg_config must be available)
• Linux for CPU limiting

Repository

https://github.com/appstonia/pg_qos

Status

This is an beta release intended for early testing and feedback. We welcome comments, suggestions, and contributions from the community.

Note: As development is ongoing, please build and use the latest version from the main branch whenever possible.

We'd love to hear your feedback via Github issues.