From: Bruce Momjian <bruce@momjian.us>
To: Lucio Chiessi <lucio.chiessi@trustly.com>
Cc: PGSql Admin list <pgsql-admin@lists.postgresql.org>
Subject: Re: Another way to do audit in DML operations in PostgreSQL >= 14
Date: Thu, 22 Feb 2024 18:36:43 -0500
Message-ID: <Zdfai2N1GC8P8JXH@momjian.us> (raw)
In-Reply-To: <CADoTbHWMXZfuDDHQU__UhLLa51GSyNhNj0prNQ+BD2j83hFgkA@mail.gmail.com>
References: <CADoTbHWMXZfuDDHQU__UhLLa51GSyNhNj0prNQ+BD2j83hFgkA@mail.gmail.com>
On Thu, Feb 22, 2024 at 04:14:24PM -0300, Lucio Chiessi wrote:
> As a Fintech company, we MUST audit (by force of law) all DML operations
> (select, insert, update, delete) occurring on our PostgreSQL databases.
FYI, DML is data manipulation language (DML), and SELECT is not DML. I
don't know the answer to your performance question.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, lucio.chiessi@trustly.com, pgsql-admin@lists.postgresql.org
Subject: Re: Another way to do audit in DML operations in PostgreSQL >= 14
In-Reply-To: <Zdfai2N1GC8P8JXH@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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