Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qt0DH-00AQhR-F2 for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Oct 2023 06:39:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qt0DF-000QXI-9y for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Oct 2023 06:39:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qt0DE-000QX9-VL for pgsql-hackers@lists.postgresql.org; Wed, 18 Oct 2023 06:39:25 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qt0DC-0012l2-OD for pgsql-hackers@lists.postgresql.org; Wed, 18 Oct 2023 06:39:24 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id A4E935C0255; Wed, 18 Oct 2023 02:39:21 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 18 Oct 2023 02:39:21 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm3; t=1697611161; x=1697697561; bh=wy tt0tNosljKPat9n7VJC2rao51dX4q6bfy7tPe5jq0=; b=dn9ZqdqsbPMStiqDM6 iJCojjF25y6tUeInzN+HWNk9z2se1Hk5LUbh2LNCBK4RQYaZgN4Ci5RutpsjtfIc S7B7Y0qO5/8fddojMYt248M9jUC0daWlnJ/Q9hzAZWDieRrcme5X6cbyFzQNFdlZ 4zHCGeGtJowUKRNvM4sho4zULF3FFkiOVpW0MMSTK0bD+i9q64o775/mlB6OPHHe urzcpprrIBvXqCT7TBto2Mw+upe5Yw96RZxmhtaDROUjRNhLICT8N0cJTtCfH5EU 9g4a0M2AhLIEUuLj/VVLlMYvVht+HUpIyImXL2bCBziW56p4wvXYGYWzj0l67mwa 82Sw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1697611161; x=1697697561; bh=wytt0tNosljKP at9n7VJC2rao51dX4q6bfy7tPe5jq0=; b=uAziVwrWkYFyZhACJGNClGLDd1Slf guCQPLUxiFCzqyDisjPfBHSoVPfs6Re5n6NJmHfMLlV1VujVNy/o5tDbklj+U++4 iEerANF9Wr3FyC1P2z+tvePyUM0WLPfsAvOkvThlkcD2SC+BOUc7mlUi9Uv4cW2O WZRu71YbrSpydcHmT7Cc6N9MhNYRo6q7chQU5JUJcT/pDjSCITTo+vEOghM+1PTP WLyMLgA0TIXSLpdlm6OrblYSlk+4smaqPjAeECBCIxeh6/3UeXMiLT5NhlqijsiM fsnNBU13SPVYrxv+FsZFhjcotxWPzTtdjWcj4tZCWKYpi1W70KVL3bJkw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrjeefgddutdekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepgeffjeevgfevuddvjedtvddt ieejheduueelvddufedtgfefjedvkeevkeeivddvnecuffhomhgrihhnpehpohhsthhgrh gvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhl fhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 18 Oct 2023 02:39:20 -0400 (EDT) Date: Wed, 18 Oct 2023 15:39:16 +0900 From: Michael Paquier To: "Hayato Kuroda (Fujitsu)" Cc: "'pgsql-hackers@lists.postgresql.org'" Subject: Re: Remove wal_level settings for subscribers in tap tests Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="0ROqoApECtfzzoC+" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0ROqoApECtfzzoC+ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Oct 18, 2023 at 02:59:52AM +0000, Hayato Kuroda (Fujitsu) wrote: > While discussing [1], I found that in tap tests, wal_level was set to log= ical for > subscribers too. The setting is not needed for subscriber side, and it ma= y cause > misunderstanding for newcomers. Therefore, I wanted to propose the patch = which > removes unnecessary "allows_streaming =3D> 'logical'". > I grepped with the string and checked the necessity of them one by one. >=20 > How do you think? >=20 > [1]: https://commitfest.postgresql.org/45/4273/ Hmm, okay. On top of your argument, this may be a good idea for a different reason: it makes the tests a bit cheaper as "logical" generates a bit more WAL. Still the gain is marginal.=20 -- Michael --0ROqoApECtfzzoC+ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmUvfZQACgkQnvQgOdby QH1JvhAAm83ToRB4ftF4jzZfkU8TVwNguA33ihhzJ8zI2VToIlSDdyO6N1mjf25H Ct8NoVQH8LpahyBR9CNY9nSwmVeCNK+vv5IjgU5ihQ33RBkKCD+r1bKlqrBynynC PZ/rc3lFXFG6V/dNy2Tf/p9Av7QJ0/E176ywZCOQpcb1gDS63abYyxlrA/D+/19m XpUtIkk9Wdz3QtjXnAIKnpH3hoX+bfMfYHQI9DXBLrsLD3BN0ZG2k6Go7H14WDHa rg6f0RPwqELl9mAu3L2mQGJEzktfeIVekAS5iRvtaSbDutCipEConcrLQ8sEeune x3vO9J8SVp0cld1d2yvDowjmGANYV0t7CHELQX2agtmAIy34RuXMZJFEfPYEQw6v qdCZW6jhxn2hxi7fGVciOKhi2Yty9fSxZZBTSGisUkXmZubz1EGpapGSFR9+m3cH k25cWsHwTMIz5GCHx8PlIWlgQ/aC0tClx6Jk6IiUTfs1UAaxnlWK2nVDC7dfiCaN AtuV5omP/jm1DL/P+Pd080Eo9zc9JOgqiI8NhMJIu9kHfia9YA55f0MzSJyDE5Am PgVu2zpz+CQF6eGfnkSL3viIXnhqyU9Gujg6P0ZbausHmjDE2H2SNdN1jKhnKbL0 NO3iN8yjmLvb61VibPoCZpJcQ9Us7KeWg5qa8q4gLOXEF6eEM9U= =9e5h -----END PGP SIGNATURE----- --0ROqoApECtfzzoC+--