Request a Demo
Home   >   mailing lists

pg_plan_filter 1.0.0 released - Mailing list pgsql-announce

From PGX, Inc. via PostgreSQL Announce
Subject pg_plan_filter 1.0.0 released
Date
Msg-id 179135676222.1061046.7332389296284379392@wrigleys.postgresql.org
Whole thread
List pgsql-announce
Tree view
 

pg_plan_filter 1.0.0 released

pg_plan_filter version 1.0.0 has been released.

This loadable module test sstatements against specific configured criteria before execution, raising an error if the criteria are violated. This allows administrators to prevent execution of certain queries on production databases.

The criteria are based on the planner's estimated cost. pg_plan_filter can refuse an individual statement whose plan is too expensive (statement_cost_limit), cap the combined cost of all the statements run in one transaction (transaction_cost_limit), and optionally apply the filter to SELECT statements only (filter_select_only). The module could be extended to support further kinds of filters.

It supports PostgreSQL versions 14 through 18.

This email was sent to you from PGX, Inc.. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message should be sent to PGX, Inc..

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

pgsql-announce by date:

Previous
From: Devart via PostgreSQL Announce
Date:
Subject: dbForge 2026.2 Adds a PostgreSQL Debugger, Visual Object Editors and Broader Context for dbForge AI Assistant
Next
From: "PGX, Inc. via PostgreSQL Announce"
Date:
Subject: pgx-bm25 1.0: BM25 ranked full-text search as a native PostgreSQL index