Pg_QoS v1.0.0 stable release is out!

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 stable release is out!
Date: 2026-03-03 08:01:45
Message-ID: 177252490545.778.17456449094768606667@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-announce

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.

Browse pgsql-announce by date

  From Date Subject
Next Message vitabaks via PostgreSQL Announce 2026-03-03 08:02:09 Autobase 2.6.0 released
Previous Message Microsoft Azure via PostgreSQL Announce 2026-03-01 14:23:44 The Schedule is out for POSETTE: An Event for Postgres 2026!