Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3b4B-00047N-1G for pgsql-admin@arkaria.postgresql.org; Fri, 09 Dec 2022 10:57:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p3b49-0007um-UF for pgsql-admin@arkaria.postgresql.org; Fri, 09 Dec 2022 10:57:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3b49-0007sw-JI for pgsql-admin@lists.postgresql.org; Fri, 09 Dec 2022 10:57:17 +0000 Received: from sonic310-19.consmr.mail.sg3.yahoo.com ([106.10.244.139]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p3b46-0001Gf-De for pgsql-admin@lists.postgresql.org; Fri, 09 Dec 2022 10:57:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1670583428; bh=qdK54/lpLykLrhdfBqU7qH2caw9XQXomrXk5fpFPSNc=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=VM+9kpT4ZrlAsQyDpVkoP1Ud+duJ43PNsS2ujvVPu09beDoh7mWa0dIXALPk0gu6f8891uzp7dCT7mPSNHZMCCiWKbqTAaohMgLdyLt2STD68wih8jwqsdaEdL+QpkIlndGv36gEghvzHMYAbj/Sagbc2swZVfDQ7Vxh4zJeGTk/xZlpP0zNfhoDHzEfUvPHUAwlfJxLr4t7LTEHL0wnpylL3O3t/mzBVsSrmQ+RXmOtx9oZdpKlZNmR6edialWl8Fwb8Qo5gY00Z0oCv890H4bueIApKA0zXkQLnGi2ZCVytjExX4hABNLKOFT5+IAoyEub12LmkmzhIXibYsXlMQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1670583428; bh=Y0C9FT0Qz1tGeKF2RVRptIyeK5vTTOxH/XcQkgjyPyt=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=HPeUcjPb6pHsfnWu62cbKUe63Dpq4nnjkpJ3YRFZ+9GwK8fN1+TkxZGvswnyI8/utBX5gKj2pkJZOu38GqmYvlQOrXtnlEaV8g23gMy7JUEfNpfglXwncXL/9OB5/UVWFV3oUdDIGGzlJhyZ+vFinUY5Ke9BWenX1jL4d+mDwaskr7opCoIRtD0GxDzL2d2VAZipeyC4f9xrfNF9JJqg5Lo3z9BtEV6CmtC+RRpR9InkRr7HmY7Qb2Vw3vhpSkIfh/egrpuDK6Bjj0Lno6+FNEgweFhDIW6bbaykpg7K/W7Ehmry0u5RvemTKDw6yR2C7K9AUjiqdoonkCktesReBA== X-YMail-OSG: deLCgD0VM1klAGXkpRoOTW1ciLzuvOenYprTXsmbnzRuWxTt7FJ_NBDXUSH2gTo CfeBElG28oggcoiGrfkRofcxCe_ej4vlwXYtVvnKlYCVUGqvPtxo.7tepp7CzQBRFIwKatnqM.rB Lfuoqz8N6xYMZyS07iPjG9YpNIg7T2YXn.gYEDdz95e2j4jJNCBsGzi1B2NrQbYP4npdpAoJ27gY TVLlmbu34PugpqB6dIw85EKKfqFq7OMmYb8LW4ESw4_WGVbbTn.khxDURUq.iME9gJpDbpFCQYUk ldi9SjB2H8N9nvpQq1HzMd6L7oYhSG68_dNkXatn9hah.6ZBsxH8eqi.vYCuZTZWiarUT_vGsEdg Z71tRPza.5zQHehKZb2ejc6N37SdDMut44GwOVTyAiotZS5TdOqi6lGxxrLLfYo3L4ZK_E7fnWIf _rP8CzQFb9Uj3HamQLc339uZi2tyLI_cQhHdtzweH4tvyfdj3RMy19WbWOKXHsn2BXaP0ACMigDB pR0joklvX7hw1JEdpY4cqFa2DLMsJbJCNgbr_MAX9oz4ztPZe1GKhhxH5sRemo.PpV51SPypFOD6 tUqxLrL4XmbadXiPdTMP1M4rDghaxFK8KI8HeU2Ekrww62K4iFmjUsyDODhIK3C9vx8rZO_4FgMh wbggGq1dg2gHNkcSXIWb8OUeiSwD3xTB541u6dnP7b3YDSTFudEF.YBcNePSs9jslgiREP0Dn4lP rEcBEN07WRL9pwEu8xy9YNHg5V1jtAPpMOt4gQCioHdPfO63ylo67bu9YHYVzkFw8Ol2wj.se2tV 7JQBAIN9arBX1lYZLqNfUDes57mQmL9upFAZ.rV_xeFQd5o5S8TzueMsh9lyVCYlOL.ajlnWJLhq eLzeYnBwZ3QROyVHpBZRsQreKbgIci4vsCkgmpxaEx.M6TYbPcauJoH5nGA38jnW1vCSri5DNTMQ hfLyjXjfIkOe.3VG4qqtp8Q0yk3KjYhU1hEq0361A53PoULVAsDhQaXSCGXWEHAWkp4tC3WINlXu naMfoYBC3eaxsrgAGnQVJNR3NTnICg3TyPhA2PmL9b.fh1FZl6i66pfW8MGRYHzyyqYfTc_BhOlS FeiIfSeuXNHaZzyh6CfFsINxtd5uhSXpLFd54BQo478ez4IEkBY5Oz7E33wbUFXF7v265LQUWkCp xCXnoeJMRNdNZoql1mKFbtyjizeSMxaYLqGjJUuNDam6bKyOM2vFdXZHjuX0ax56wYQGFZOco_Y5 VfJUwo7sNlDi..iHtvh2s.9xLvlHA1A.sHvNU_hfgqf.hQUGarie1CriMnEMqgeqdwTFD3FYUqg2 4SNgQu6vl3cQsvvYV9fag_2tXunnSurodOUnXpxRaf0H0SzTLAtBbsroYGodJDJnPvfue1_dpXne uUXryizWzAgG5ataZyAa.6.oFhmtge9zzyd034KjCXkEoEPMuqZqstxWhxKCz14AnNUedmIz1hyk eqOM5W1PweVzo8PVntWL5C_b99DcGlUM_IHv9eeEpsZJ4b90sTazQU3OhDRnWTOcxBDVUm6C59rU fW8mc81NQNzTP22xwmI4RYcX_s4b35vzlLvyah3AthefUpg7J6KLseyTcwE351H5.2zqtJ.vfrr7 Xa.x_ZcScl_f7ZS_JZUnOVBt.udGSaqQSZJTtKMgOS2oB2lzVpwtZAQHWKkyCdET.genw7E8rwOK nYKiUTfVS8gV26vrrB8Fn.Kfgvk3RtLoG.d0xkW7OwHlf0KIC4PKUOrPiHyZTwZgHgxDHs6aY33h H89_NPIOwP80QMRnhjcC1Z90zoVxVmhu1TtVCM.sb.PT_4tuW_l7ttgPctsn5AFW4E5aL6xqHzlc _1DFwbK4FCN96PwmzGdUWLI45K0oA0Q7mM_g4jzFGc4A1J8o2NEXpALRNyMqnf6DjPyAb3a.McR0 xa4KcOw7O2LrkFhToE7TyYpeRb.Pyxvs2GfLYqUvNzNFXm5IXJEwnKKyfTfZItQ8.faWNOTPD1tj WU5PYWOAO1rDHjD1LAukK6jqKW.7DPJjF6gBKICHEckMJeFoRLkM8JDS1tFRKPqB95RUc5GAm1_3 yIxiVS08oBFFc53xYDZ3uBghFUi.OPnNX1tOP4aKo8AQN.HSPxPHGsQw1aVyroW1dj5iIltFMTmt wNDCx4tPK1YyBVra3IGD2zl2JXHP9f9hYui7w96UJGyg91qhF5dsuR.CJrl7kO_vHzFaZwv6Lkqm LHII1i_504nRubKnevAHz2viQhZfHkUaKvSfnq2fP6hzqllGISQuhsVPixk.m2YFW.PRbx9y7V6z 20cUWOSe6sNoU4ZExGnAghblu74TFScUsNGf3NwYtsjZtQR6vt4HbVhWTqDsr01Jj8jTAjs8R5qQ 7vOIHqbnc4_ST69j5KX4h7KX_OO.JJfG_Vggr X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.sg3.yahoo.com with HTTP; Fri, 9 Dec 2022 10:57:08 +0000 Date: Fri, 9 Dec 2022 10:57:03 +0000 (UTC) From: SASIKUMAR Devaraj Reply-To: SASIKUMAR Devaraj To: laurenz.albe@cybertec.at, =?UTF-8?Q?Bryon_Roch=C3=A9?= , Pgsql-admin Message-ID: <203270855.2602687.1670583423055@mail.yahoo.com> In-Reply-To: <44581ceb3c9c96f48e131ed3de33389db07317e9.camel@cybertec.at> 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> Subject: Re: How to speed WAL apply in destination MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2602686_366530138.1670583423054" X-Mailer: WebService/1.1.20926 YahooMailAndroidMobile Content-Length: 2977 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2602686_366530138.1670583423054 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable During certain interval there is huge WAL file generation f3om primary arou= nd 300gb/hr which delays sync in secondary by atleast 30 mins. Other time i= t is normal=C2=A0 Sent from Yahoo Mail on Android=20 =20 On Fri, Dec 9, 2022 at 4:20 PM, Laurenz Albe wr= ote: On Fri, 2022-12-09 at 08:47 +0000, Bryon Roch=C3=A9 wrote: > On December 9, 2022 5:02:59 AM UTC, SASIKUMAR Devaraj wrote: > > How to speed up WAL apply process in secondary? Any parameter available= from postgres, apart from disk speed?=C2=A0 > > There are fsync parameters which can be set to off that may provide a mod= est speed increase, at the cost of removing crash safety. That is spectacularly bad advice. Is the disk the bottleneck at all? Yours, Laurenz Albe =20 ------=_Part_2602686_366530138.1670583423054 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable During certain interval there is huge WAL file generation f3om primary arou= nd 300gb/hr which delays sync in secondary by atleast 30 mins. Other time i= t is normal 


On Fri, Dec 9, 2022 at 4:20 PM, Laurenz Albe
<laurenz.albe@cybertec.at> wrote:
On= Fri, 2022-12-09 at 08:47 +0000, Bryon Roch=C3=A9 wrote:

> On December 9, 2022 5:0= 2:59 AM UTC, SASIKUMAR Devaraj <sashikumard@yahoo.= com> wrote:
> > How to speed up WAL apply pr= ocess in secondary? Any parameter available from postgres, apart from disk = speed? 
>
> There are fsync = parameters which can be set to off that may provide a modest speed increase= , at the cost of removing crash safety.


That is spectacularly bad advice.

Is the disk the bottleneck at all?

Yours,
Laurenz Albe



=
------=_Part_2602686_366530138.1670583423054--