Logical replication very slow

Поиск
Список
Период
Сортировка
От Boris Sagadin
Тема Logical replication very slow
Дата
Msg-id CAEzn=HS43zRb--he3v-mgicsoRRioZc7YSk+vbXSxjEYt0r6hQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Logical replication very slow  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-general
Doing an initial replica and trying to find a bottleneck, Ubuntu 16.04, NVMe disks, PgSQL v10.7, AWS. With binary replication, DB is replicated at good speed, around 500MB/s. Trying LR now for a big table (about 1.4TB with 2 indexes) and the speed is only about 2MB/s.

Checked disk util with iostat and only about 20% utilized on master, 15% on target, CPU load on master is low. On slave I can see the "logical replication worker" process is taking about 70% CPU time on a single core, machine has 16 cores.

Is there a setting I am missing here? Any ideas appreciated.

Boris



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Recommended way to enable data-checksums on Centos 7?
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Logical replication very slow