pg.ddx.io  pgaudit/pgaudit GitHub issues and pull requests  
help / color / mirror / Atom feed
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?




view thread (12+ messages)  latest in thread

Message-ID: <gh-pgaudit-pgaudit-300-c5533639491@github.com>
Permalink:  ../gh-pgaudit-pgaudit-300-c5533639491@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