Logical Replication speed-up initial data

Поиск
Список
Период
Сортировка
От Nikhil Shetty
Тема Logical Replication speed-up initial data
Дата
Msg-id CAFpL5VxhKgrdjT48sKSg_HJTeBp5PTmdYcjrYutdQd+ViFcR_Q@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: "Daniel Westermann (DWE)"
Дата:
Сообщение: Re: Performance issue with thousands of calls to procedures and functions?
Следующее
От: Hüseyin Demir
Дата:
Сообщение: Re: Logical Replication speed-up initial data