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.