Re: Logical Replication speed-up initial data - Mailing list pgsql-performance

From Christophe Pettus
Subject Re: Logical Replication speed-up initial data
Date
Msg-id 4A8EFC4E-A264-457D-A8E7-AE324ED9ABD4@thebuild.com
Whole thread Raw
In response to Logical Replication speed-up initial data  (Nikhil Shetty <nikhil.dba04@gmail.com>)
List pgsql-performance

> On Aug 4, 2021, at 08:06, Nikhil Shetty <nikhil.dba04@gmail.com> wrote:
>
> How can we increase the speed of the initial data load without dropping the indexes on destination?

You can do the usual steps of increasing checkpoint_timeout and max_wal_size (since incoming logical replication
changesare WAL logged) and setting synchronous_commit = off, but those will be modest improvements.  You will get an
enormousbenefit from dropping indexes and foreign key constraints, and those aren't much use during the initial sync
anyway.


pgsql-performance by date:

Previous
From: Stefano Amoroso
Date:
Subject: Re: Logical Replication speed-up initial data
Next
From: Nikhil Shetty
Date:
Subject: Re: Logical Replication speed-up initial data