On Wed, Apr 28, 2021 at 2:43 PM Guillaume Lelarge <guilla...@lelarge.info> 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 the previous thread? >
It seems from a script that you are creating a subscription on the same node as publication though in a different DB, right? 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. The commit you referred will just fix the problem while reading the data from the publisher not while writing data in the table in the subscriber. > I'd like to know why serial synchronization happens, and if there's a way to > avoid it. > I guess you need to create a subscription on a different node. -- With Regards, Amit Kapila.
