Re: "Multiple table synchronizations are processed serially" still happens

2021-05-21 Thread Amit Kapila
On Fri, May 21, 2021 at 6:47 PM Guillaume Lelarge wrote: > > Le ven. 21 mai 2021 à 05:43, Amit Kapila a écrit : >> >> On Fri, May 21, 2021 at 1:30 AM Guillaume Lelarge >> wrote: >> > >> > >> >> If so, the >> >> problem might be that copying the data of the first table creates a >> >> transaction

Re: "Multiple table synchronizations are processed serially" still happens

2021-05-21 Thread Guillaume Lelarge
Le ven. 21 mai 2021 à 05:43, Amit Kapila a écrit : > On Fri, May 21, 2021 at 1:30 AM Guillaume Lelarge > wrote: > > > > > >> If so, the > >> problem might be that copying the data of the first table creates a > >> transaction which blocks creation of the slot for second table copy. > > > > > > I

Re: "Multiple table synchronizations are processed serially" still happens

2021-05-20 Thread Amit Kapila
On Fri, May 21, 2021 at 1:30 AM Guillaume Lelarge wrote: > > >> If so, the >> problem might be that copying the data of the first table creates a >> transaction which blocks creation of the slot for second table copy. > > > I don't understand how a transaction could block the creation of a slot.

Re: "Multiple table synchronizations are processed serially" still happens

2021-05-20 Thread Guillaume Lelarge
Hi, Le jeu. 20 mai 2021 à 12:09, Amit Kapila a écrit : > On Wed, Apr 28, 2021 at 2:43 PM Guillaume Lelarge > wrote: > > > > And it logs the "still waiting" message as long as the first table is > being synchronized. Once this is done, it releases the lock, and the > synchronization of the secon

Re: "Multiple table synchronizations are processed serially" still happens

2021-05-20 Thread Amit Kapila
On Wed, Apr 28, 2021 at 2:43 PM Guillaume Lelarge wrote: > > And it logs the "still waiting" message as long as the first table is being > synchronized. Once this is done, it releases the lock, and the > synchronization of the second table starts. > > Is there something I didn't understand on th

Re: "Multiple table synchronizations are processed serially" still happens

2021-05-11 Thread Guillaume Lelarge
Le mer. 28 avr. 2021 à 11:37, Guillaume Lelarge a écrit : > Le mer. 28 avr. 2021 à 11:12, Guillaume Lelarge > a écrit : > >> Hi, >> >> One of my customers has an issue with logical replication. As $SUBJECT >> says, multiple table synchronization happens serially. To be honest, it >> doesn't do t

Re: "Multiple table synchronizations are processed serially" still happens

2021-04-28 Thread Guillaume Lelarge
Le mer. 28 avr. 2021 à 11:12, Guillaume Lelarge a écrit : > Hi, > > One of my customers has an issue with logical replication. As $SUBJECT > says, multiple table synchronization happens serially. To be honest, it > doesn't do this every time. It happens when the tables are big enough. > > This is

"Multiple table synchronizations are processed serially" still happens

2021-04-28 Thread Guillaume Lelarge
Hi, One of my customers has an issue with logical replication. As $SUBJECT says, multiple table synchronization happens serially. To be honest, it doesn't do this every time. It happens when the tables are big enough. This issue was already described on this thread (from 2017): https://www.postgr