Re: speed up a logical replica setup - Mailing list pgsql-hackers

From Tom Lane
Subject Re: speed up a logical replica setup
Date
Msg-id 2377319.1719766794@sss.pgh.pa.us
Whole thread Raw
In response to Re: speed up a logical replica setup  (Alexander Lakhin <exclusion@gmail.com>)
Responses Re: speed up a logical replica setup
RE: speed up a logical replica setup
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optimize numeric.c mul_var() using the Karatsuba algorithm
Next
From: Noah Misch
Date:
Subject: Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible