Re: Logical Replication speed-up initial data
| От | Hüseyin Demir |
|---|---|
| Тема | Re: Logical Replication speed-up initial data |
| Дата | |
| Msg-id | CALqEK1fhEP3+vDctz6qizpmuWvLWcV9DZ8ROycpCRLHMWzsMdQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Logical Replication speed-up initial data (Nikhil Shetty <nikhil.dba04@gmail.com>) |
| Ответы |
Re: Logical Replication speed-up initial data
Re: Logical Replication speed-up initial data |
| Список | pgsql-performance |
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.dba04@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 tablesThanks,Nikhil
--
Hüseyin Demir
Senior Database Platform Engineer
Twitter: https://twitter.com/d3rh5n
Linkedin: hseyindemir
Github: https://github.com/hseyindemir
В списке pgsql-performance по дате отправления: