Postgres Pro
Downloads
Home   >   mailing lists

Re: How to speed WAL apply in destination - Mailing list pgsql-admin

From SASIKUMAR Devaraj
Subject Re: How to speed WAL apply in destination
Date
Msg-id 230318450.2704250.1670636278607@mail.yahoo.com
Whole thread Raw
In response to Re: How to speed WAL apply in destination  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: How to speed WAL apply in destination
Next
From: Mladen Gogala
Date:
Subject: Re: How to speed WAL apply in destination