Re: Per-table resync for logical replication subscriptions

From: Cagri Biroglu <cagri(dot)biroglu(at)adyen(dot)com>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: "smithpb2250(at)gmail(dot)com" <smithpb2250(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Per-table resync for logical replication subscriptions
Date: 2026-08-10 08:53:04
Message-ID: CAA36mspD+USqyGiJ2_-8B+i87zr18jYAOPJdJMTEEAS0Bjr-_g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi again,

Thanks, and thanks for picking this up. I've registered it in the open
CommitFest (PG20-2).

Attached is v3, which is v2 rebased onto current master. Master removed
Subscription.conninfo, so the one code change is that the mid-sync path
now resolves the connection string with SubscriptionConninfo(sub). It
does that at the point of use rather than up front, because the common
case here is a relation in ready state, which needs no publisher
connection at all. Nothing else changed, so your review of v2 still
applies.

Regards,
Cagri Biroglu

On Sat, Aug 8, 2026 at 2:49 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
wrote:

> On Fri, Jul 31, 2026 at 12:00 AM Cagri Biroglu <cagri(dot)biroglu(at)adyen(dot)com>
> wrote:
> >
> > I wanted to follow up on this patch, as there has not been any activity
> on the thread for some time.
> >
> > The proposal is still relevant from my side, and I am happy to rebase
> the patch, run additional tests, or address any design concerns or review
> feedback.
> >
>
> Thank you for submitting the patch!
>
> I'll review the patch and share my comments. Meanwhile, please
> register this patch to the next CommitFest[1] if not yet.
>
> Regards,
>
> [1] https://commitfest.postgresql.org/61/
>
> --
> Masahiko Sawada
> Amazon Web Services: https://aws.amazon.com
>

Attachment Content-Type Size
v3-0001-refresh-table.patch application/octet-stream 19.4 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2026-08-10 08:54:13 Re: WAL compression setting after PostgreSQL LZ4 default change
Previous Message Bertrand Drouvot 2026-08-10 08:46:29 Re: Split index and table statistics into different types of stats