| From: | AppstoniA via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
|---|---|
| To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
| Subject: | Pg_QoS v1.0.0-beta1 is out! |
| Date: | 2025-12-03 06:34:23 |
| Message-ID: | 176474366365.2921399.5932140527392950400@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce |
# 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Microsoft Azure via PostgreSQL Announce | 2025-12-03 21:19:51 | Call for Proposals open for POSETTE: An Event for Postgres 2026! |
| Previous Message | Psycopg Development Team via PostgreSQL Announce | 2025-12-01 13:49:40 | Psycopg 3.3 released |