Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding

From: Ajin Cherian <itsajin(at)gmail(dot)com>
To: "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding
Date: 2025-01-28 03:10:15
Message-ID: CAFPTHDZAzH0DE-3Vm5oL6Mj3X22_Ror+NR0dYdY1yXHE+6iuXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jan 24, 2025 at 5:28 PM Zhijie Hou (Fujitsu) <houzj(dot)fnst(at)fujitsu(dot)com>
wrote:

> Hi,
>
> I think the proposed feature is interesting, and after reviewing the
> original discussion thread, I'd like to help move it forward. To that end,
> I've
> summarized the key points of the discussion so far, including the
> challenges
> highlighted in the thread and some issues I identified off-list, along with
> potential solutions. My colleague will share a new POC patch set that has
> been
> developed based on these lines.
> (Note that the previous email was blocked, this is the second attempt)
>
>
>
Thanks Hou-san,

Here's a patch-set created based on the design changes proposed by Hou-san.

P.S: It has reached v12 after internal review/rework iterations

Regards,
Ajin Cherian
Fujitsu Australia

Attachment Content-Type Size
v12-0001-Track-transactions-with-internal-snapshot-change.patch application/octet-stream 2.5 KB
v12-0002-Filter-transactions-that-need-not-be-published.patch application/octet-stream 21.4 KB
v12-0003-Introduce-a-output-plugin-callback-to-filter-cha.patch application/octet-stream 18.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amul Sul 2025-01-28 03:39:18 Re: Allow NOT VALID foreign key constraints on partitioned tables.
Previous Message Peter Smith 2025-01-28 03:01:20 Re: Skip collecting decoded changes of already-aborted transactions