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.
