We are pleased to announce the first stable release of Pg_QoS, a PostgreSQL extension that provides Quality of Service (QoS) style resource governance for sessions and queries.
🔹 Project overview
Enforce per-role and per-database limits via ALTER ROLE/DATABASE SET qos.*
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 work_mem per session
Fast, reliable cache invalidation across sessions (no reconnect) using a shared epoch mechanism
This makes it easier to ensure fair resource allocation across different workloads running on the same PostgreSQL instance.
🔹 Requirements
PostgreSQL 15 or newer (officially supported)
Build toolchain and server headers (pg_config must be available)
Linux for CPU limiting
🔹 Packages
Native packages are now available for the following distributions:
Debian 13 (Trixie)
Ubuntu 24.04 (Noble Numbat)
Red Hat Enterprise Linux (RHEL) 10
AlmaLinux 10
CentOS Stream 10
Packages can be found in the repository releases section and cover all PostgreSQL versions supported by Pg_QoS (15 and newer).
