Re: How to speed WAL apply in destination

From: SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com>
To: scott_ribe(at)elevated-dev(dot)com
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Bryon Roché <kain(at)kain(dot)org>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: How to speed WAL apply in destination
Date: 2022-12-10 01:37:58
Message-ID: 230318450.2704250.1670636278607@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Sent from Yahoo Mail on Android

On Fri, Dec 9, 2022 at 7:52 PM, Scott Ribe<scott_ribe(at)elevated-dev(dot)com> wrote: > On Dec 9, 2022, at 4:57 AM, SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)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?


In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mladen Gogala 2022-12-11 20:22:26 Re: How to speed WAL apply in destination
Previous Message Rui DeSousa 2022-12-09 22:52:33 Re: How to speed WAL apply in destination