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.db...@gmail.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/
