pg.ddx.io  pgaudit/pgaudit GitHub issues and pull requests  
help / color / mirror / Atom feed
From: dwsteele (@dwsteele) <noreply+dwsteele@github.com>
To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>
Subject: Re: [pgaudit/pgaudit] issue #300: Severe performance degradation when enabling pgaudit (ddl,role only) under high insert load
Date: Fri, 07 Aug 2026 02:24:56 +0000
Message-ID: <gh-pgaudit-pgaudit-300-c5211384945@github.com> (raw)
In-Reply-To: <gh-pgaudit-pgaudit-300@github.com>
References: <gh-pgaudit-pgaudit-300@github.com>

> unless pgaudit goes first in the hook call sequence

It doesn't expect to run first, it just expects the hook chain to be honored. If another extension can't do that it should disable pgAudit or pgAudit should be loaded first.

That said, the improvements in the linked PR may help as long as pgAudit is not configured to audit anything that requires the ExecCheckPermissions hook. We were not planning to back patch this but if you can demonstrate that it prevents conflicts with other extensions (e.g. TimescaleDB) then we'll likely reconsider.

view thread (12+ messages)  latest in thread

Message-ID: <gh-pgaudit-pgaudit-300-c5211384945@github.com>
Permalink:  ../gh-pgaudit-pgaudit-300-c5211384945@github.com/

 · 


This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox