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 1rLBDj-006Wmt-KZ for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jan 2024 00:04:23 +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 1rLBCk-009CnW-84 for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jan 2024 00:03:22 +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 1rLBCj-009Cmw-Th for pgsql-hackers@lists.postgresql.org; Thu, 04 Jan 2024 00:03:21 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rLBCh-00Dc1t-EL for pgsql-hackers@lists.postgresql.org; Thu, 04 Jan 2024 00:03:20 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id 3AE103200AAD; Wed, 3 Jan 2024 19:03:17 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Wed, 03 Jan 2024 19:03:17 -0500 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:subject :subject:to:to; s=fm2; t=1704326596; x=1704412996; bh=h4eK6ul0Vw LuM1O7tAmalJid0hnjYugs+9LNJ31JBCU=; b=RwjaLneGD/2UNUjAjfZF8Z3T6P B3ajPyMx4/x4UfCPDppluvUNQL04PUtYdd5E9qAYz3+RnOyrofnhjW11fpr1/nyy DcOEMej+TF90AfDS6iCcyc2YeuhrsPaVcgQLObg7V7jTTMiSjbnlkHA7gyRqbe1F 3HB3/bv8TTcDl+WnZd5dP+y/s3GGZFiVgcqWEupVCiogcZDs9bbs0eucI86GcRgm YKz+JMm4sONADfFAYY1LtVXrE9ePHj9+b+kS9LmUsqmBnoHclpny0YvPsAY/xG5+ ZxAkHdvrZw+a9Tm0BpDqEz5e2aC3w6T4q5cGppCLaKmKCyex4uJD1XmRU7gw== 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:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1704326596; x=1704412996; bh=h4eK6ul0VwLuM1O7tAmalJid0hnj Yugs+9LNJ31JBCU=; b=jN9SKXua4VXtq6ZIhyZkTQpaCB/sJU9Iv7NwUHmi0mft rTiLfMioTY0Q5zN9J+VN+HPqu8cdwcGCOsYbqzEwP1Ix/cIOriAj3wAqkG05qQyk QckyKmzf4VG/tYMfba3VDUaCmqupUYJHH2xAOq3X21PAZpF6aYDi1fd/wSA7PNOC NHchdjSZALkNQeTKdr6tFSjwEdwjGETuCuj1Sb4Uggs003+SdvfI06ZJqEhx3ZtI Yj6iQ30pRYma2RejL7H4bkcEhhwEmeKDCa7L5JPwAkKqm+z8k5LE2ovfi5niVCZc p/4PZm5Fz+ec5r0KdCWPN563VjvgN0suIO4mQEr1Ww== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrvdegiedgudeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 3 Jan 2024 19:03:13 -0500 (EST) Date: Thu, 4 Jan 2024 09:02:56 +0900 From: Michael Paquier To: Tom Lane Cc: Euler Taveira , Bharath Rupireddy , Kyotaro Horiguchi , Alvaro Herrera , Andrew Dunstan , pgsql-hackers@lists.postgresql.org Subject: Re: Add a perl function in Cluster.pm to generate WAL Message-ID: References: <3a6978d6-e4fc-4014-b5f7-45db53d8fa53@app.fastmail.com> <5d160064-8cbe-4b32-9c55-c983b1f63b12@app.fastmail.com> <370894.1704325169@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="paZQRaDUJBY5kFpC" Content-Disposition: inline In-Reply-To: <370894.1704325169@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --paZQRaDUJBY5kFpC Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Jan 03, 2024 at 06:39:29PM -0500, Tom Lane wrote: > I am not real sure what is happening there, but I see that c161ab74f > changed some details of how that test works, so I wonder if it's > responsible for these failures. The timing isn't a perfect match, > since this commit went in two weeks ago, but I don't see any > more-recent commits that seem like plausible explanations. Likely the INSERT query on retain_test that has been removed from the test is impacting the slot conflict analysis that we'd expect. -- Michael --paZQRaDUJBY5kFpC Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmWV9bAACgkQnvQgOdby QH0RXg//U2E/EVRNJL7OZ9H3A6df2PH8umLbxtU/gVL5X06SWKlxk36sM6NtA4sv ifuNDU3KfZJLO4Umkqu5qqvOypRCl2DaO6kb5cqdxKJeKc4slfIHPgv+pXtsTzH6 3uzRehpq2fHfUCQIB+gU6MP/b/YKsiv/1POJBgF7BGyEljgTNuuiA1Z5Usi1hLvT 3425jeucmY8GS5YnjwqTt871R6UwHIwTCx692nYF5vLJAMWPv8dx/dmIUDbZueCS SmSwblqtUzNld+96wzgUgRfdD2F+s0b5i9omEDLJOY87fpW/1RlB6+sZOA0IXSKR 1pvQuar5sAgk5/CX5yqSfZLdChKwzxnb8nMx+QQVe2Fie+bbFLJctEPkwD0ZQVAR CV/92anSEZWANdBUskCLF/XEGO84m/QdCeEdXmerinGYAy4VXrngIXd9c6T9Mj+H GGYLVgu/KW4ZfSJnhWLgOJ+5BTj7SBi8xmvNxAwR4rpDKN3m7m55eHu87ZT6y/Pu 6ahwrKBm1ek5Jx+/8wzTVNIKPOaSEBOqGU1Z5Pzo5azGKtVZqlQb9MWE9gw/DuXP qqKzcXIJDiZCnnoIhNZ0SwXhGU1+NDycFzjjBiAAXB6XqqEDYLaN7lj0A9MJtUl2 IclIKj6T1pmdnT6Y6vqvdakrreitHaXdy8tBK6KOFZKpNc34V8w= =vrJj -----END PGP SIGNATURE----- --paZQRaDUJBY5kFpC--