Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vQgSE-00EqUY-0X for pgsql-announce@arkaria.postgresql.org; Wed, 03 Dec 2025 06:35:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vQgSD-00BgOH-0l for pgsql-announce@arkaria.postgresql.org; Wed, 03 Dec 2025 06:35:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vQgSC-00BgNI-1B for pgsql-announce@lists.postgresql.org; Wed, 03 Dec 2025 06:35:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vQgS8-002sdA-2j for pgsql-announce@lists.postgresql.org; Wed, 03 Dec 2025 06:35:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=z4EnMBneQbzRzDSZUQ/62LfNpt3ZdmLDcJZyCOkwir8=; b=tqhpGXrttkZJ3b+bbATcMGQe4Q 2ed87xyVwG5ZdeJGr4PMAPUvGqOzTLOcAc+cKyt7FhYSgM0W5nFrpLJRAJSCMyvpGclvn/ezk1Sma 8WUnG4hgT0NjQFxjNLUttHUCYWvh3O8F92SWQxjIAsRLM+Nn0qTYZ3rNgGhkwJEw8Ceu+6OvNNJYz yQOqB6CSUpOQBuT4jU8ZwFaN8VBMMU7ZUsMpCUBbsqj1kqkA94KqQh7J4MM+i2UWmueduIQgVZNME CZRXUr7anr4/nkMzoUYO+7L26f/d2yY/kCPmN2jxQptinkFkK5nGPZYO85QeP8F2AucVy2eO1TZeK cj1TvFMg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vQgS9-004OCC-0K for pgsql-announce@lists.postgresql.org; Wed, 03 Dec 2025 06:35:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vQgS6-004TBw-1x for pgsql-announce@lists.postgresql.org; Wed, 03 Dec 2025 06:35:03 +0000 Content-Type: multipart/mixed; boundary="===============4454550361635120197==" MIME-Version: 1.0 Subject: Pg_QoS v1.0.0-beta1 is out! To: PostgreSQL Announce From: AppstoniA via PostgreSQL Announce Reply-To: hi@appstonia.com Date: Wed, 03 Dec 2025 06:34:23 +0000 Message-ID: <176474366365.2921399.5932140527392950400@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: a19a722febb670abe1cb5d4dbbc1ad6a3e6834ca8ae69e9e5097bf04cdb5ea9b List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4454550361635120197== Content-Type: multipart/alternative; boundary="===============5794083989986133113==" MIME-Version: 1.0 --===============5794083989986133113== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable # PostgreSQL QoS Resource Governor We are pleased to announce the first beta release of Pg_QoS, a PostgreSQL e= xtension that provides Quality of Service (QoS) style resource governance f= or 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); plann= er integration ensures parallel workers stay within that cap - Track and cap concurrent transactions and statements (SELECT/UPDATE/DELET= E/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 versio= n from the main branch whenever possible. --- We'd love to hear your feedback via Github issues. --===============5794083989986133113== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Pg_QoS v1.0.0-beta1 is out!
 

Pg_QoS v1.0.0-beta1 is out!

PostgreSQL QoS Resource Governor

We are pleased to announce the first beta r= elease 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 o= f the entire PostgreSQL instance/cluster by limiting resource usage, so tha= t different workloads interfere with each other less.

Enforce per-role and per-database limits vi= a ALTER ROLE/DATABASE SET qos.*

Per-database/role:

  • Limit CPU usage= by binding the backend to N CPU cores (Linux only); planner integration en= sures parallel workers stay within that cap
  • Track and cap c= oncurrent transactions and statements (SELECT/UPDATE/DELETE/INSERT)
  • Limit for setti= ng work_mem parameter

Requirements

  • PostgreSQL 15 o= r newer (officially supported)
  • Build toolchain= and server headers (pg_config must be available)
  • Linux for CPU l= imiting

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 f= rom the community.

Note: As development is on= going, please build and use the latest version from the main branch wheneve= r possible.


We'd love to hear your feedback via Github = issues.

This email was sent to you from AppstoniA. It was delivered on their behalf= by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to AppstoniA.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============5794083989986133113==-- --===============4454550361635120197==--