| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
| Cc: | Greg Nancarrow <gregn4422(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, "tanghy(dot)fnst(at)fujitsu(dot)com" <tanghy(dot)fnst(at)fujitsu(dot)com>, "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>, Alexey Lesovsky <lesovsky(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Skipping logical replication transactions on subscriber side |
| Date: | 2021-10-27 03:34:57 |
| Message-ID: | CAA4eK1K-UYLLVeBgcq00wp-jL5_JLLt-LXPoPm4aUN+bkiGKVw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Oct 27, 2021 at 8:32 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>
> On Tue, Oct 26, 2021 at 7:29 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
> >
> > You have a point. The other alternatives on this line could be:
> >
> > Alter Subscription <sub_name> SKIP ( subscription_parameter [=value] [, ... ] );
> >
> > where subscription_parameter can be one of:
> > xid = <xid_val>
> > lsn = <lsn_val>
> > ...
>
> Looks better.
>
> BTW how useful is specifying LSN instead of XID in practice? Given
> that this skipping behavior is used to skip the particular transaction
> (or its part of operations) in question, I’m not sure specifying LSN
> or time is useful.
>
I think if the user wants to skip multiple xacts, she might want to
use the highest LSN to skip instead of specifying individual xids.
--
With Regards,
Amit Kapila.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2021-10-27 04:07:46 | Re: TAP test for recovery_end_command |
| Previous Message | houzj.fnst@fujitsu.com | 2021-10-27 03:28:09 | RE: Skipping logical replication transactions on subscriber side |