Initial COPY of Logical Replication is too slow

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема Initial COPY of Logical Replication is too slow
Дата
Msg-id CAB-JLwbBFNuASyEnZWP0Tck9uNkthBZqi6WoXNevUT6+mV8XmA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Initial COPY of Logical Replication is too slow
Список pgsql-hackers
Subscriber needs to ask publisher about tables and fields to COPY and it uses pg_get_publication_tables for that, and it is too slow when the number of tables is high because on every table it's subscribed it has to run this select. 
We can get the same result with a join on pg_publication_rel.

regards
Marcos
Вложения

В списке pgsql-hackers по дате отправления: