Date: Sat, 10 Dec 2022 01:37:58 +0000 (UTC)
From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
Reply-To: SASIKUMAR Devaraj <sashikumard@yahoo.com>
To: scott_ribe@elevated-dev.com
Cc: Laurenz Albe <laurenz.albe@cybertec.at>,
	=?UTF-8?Q?Bryon_Roch=C3=A9?= <kain@kain.org>,
	Pgsql-admin <pgsql-admin@lists.postgresql.org>
Message-ID: <230318450.2704250.1670636278607@mail.yahoo.com>
In-Reply-To: <C5A289F2-237A-4FA0-B0A0-6311DE428A4E@elevated-dev.com>
References: <364439211.2445507.1670562179127.ref@mail.yahoo.com>
 <364439211.2445507.1670562179127@mail.yahoo.com>
 <1E6A35F6-6866-4FDB-8CE8-38C328FF1865@kain.org>
 <44581ceb3c9c96f48e131ed3de33389db07317e9.camel@cybertec.at>
 <203270855.2602687.1670583423055@mail.yahoo.com>
 <C5A289F2-237A-4FA0-B0A0-6311DE428A4E@elevated-dev.com>
Subject: Re: How to speed WAL apply in destination
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2704249_1304446303.1670636278606"
Content-Length: 2444
Archived-At: 
 <https://www.postgresql.org/message-id/230318450.2704250.1670636278607%40mail.yahoo.com>
Precedence: bulk

------=_Part_2704249_1304446303.1670636278606
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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

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

- have you checked network throughput between the 2 nodes?

- are the 2 nodes similar hardware configurations?


 =20

------=_Part_2704249_1304446303.1670636278606
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi<div><br></div><div>This happens only during heavy data load. Other time =
it is normal.&nbsp;&nbsp;<br><br><div id=3D"ymail_android_signature"><a id=
=3D"ymail_android_signature_link" href=3D"https://go.onelink.me/107872968?p=
id=3DInProduct&amp;c=3DGlobal_Internal_YGrowth_AndroidEmailSig__AndroidUser=
s&amp;af_wl=3Dym&amp;af_sub1=3DInternal&amp;af_sub2=3DGlobal_YGrowth&amp;af=
_sub3=3DEmailSignature">Sent from Yahoo Mail on Android</a></div> <br> <blo=
ckquote style=3D"margin: 0 0 20px 0;"> <div style=3D"font-family:Roboto, sa=
ns-serif; color:#6D00F6;"> <div>On Fri, Dec 9, 2022 at 7:52 PM, Scott Ribe<=
/div><div>&lt;scott_ribe@elevated-dev.com&gt; wrote:</div> </div> <div styl=
e=3D"padding: 10px 0 0 20px; margin: 10px 0 0 0; border-left: 1px solid #6D=
00F6;"> <div dir=3D"ltr">&gt; On Dec 9, 2022, at 4:57 AM, SASIKUMAR Devaraj=
 &lt;<a ymailto=3D"mailto:sashikumard@yahoo.com" href=3D"mailto:sashikumard=
@yahoo.com">sashikumard@yahoo.com</a>&gt; wrote:<br></div><div dir=3D"ltr">=
&gt; <br></div><div dir=3D"ltr">&gt; During certain interval there is huge =
WAL file generation f3om primary around 300gb/hr which delays sync in secon=
dary by atleast 30 mins. Other time it is normal <br></div><div dir=3D"ltr"=
><br></div><div dir=3D"ltr">- have you checked network throughput between t=
he 2 nodes?<br></div><div dir=3D"ltr"><br></div><div dir=3D"ltr">- are the =
2 nodes similar hardware configurations?<br></div><div dir=3D"ltr"><br></di=
v><div dir=3D"ltr"><br></div><div dir=3D"ltr"><br></div> </div> </blockquot=
e></div>
------=_Part_2704249_1304446303.1670636278606--