Re: How to speed WAL apply in destination

Поиск
Список
Период
Сортировка
От SASIKUMAR Devaraj
Тема Re: How to speed WAL apply in destination
Дата
Msg-id 230318450.2704250.1670636278607@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: How to speed WAL apply in destination  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
Hi

This happens only during heavy data load. Other time it is normal.  


On Fri, Dec 9, 2022 at 7:52 PM, Scott Ribe
<scott_ribe@elevated-dev.com> wrote:
> On Dec 9, 2022, at 4:57 AM, SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:
>
> During certain interval there is huge WAL file generation f3om primary around 300gb/hr which delays sync in secondary by atleast 30 mins. Other time it is normal

- have you checked network throughput between the 2 nodes?

- are the 2 nodes similar hardware configurations?



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

Предыдущее
От: Rui DeSousa
Дата:
Сообщение: Re: How to speed WAL apply in destination
Следующее
От: Mladen Gogala
Дата:
Сообщение: Re: How to speed WAL apply in destination