Re: Add a GUC variable that control logical replication

2019-12-01 Thread Craig Ringer
On Thu, 28 Nov 2019 at 11:53, Michael Paquier wrote: > On Wed, Nov 06, 2019 at 10:01:43PM +0800, Quan Zongliang wrote: > > What the user needs is the same replication link that selectively skips > some > > transactions. And this choice only affects transactions that are doing > bulk > > delete

Re: Add a GUC variable that control logical replication

2019-11-27 Thread Michael Paquier
On Wed, Nov 06, 2019 at 10:01:43PM +0800, Quan Zongliang wrote: > What the user needs is the same replication link that selectively skips some > transactions. And this choice only affects transactions that are doing bulk > delete sessions. The operations of other sessions are not affected and can

Re: Add a GUC variable that control logical replication

2019-11-10 Thread Craig Ringer
On Wed, 18 Sep 2019 at 16:39, Quan Zongliang < zongliang.q...@postgresdata.com> wrote: > > Sybase has a feature to turn off replication at the session level: set > replication = off, which can be temporarily turned off when there is a > maintenance action on the table. Our users also want this

Re: Add a GUC variable that control logical replication

2019-11-06 Thread Quan Zongliang
On 2019/11/1 20:49, Peter Eisentraut wrote: On 2019-10-20 00:23, Euler Taveira wrote: You can probably achieve that using ALTER PUBLICATION to disable publication of deletes or truncates, as the case may be, either permanently or just for the duration of the operations you want to skip. ...

Re: Add a GUC variable that control logical replication

2019-11-01 Thread Peter Eisentraut
On 2019-10-20 00:23, Euler Taveira wrote: You can probably achieve that using ALTER PUBLICATION to disable publication of deletes or truncates, as the case may be, either permanently or just for the duration of the operations you want to skip. ... then you are skipping all tables in the

Re: Add a GUC variable that control logical replication

2019-10-19 Thread Euler Taveira
Em sáb, 19 de out de 2019 às 14:11, Peter Eisentraut escreveu: > > On 2019-09-18 11:33, Quan Zongliang wrote: > > On 2019/9/18 17:11, Peter Eisentraut wrote: > >> Why do you need to turn off replication when there is "maintenance" on a > >> table? What does that even mean? > >> > > In a table,

Re: Add a GUC variable that control logical replication

2019-10-19 Thread Peter Eisentraut
On 2019-09-18 11:33, Quan Zongliang wrote: > On 2019/9/18 17:11, Peter Eisentraut wrote: >> Why do you need to turn off replication when there is "maintenance" on a >> table? What does that even mean? >> > In a table, the user only keep data for a period of time and delete > expired records

Re: Add a GUC variable that control logical replication

2019-09-18 Thread Quan Zongliang
On 2019/9/18 17:11, Peter Eisentraut wrote: On 2019-09-18 10:39, Quan Zongliang wrote: Sybase has a feature to turn off replication at the session level: set replication = off, which can be temporarily turned off when there is a maintenance action on the table. Our users also want this feature.

Re: Add a GUC variable that control logical replication

2019-09-18 Thread Peter Eisentraut
On 2019-09-18 10:39, Quan Zongliang wrote: > Sybase has a feature to turn off replication at the session level: set > replication = off, which can be temporarily turned off when there is a > maintenance action on the table. Our users also want this feature. These kinds of feature requests are

Add a GUC variable that control logical replication

2019-09-18 Thread Quan Zongliang
Sybase has a feature to turn off replication at the session level: set replication = off, which can be temporarily turned off when there is a maintenance action on the table. Our users also want this feature. I add a new flag bit in xinfo, control it with a session-level variable, when set