Postgres Pro
Downloads
Home   >   mailing lists

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

From Nikhil Shetty
Subject Logical Replication speed-up initial data
Date
Msg-id CAFpL5VxhKgrdjT48sKSg_HJTeBp5PTmdYcjrYutdQd+ViFcR_Q@mail.gmail.com
Whole thread Raw
Responses Re: Logical Replication speed-up initial data  (Hüseyin Demir <demirhuseyinn.94@gmail.com>)
Re: Logical Replication speed-up initial data  (Christophe Pettus <xof@thebuild.com>)
List pgsql-performance
Tree view
Hi Team,

We have a highly transactional system as the source of logical replication and the database size is 500GB+. We are replicating all tables from source using logical replication. 

For two tables the initial data load is very slow and it never completes even after 24hrs+ 
Table size is under 100GB and index size is around 400GB. 

How can we increase the speed of the initial data load without dropping the indexes on destination?

We increased max_sync_workers_per_subscription to 3 but it didn't help much for single tables

Thanks,
Nikhil

pgsql-performance by date:

Previous
From: "Daniel Westermann (DWE)"
Date:
Subject: Re: Performance issue with thousands of calls to procedures and functions?
Next
From: Hüseyin Demir
Date:
Subject: Re: Logical Replication speed-up initial data