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). 🔹 **Repository** [https://github.com/appstonia/pg_qos](https://github.com/appstonia/pg_qos) We welcome comments, suggestions, and contributions from the community. --- Pg_QoS is developed and maintained by the Appstonia team. We'd love to hear your feedback via Github issues.
