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 1p7ard-000273-4T for pgsql-admin@arkaria.postgresql.org; Tue, 20 Dec 2022 11:32:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p7ara-000583-GZ for pgsql-admin@arkaria.postgresql.org; Tue, 20 Dec 2022 11:32:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p7arZ-00056i-KG for pgsql-admin@lists.postgresql.org; Tue, 20 Dec 2022 11:32:50 +0000 Received: from sonic305-19.consmr.mail.sg3.yahoo.com ([106.10.241.82]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p7arW-00027W-Gp for pgsql-admin@lists.postgresql.org; Tue, 20 Dec 2022 11:32:48 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1671535961; bh=8exrwipHfX4RKaUvrsmg3G79+3ZFalcxYptKMHxDsb8=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=NwW8mw0/qedHZvpuheCHtm83n1WpKq0TO0tYOf9GRsEOB4/MXRYRkOmBDSceHMqACnweiQOhG6WRN7DFdJ9zLvqY8WoPGwDZxNdXzb1Nm74b1zH4H5weSwJTdTb5GmlTIDF3+E0R9eRa2IgFZN5sndxUUzHlJDGvnk6SHLuwZeHnJMYWJmvBBj/JhKN2yOlh4XiLbpoKucNqBBrWRdNESCh8HfcxHuc18apJEUoaWY0PIi6kt0EmPsLqXFeuyGRPXGrebilOwfdMM3xrChCBwwKsNpQVXv5+hhetzTzPUXzML2ypPGdHuXZScuzX5Gnz9E7PLLvvhw6a6XCPBv1AWQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1671535961; bh=DKGDAqO1tuXMxm6zfWPr276rECochZslA97sj2QLhNE=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=mZmkaHxNMTyYEy3Nc1EBwcWH0klqzX8DOI8BH4KgQCd4tsvSwmdn2wqEetvF27IGjumI036w4wxSGtiYw+cGGMNBj1wmLQn241+/3/I3RN8RQxzayMo0M479nn1MKY8ysoQtYOY0cORTjzmv0a3ZBl/L3ORkSftAkMufP8TVZF/vyXW5g5g7IzCLqcRjNH3zCrW4QIhmn9QsWoaAiaHqlkChBTXvcE/PgG7q57MhytQ53NMTOVB8vA+vGXlPHf8SvHs9/dric7LckI43FvQUF6aETfApkssfQ1jgwD5aHCyRPD0fuqCCUvKFVg5jcfpr8MiPIEtteAX7ZzfPTcnO0Q== X-YMail-OSG: Eap51nEVM1lox91zyHMEXOtmk9mZfZOmNhKTdoQQenhZb6C2w1vYy5zgaLD5CL8 Or8Rv0GM14T3BEXGlJI2VYVs5htBIJeXFuBoxdumhKlwySV4LM_NlGWkiLqbBNrNJPOkC6cWJVgp gVage0tIqhpUCgtv6nA1z4CYo6ia33pX1ZKIlO_fuOThFYa8BjIiTjAJMZk32Rlp_ohqIFXum8qz CpftcMRT_o8k1H0h1Kr5u4xafX8cCYUDBF66OOnwQMj4dj2WODehQdqobrp895lWxXrrUCdVPcUf XXs80ua5WOso4I30u5BAu6lw3SVrukfr3Lqpdh_IYvx3TqfYmeaR9fpbupjVXt.oBc0WIFxJjuNw ibBYdgV8lb79618O68MIjWZwwDAlQCGqbNJvdI9qnI8oupSt_OXZOMfIM31tfegy_mkgvYW49vyt vCkhoECZ1OWPv5CJ8VjfMcriXFgEH6cc2iWSlgn3xn5DiDjnL4UVFBXDNa19Lhm.of.QuIogYGds uZcqJfJMewc485fHi0bvT9GNDtbXHbxA9qrzQLMVYRQUIJMVv8ulNAn62Z4SYE2FI_y3GAxm5U28 R5BuErOl7nH2EcLfKLKOiRP.QgdrogPYghRMcKqUz1igCuWRMDW1OxolPgNtJD9Fal_E0gi5w5TL _074CBereCgA9m6htYrIvGzKr3T1b5daHBdST3ArsKWFiD__S.HRKzichzAd9mG4Vs0Ai.LyK2h7 FJJS0mY5FBKAFklX6Rd2f8hCbya7q.CG310Vn.g2IYMmmypIA8ReTYumDbJnw9G4vd8Wo0Mb8_gQ KFnSWAleT3ees5rFTvtKALKZdfSyrYpYwR_5HrPVQHh1nErVsSqpR8KqEGFw8kxWmulXcFF2.yoA hmH8Z7XkgVe5y60HmlOV9VvdPQZ729dT30xA4wL_.KVYiHk5XbGWV.BQ7_5dSfF2QnMfPRndatnE tPSCCd2JACrvT8T5sk9_QRBgDUW8Rhi6Vkd0S9JG7gzNJ79HllgL4qsVx5KMmbHBq3YjlRwhcGUp N4ZzUIwgk10a_4e3XeqvfSBcAmx19HKbUr._wctgF_gjAbrBH7HQMz.P9_FsRssTNA2YEIwr47iT nOT0VBsiHZ3pPu3Qo3Tc0MeCky9whyYMHCQT.soAYi345aQ.yh1JrsDVm5HVtb4VSV3h2Fd326fF X91X7jo2ZLyXVbYBa._NH2G6d4aIzKfcTCy3Q_LdPqqDZZb8Z7L5Lvl67rq3b5KR0Y3mIBn8n2C7 bN1vOKpsym.Xsfo0_qJTRjFaleSUt5X7ZCvyXvFyHxa50ZW3AbbjVGZ9FqmUtsaXrwXq4B5Yducx YI3TymxfUNysmcD61vNZI7oX.Sf14xyfphMmult2xeReqV5MzHu6H3WUoCndCjJBd2zjzyjzSxyl XHFX_JZQK41Vb4y0sy2ZVLZBhVTQYKD0F8gD3ve4n4eYYwrmuXqrDej1cyGU2gMG5uUsJbr0xoH2 snwUoPcufKjFv.5EAsiTPF9DQREEr.7KsvgmW7wK7Z.BphI9NRQhLixKkJSCTX6j727wUA2IPV9y .xX1Rmf6WA.PYOXa1qZA69xF1ZhJI31EBRBebdzNrpZMluTU8O1uQpANnyaEnAZ_DlyoFqA_OpIN 4qjkY9QqDFIES97E_pBJgiWFmvNeqjiEy5EaWQ5V09gdGNobuYrmi1hIcKfky1Bnce.L7C0v_Yok XVoMPbde8R9Zc6eb4PRASNlnU17PN6t40VX2ulClQRJWcc0ttv281n69w3pDv69oNMgWD4XW6gGa 3vDFiSKXQZy9YFNTCzouhqa0CK1cUgSe1.oerIBLNDNrmkAJL1DEIK.LsfJLqCXwjZrEMfwA1ieY hXXdKCVNLFFjdpTyWD5SmftmF1WFGNPTDCCB.yvhOC1EcYN5Knrm8teDbMHmFnnXjsr8vZJb0zUB J.TJdwd5U487BUDYZJxbPb2rVtjTRPOv7bDgU.6Sxpp2dPEUgPr.wIbbO1Mp65g.n8rvwVRnt73y QiJbxxGvHQTSg74CVkKB5G1tGlfsVp56l67IceivnmcCuRhrfpvYjkrk8M3OShlu2eyYq21lRHED lx717v521xnMIpMt_pgdplcZor_SrkBzVKT2m4AfNqIoyYgJ3a_a.vLxR4ECLXFxZit.8qah_55_ wt3_BQRs9z4repWSoWzX2Beibj4JM8KWgW7FcVkaM6Jffyqe06vP2Op3W07cVl5TXDo7oOL3xzNu UBP5L8cbO6A63weXxFid33brcjecJzcdVrTris5Bq8MszlTk72FPM2mlHEB0Fw0a9LMLlWasBv10 fgBiuhkuGjAoWpi90QyU_zZRLCZnf4scqU_3Til35Yb74etaktiPWkFcNWWNtmZVyMpeQdCeJt.O JuhSelrIjTkWd X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic305.consmr.mail.sg3.yahoo.com with HTTP; Tue, 20 Dec 2022 11:32:41 +0000 Date: Tue, 20 Dec 2022 11:32:34 +0000 (UTC) From: SASIKUMAR Devaraj Reply-To: SASIKUMAR Devaraj To: kain@kain.org, Laurenz Albe , Pgsql-admin Message-ID: <573865124.1608666.1671535954355@mail.yahoo.com> In-Reply-To: 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_1608665_1106160741.1671535954354" X-Mailer: WebService/1.1.20982 YahooMailAndroidMobile Content-Length: 3483 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1608665_1106160741.1671535954354 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi all Issue resolved after increasing memory.=C2=A0 Sent from Yahoo Mail on Android=20 =20 On Mon, Dec 12, 2022 at 5:09 PM, Bryon Roch=C3=A9 wrote: = =20 On December 9, 2022 10:50:07 AM UTC, Laurenz Albe wrote: >On Fri, 2022-12-09 at 08:47 +0000, Bryon Roch=C3=A9 wrote: >> >> There are fsync parameters which can be set to off that may provide a mo= dest speed increase, at the cost of removing crash safety. > >That is spectacularly bad advice. It is situational advice, and depending on your application, not bad advice= at all. It is certainly not something you want off by default, or even reg= ularly. In fact, the PostgreSQL 15 (and earlier) versions cover this in the documen= tation for the fsync and synchronous_commit parameters in section 20.5, inc= luding considerations involved in deciding when to use those arameters, alo= ng with further references in the documentation to cover more of the perfor= mance, synchronicity, and durability parameters, in detail. =20 ------=_Part_1608665_1106160741.1671535954354 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi all

Issue resolved after increasing memory. 
=

<= div>On Mon, Dec 12, 2022 at 5:09 PM, Bryon Roch=C3=A9
<kain@ka= in.org> wrote:


On December 9, 20= 22 10:50:07 AM UTC, Laurenz Albe <laurenz.al= be@cybertec.at> wrote:
>On Fri, 2022-12-09 at 0= 8:47 +0000, Bryon Roch=C3=A9 wrote:
>>
>> 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.<= /div>

It is situational advice, and de= pending on your application, not bad advice at all. It is certainly not som= ething you want off by default, or even regularly.

In fact, the PostgreSQL 15 (and earlier) versions cover this i= n the documentation for the fsync and synchronous_commit parameters in sect= ion 20.5, including considerations involved in deciding when to use those a= rameters, along with further references in the documentation to cover more = of the performance, synchronicity, and durability parameters, in detail.


------=_Part_1608665_1106160741.1671535954354--