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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1p3axJ-0003kM-Vd
	for pgsql-admin@arkaria.postgresql.org; Fri, 09 Dec 2022 10:50:14 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1p3axI-0006Fb-GS
	for pgsql-admin@arkaria.postgresql.org; Fri, 09 Dec 2022 10:50:12 +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 <laurenz.albe@cybertec.at>)
	id 1p3axI-0006EB-3J
	for pgsql-admin@lists.postgresql.org; Fri, 09 Dec 2022 10:50:12 +0000
Received: from mail-ed1-x531.google.com ([2a00:1450:4864:20::531])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1p3axG-0001D0-1G
	for pgsql-admin@lists.postgresql.org; Fri, 09 Dec 2022 10:50:11 +0000
Received: by mail-ed1-x531.google.com with SMTP id d20so2636540edn.0
        for <pgsql-admin@lists.postgresql.org>;
 Fri, 09 Dec 2022 02:50:09 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec-at.20210112.gappssmtp.com; s=20210112;
        h=content-transfer-encoding:mime-version:user-agent:references
         :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=x+xMahjcichlvUzMnDNoL/4WgS1xsT6EkRmcf3GuH/s=;
        b=yI1CN7Xew/aDNibiBu/FC6wriPxfBx14wHqLOIbaaUpoPp71LmwC7bA0HJTkywCr70
         L8E+6AYrzq3fqyq5/OFDrkkh0VFOXIr91Y+4Iqfkf4ywAMM5e3CA+qpWSDShMWa+X8Xi
         YdRWTflxx079Lh4lJ+QS7j9wMbIQnCSOwDRXYFymbJDoEJoSvpYNpzt16Wzmv1Xgifwe
         +VELTu74i6Sz+RnHXE/zu4KcImH6GVY+mq/dYGzA3geCdqsRe9IG6j7PYUkWU+cOj9+t
         YZyh9QnuaPTl9rVn2Bhb670QtSiYIx8+4cfJS/wQPGiOdjEXm37NhRNmHwPtqQCcvfTY
         lE/g==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=content-transfer-encoding:mime-version:user-agent:references
         :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from
         :to:cc:subject:date:message-id:reply-to;
        bh=x+xMahjcichlvUzMnDNoL/4WgS1xsT6EkRmcf3GuH/s=;
        b=PbEMqBxm60lt9kU94LJqYdJATzV6F02L/6NLfP/DB7BwKiKGBvsesgsEuIFcHogHO7
         B6lWMYRXSjroUXBQOBLQs1Nn2L57GkYBF0MqUF7u7mw523AkzO2gwohgi3Qx1j0Y1o+t
         KfbZQbZJocRLuh44zMT55YlE2sly2YIcJrFcrUNFS2x+T6yxQF62GJ9IkqXw6bj+xJOw
         3k9r3VmvK0Bfv10P0rD3mEIdbnRi70hdlqjcc7YsUsCQFvy379lhgi/ild64uPGCG3Jt
         7ku315vinqAmcUpePP0MAvLxpN2RPowMeGH5NM3QqetONjUpjee0MiaRpv4bZZfPP6b8
         mMLg==
X-Gm-Message-State: ANoB5pmrgFb7/jcXVEI0NigdZar7R2F7ktvmYjBwTobGvKi4DQhd2Nd6
	gNHE/RWiBWGeQ+8zwCVGqjYv0w==
X-Google-Smtp-Source: 
 AA0mqf6X7NwsnpHOMhO6fMu6rKbvzpJhg66RKMELZ3Vaq0ANopmfr4zbtgxVihpIRUJmd9xCPcxAAQ==
X-Received: by 2002:a05:6402:5387:b0:45c:835b:9448 with SMTP id
 ew7-20020a056402538700b0045c835b9448mr4468612edb.4.1670583008800;
        Fri, 09 Dec 2022 02:50:08 -0800 (PST)
Received: from localhost.localdomain ([2001:871:5e:b47b:e706:88d7:ceb1:a099])
        by smtp.gmail.com with ESMTPSA id
 r21-20020aa7d595000000b0046c4eb22292sm482855edq.43.2022.12.09.02.50.07
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Fri, 09 Dec 2022 02:50:08 -0800 (PST)
Message-ID: <44581ceb3c9c96f48e131ed3de33389db07317e9.camel@cybertec.at>
Subject: Re: How to speed WAL apply in destination
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Bryon =?ISO-8859-1?Q?Roch=E9?= <kain@kain.org>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Fri, 09 Dec 2022 11:50:07 +0100
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>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/44581ceb3c9c96f48e131ed3de33389db07317e9.camel%40cybertec.at>
Precedence: bulk

On Fri, 2022-12-09 at 08:47 +0000, Bryon Roché wrote:
> On December 9, 2022 5:02:59 AM UTC, SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:
> > How to speed up WAL apply process 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