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 1v610F-00FV2O-6o for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Oct 2025 06:16:51 +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 1v610C-00DzNK-Si for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Oct 2025 06:16:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v610C-00DzN4-J0 for pgsql-hackers@lists.postgresql.org; Tue, 07 Oct 2025 06:16:49 +0000 Received: from flow-a5-smtp.messagingengine.com ([103.168.172.140]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v610B-000o0x-0y for pgsql-hackers@postgresql.org; Tue, 07 Oct 2025 06:16:49 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailflow.phl.internal (Postfix) with ESMTP id B5CA013800C5; Tue, 7 Oct 2025 02:16:44 -0400 (EDT) Received: from phl-imap-03 ([10.202.2.93]) by phl-compute-04.internal (MEProxy); Tue, 07 Oct 2025 02:16:44 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=compiler.org; h= cc:cc:content-transfer-encoding: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=1759817804; x=1759825004; bh=L9TYuQrQiAX8HpFKHxJnU4L2+zcEPFRzYOzlTGsIwS8=; b= eU37a7rOJeh1lxd0HY4VHNl97mgR+BDsx0z0ry5aTh6flGzj982FFEytHwxlKGd6 mAPdEPrsN2KYgY3+dsTfwlk7beGSImKP88Zei5BQxBQKO8ntQN37htlhw33YeY+q AcZfHjrNbt1FOLuYT5qRldwZoAYWuRs56qO2lqIuGy1IlRh6PL70QdCcu04BXgOo y+D2Mu0YZHAe7ZFFWr9rRg96fe71GJFKsf9f6bxvwNfpcWOM4yLcb+wFVyxxH1pj sgfeDgG97GjQ6Gl0mUZNse9Igru07gW6kNr9ID+Kjeq5eY0ZpzPk9v3UaWpyLZqp 6JM9AYEGXea2DQSfIveB5Q== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :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-sender:x-me-sender:x-sasl-enc; s=fm2; t=1759817804; x= 1759825004; bh=L9TYuQrQiAX8HpFKHxJnU4L2+zcEPFRzYOzlTGsIwS8=; b=r Vlhq5dktmeMTNqcS+6zW/ZMXzCjrZOWfOl80Qo27c3Ff5rJ7le/Pyl3Nr+CKVwc/ m0+hNQzjt6EBiYGNZxAfQg0dNbRTu2sy9oyyl8fkAvEm7M8EdkAay7/2UeJm5Gvb Jm1ekAHxAGrVoUPFNN/qTvn1lJpSzCY66KZZH10WrHqw6SIMwng+aR8GX231lMun e8ZoZt0JGTMcrpJGRJSlggbEUJUoYaY9y/2GEURS4AzKIbNE2UlZZpmgpBcEHpuZ vuJ+CByOIsX+yJngx4YzLOxPYO1J6+zNeLI6C5THlMpzgbRS12vdQ7fWRRiiDJNy gWNtxTIa1adeuVmCQkbLg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdelleeijecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecunecujfgurhepofggfffhvfevkfgjfhfutgfgsehtjeertd ertddtnecuhfhrohhmpedflfhovghlucflrggtohgsshhonhdfuceojhhovghlsegtohhm phhilhgvrhdrohhrgheqnecuggftrfgrthhtvghrnhepfeehleffgedvleefveetjedtke etfeeliefhtdduleekieejtdevgfeuveeikeeinecuvehluhhsthgvrhfuihiivgeptden ucfrrghrrghmpehmrghilhhfrhhomhepjhhovghlsegtohhmphhilhgvrhdrohhrghdpnh gspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepphhgshhq lhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohepthhglh esshhsshdrphhghhdrphgrrdhush X-ME-Proxy: Feedback-ID: ic6394509:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id 53B9018E0054; Tue, 7 Oct 2025 02:16:44 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: AZ7XRsRLdGms Date: Tue, 07 Oct 2025 08:16:24 +0200 From: "Joel Jacobson" To: "Tom Lane" Cc: pgsql-hackers Message-Id: <4108d486-3120-4ea2-917f-42773b7da375@app.fastmail.com> In-Reply-To: <2276337.1759815796@sss.pgh.pa.us> References: <6899c044-4a82-49be-8117-e6f669765f7e@app.fastmail.com> <165530.1752362320@sss.pgh.pa.us> <02a7cd37-e2fc-4212-8b19-f8c239c95fb8@app.fastmail.com> <96f00bf1-cc9d-4520-9d02-9e14e7767c88@app.fastmail.com> <30c2aa7d-dd6c-4b68-a2e4-f217a1a34acf@app.fastmail.com> <0b4d402a-9ac2-4aa8-acf8-8231dbe579ea@app.fastmail.com> <3095599.1758644879@sss.pgh.pa.us> <0dc6a2cc-5216-4dc1-9dd2-430cafc6095b@app.fastmail.com> <52CC167F-763B-4ECA-B0B4-DAB381816828@gmail.com> <9186C6D0-F7A9-482A-9183-89E530B57E36@gmail.com> <1073593.1759423179@sss.pgh.pa.us> <4bd5e6c4-6fa7-44bb-869d-59a32a331fa8@app.fastmail.com> <2276337.1759815796@sss.pgh.pa.us> Subject: Re: Optimize LISTEN/NOTIFY Content-Type: text/plain Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Oct 7, 2025, at 07:43, Tom Lane wrote: > "Joel Jacobson" writes: >> Trying to fix the NetBSD failure. >> I don't understand why 001_constraint_validation, test 'list_parted2_def >> scanned' and test 'part_5 verified by existing constraints' should be >> affected by this patch. I guess I could have gotten something wrong with >> the locking with dshash, that might somehow affect other tests? > > Our CI infrastructure is not as stable as one could wish. You > sure this is related at all? No, not sure at all. OK, then going forward, I guess I should ignore errors coming from just a single farm animal if the error seems unrelated to my patch. /Joel