Re: speed up a logical replica setup

Alexander Lakhin <exclusion@gmail.com> writes:
> As a recent buildfarm failure [1] shows, that test addition introduced
> new instability:

I have a different but possibly-related complaint: why is
040_pg_createsubscriber.pl so miserably slow?  On my machine it
runs for a bit over 19 seconds, which seems completely out of line
(for comparison, 010_pg_basebackup.pl takes 6 seconds, and the
other test scripts in this directory take much less).  It looks
like most of the blame falls on this step:

[12:47:22.292](14.534s) ok 28 - run pg_createsubscriber on node S

AFAICS the amount of data being replicated is completely trivial,
so that it doesn't make any sense for this to take so long --- and
if it does, that suggests that this tool will be impossibly slow
for production use.  But I suspect there is a logic flaw causing
this.  Speculating wildly, perhaps that is related to the failure
Alexander spotted?

            regards, tom lane