Hi Christopher!

Am 08.10.2019 um 18:03 schrieb Christopher Browne:
> On Tue, 8 Oct 2019 at 03:20, Klaus Darilion 
> <klaus.mailinglists at pernau.at <mailto:klaus.mailinglists at pernau.at>> 
> wrote:
>
>     Hello!
>
>     We use Slony 2.1.4, with ~55 global slaves. Susbcribing [1] a node
>     takes
>     from ~3minutes (a few milli seconds away) to 15 minutes (200ms away) -
>     one some minutes for the initial sync.
>
>     b) Why does it take so long to subscribe? Can I speed up the
>     subscribe?
>
>
> Well, the process involves:
> a) Copying all of the data in the replication set, and
> b) Regenerating all of the indexes on the tables (as it is almost 
> always faster to deactivate indexes while doing the COPY)
>
As far as I understand adding a node involves 2 steps:

1. Slony configuration via slonik "subscribe". This configures the 
cluster and creates the slony namespace on the slave.

2. Initial sync: COPY the respective tables and sequences from the master

The initial sync (2) is actually fast, except there is low bandwidth to 
the slave. But the "subscribe" (1) is slow for far away nodes (in terms 
of RTT).


regards

Klaus


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20191010/af13f13e/attachment.htm