On Fri, Nov 29, 2019 at 11:06 AM Florian Philippon <
florian.philip...@doctolib.com> wrote:
>
> We tried another solution: we loaded a minimal schema (without indexes and
> constraints) on the subscriber and created the subscription. The initial
> copy phase was way faster (a few hours). Then we c
Em sex., 29 de nov. de 2019 às 17:06, Florian Philippon <
florian.philip...@doctolib.com> escreveu:
> Hello community!
>
> Hi Florian
> We are currently testing PostgreSQL 11's built-in logical replication. We
> are trying to initialize a subscriber (from scratch) from a publisher with
> a large
Hello community!
We are currently testing PostgreSQL 11's built-in logical replication. We
are trying to initialize a subscriber (from scratch) from a publisher with
a large database (+6TB) with around 220 tables.
We tweaked the configuration parameters below, both on publisher and
subscriber, in