Re: Logical Replication speed-up initial data

Hello,

I also faced a similar issue. Try removing the indexes on the destination
first if possible. After that, you can add the indexes.

Regards.

Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>, 4 Ağu 2021 Çar, 18:07 tarihinde
şunu yazdı:

> 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
>

--
Hüseyin Demir

Senior Database Platform Engineer

Twitter: https://twitter.com/d3rh5n
Linkedin: hseyindemir
<https://www.linkedin.com/in/h%C3%BCseyin-demir-4020699b/>
Github: https://github.com/hseyindemir
Gitlab: https://gitlab.com/demirhuseyinn.94
Medium: https://demirhuseyinn-94.medium.com/