Pg_QoS v1.0.0-beta1 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-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.

Browse pgsql-announce by date

  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