Date: Fri, 9 Dec 2022 10:07:25 +0000 (UTC)
From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
Reply-To: SASIKUMAR Devaraj <sashikumard@yahoo.com>
To: kain@kain.org, Pgsql-admin <pgsql-admin@lists.postgresql.org>
Message-ID: <68322219.2585895.1670580445682@mail.yahoo.com>
In-Reply-To: <1E6A35F6-6866-4FDB-8CE8-38C328FF1865@kain.org>
References: <364439211.2445507.1670562179127.ref@mail.yahoo.com>
 <364439211.2445507.1670562179127@mail.yahoo.com>
 <1E6A35F6-6866-4FDB-8CE8-38C328FF1865@kain.org>
Subject: Re: How to speed WAL apply in destination
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2585894_1616408514.1670580445681"
Content-Length: 2357
Archived-At: 
 <https://www.postgresql.org/message-id/68322219.2585895.1670580445682%40mail.yahoo.com>
Precedence: bulk

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

Thanks Bryon. Will deep dive into this. Any other parameters or parallel wr=
ites will help?=C2=A0

Sent from Yahoo Mail on Android=20
=20
  On Fri, 9 Dec 2022 at 3:12 PM, Bryon Roch=C3=A9<kain@kain.org> wrote:   T=
here are fsync parameters which can be set to off that may provide a modest=
 speed increase, at the cost of removing crash safety.

On December 9, 2022 5:02:59 AM UTC, SASIKUMAR Devaraj <sashikumard@yahoo.co=
m> wrote:
Hi All
How to speed up WAL apply process in secondary? Any parameter available fro=
m postgres, apart from disk speed?=C2=A0
RegardsSasi
 =20

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

Thanks Bryon. Will deep dive into this. Any other parameters or parallel wr=
ites will help?&nbsp;<br><br><div id=3D"ymail_android_signature"><a id=3D"y=
mail_android_signature_link" href=3D"https://go.onelink.me/107872968?pid=3D=
InProduct&amp;c=3DGlobal_Internal_YGrowth_AndroidEmailSig__AndroidUsers&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> <blockquo=
te style=3D"margin: 0 0 20px 0;"> <div style=3D"font-family:Roboto, sans-se=
rif; color:#6D00F6;"> <div>On Fri, 9 Dec 2022 at 3:12 PM, Bryon Roch=C3=A9<=
/div><div>&lt;kain@kain.org&gt; wrote:</div> </div> <div style=3D"padding: =
10px 0 0 20px; margin: 10px 0 0 0; border-left: 1px solid #6D00F6;"> <div i=
d=3D"yiv2072494287"><div>There are fsync parameters which can be set to off=
 that may provide a modest speed increase, at the cost of removing crash sa=
fety.<br><br><div class=3D"yiv2072494287gmail_quote">On December 9, 2022 5:=
02:59 AM UTC, SASIKUMAR Devaraj &lt;sashikumard@yahoo.com&gt; wrote:<blockq=
uote style=3D"margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, =
204);padding-left:1ex;" class=3D"yiv2072494287gmail_quote">
Hi All<div><br></div><div>How to speed up WAL apply process in secondary? A=
ny parameter available from postgres, apart from disk speed?&nbsp;</div><di=
v><br></div><div>Regards</div><div>Sasi</div></blockquote></div></div></div=
> </div> </blockquote>
------=_Part_2585894_1616408514.1670580445681--