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

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Ajin Cherian <itsajin(at)gmail(dot)com>
Cc: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, 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-04-22 07:00:00
Message-ID: CAHut+PvfHr08y2_Yd8FWhiFLO4C+hH8T0FbjFAo6-=6s4C_HwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Ajin,

Some review comments for patch v17-0001

======
Commit message

1.
Additionally, transactions containing WAL records (INTERNAL_SNAPSHOT,
COMMAND_ID, or INVALIDATION) that modify the historical snapshot
constructed during logical decoding are deemed unfilterable. This
is necessary because constructing a correct historical snapshot
for searching publication information requires processing these WAL record.

~

/these WAL record./these WAL records./

======
src/backend/replication/logical/reorderbuffer.c

ReorderBufferFilterByRelFileLocator:

2.
+ if (found)
+ {
+ rb->try_to_filter_change = entry->filterable;
+ return entry->filterable;
+ }
+

Bad indentation.

======
src/include/replication/reorderbuffer.h

3.
+extern bool ReorderBufferCanFilterChanges(ReorderBuffer *rb);
+

Why is this extern here? This function is not implemented in patch 0001.

======
Kind Regards,
Peter Smith.
Fujitsu Australia

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2025-04-22 07:02:17 Re: bug: virtual generated column can be partition key
Previous Message Bertrand Drouvot 2025-04-22 06:22:51 Re: Recent pg_rewind test failures in buildfarm