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 1lUA0L-0005ec-UI for pgsql-admin@arkaria.postgresql.org; Wed, 07 Apr 2021 15:22:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lUA0J-0003ah-MK for pgsql-admin@arkaria.postgresql.org; Wed, 07 Apr 2021 15:22:03 +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 1lUA0J-0003aZ-7s for pgsql-admin@lists.postgresql.org; Wed, 07 Apr 2021 15:22:03 +0000 Received: from admin.sibptus.ru ([2001:19f0:5001:21dc::10]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUA0G-0002u4-Dt for pgsql-admin@lists.postgresql.org; Wed, 07 Apr 2021 15:22:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=sibptus.ru; s=20181118; h=Message-ID:Subject:To:From:Date:In-Reply-To; bh=mlkfCKz/4b5p2XZ4l8533rPT2UnUknRPpOGYW8qspjg=; b=o6tIxtGTglGcmXFbprYRBk1i2X brI5mecCZeXKuUqXrgjrx6xiLUMouGdyk/rA9a+zNadmxsA+v4P6WrLd87IfUXAbupENKOqnN/hls h2deZ3JapIR747xJeSYOS49nlMsMkph8JIROS81Id8RiBO4eV7VDqJUb2JeeDn2k6ul0=; Received: from vas by admin.sibptus.ru with local (Exim 4.94 (FreeBSD)) (envelope-from ) id 1lUA0B-000Ied-VB for pgsql-admin@lists.postgresql.org; Wed, 07 Apr 2021 22:21:55 +0700 Date: Wed, 7 Apr 2021 22:21:55 +0700 From: Victor Sudakov To: pgsql-admin@lists.postgresql.org Subject: "fsync = off" in recovery Message-ID: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="W8ioHvcrIh58VFId" Content-Disposition: inline X-PGP-Key: http://admin.sibptus.ru/~vas/ X-PGP-Fingerprint: 10E3 1171 1273 E007 C2E9 3532 0DA4 F259 9B5E C634 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --W8ioHvcrIh58VFId Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Dear Colleagues, When a cluster is in recovery mode (a delayed replica, PITR etc), does the setting of "fsync =3D off" speed up the application of WALs? I've done some experimenting and got dubious results, so what does the=20 theory say? --=20 Victor Sudakov VAS4-RIPE http://vas.tomsk.ru/ 2:5005/49@fidonet --W8ioHvcrIh58VFId Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQEcBAEBAgAGBQJgbc4TAAoJEA2k8lmbXsY0vI8IAJHnx3WKCM1Jcq317t5yNhLK QXLF0IDdqToDUuKOBoI+BxzI1TI5bcgslnHSEYK6++D2UlW6N3FYvNU6fP39uI5y Bo+YCAAqCQWjXasMeHlOjvp9W85JPKwE30sS1ZXRSTMGLofg1Co9xUnIK+SHaX1R O8sc0UCEL9USv55kJCNRKn1mYY433q4wojEP8kirarU0oMyfr2EuqRouRi9JIBjy +rsrwXVTESPFw2Zr15YJloTC4MNGurClciOiQW7tdjb2mjVHkAMMir0pgYk18jQm /jCutyyqbtxvFTWWMC9pRbWqRbDoWAsGCZ6xjn1hECkV0hv9BY6cB/JHJwnJi2E= =RykH -----END PGP SIGNATURE----- --W8ioHvcrIh58VFId--