From: ducquangkstn (@ducquangkstn) <noreply+ducquangkstn@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: Thu, 03 Sep 2026 23:52:26 +0000
Message-ID: <gh-pgaudit-pgaudit-300-c5533639491@github.com> (raw)
In-Reply-To: <gh-pgaudit-pgaudit-300@github.com>
References: <gh-pgaudit-pgaudit-300@github.com>
I am syncing our Postgres from Aws to Azure by pgcopydb. Between 2 runs, the performance drops about 1.5 times, and enabling pgaudit is one of the significant changes.
FYI, I try to disable pgaudit at the source by `ALTER ROLE ingest_user SET pgaudit.log = 'none';` as suggested and disable pgaudit at target DB, but nothing changed. Disabling pgaudit completely is not a choice in my case due to compliance.
General speaking, I don't want to bash anyone, but this is a seriours performance issue (do you agree with that?), and the PR #325 does not include any performance report. So how are you sure that will fix this issue at all?