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

On Wed, Apr 28, 2021 at 2:43 PM Guillaume Lelarge
<guillaume(at)lelarge(dot)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.