Re: Capture a changelog for the current transaction - Mailing list pgsql-general

From Ron Johnson
Subject Re: Capture a changelog for the current transaction
Date
Msg-id CANzqJaDniL6Gq3ycp+Y9dD__105L+MRmuDkX5owGKuY7xabTzw@mail.gmail.com
Whole thread
In response to Capture a changelog for the current transaction  (Stuart Campbell <stuart.campbell@ridewithvia.com>)
List pgsql-general
On Tue, Oct 6, 2026 at 6:39 AM Stuart Campbell <stuart.campbell@ridewithvia.com> wrote:
[snip] 
Maybe a persistent log table is OK, and each transaction is responsible for deleting its own rows from it? Sounds like a lot of churn though...

Partitioned persistent log tables wouldn't reduce the total total amount of churn, but they'd distribute it into smaller chunks which autovacuum threads (or cron jobs) could attack in parallel.

That would, of course, increase schema complexity and there would need to be reasonable "static" partition columns in the parent tables.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Stuart Campbell
Date:
Subject: Re: Capture a changelog for the current transaction
Next
From: shihao zhong
Date:
Subject: Re: Capture a changelog for the current transaction