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.96) (envelope-from ) id 1vfaN1-0036Kv-18 for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jan 2026 09:07:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vfaN0-003e2C-0O for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jan 2026 09:07:22 +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.96) (envelope-from ) id 1vfaMz-003e23-19 for pgsql-hackers@lists.postgresql.org; Tue, 13 Jan 2026 09:07:22 +0000 Received: from fhigh-a6-smtp.messagingengine.com ([103.168.172.157]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vfaMw-000BZ7-1m for pgsql-hackers@postgresql.org; Tue, 13 Jan 2026 09:07:21 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfhigh.phl.internal (Postfix) with ESMTP id 3CEE11400091; Tue, 13 Jan 2026 04:07:16 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-03.internal (MEProxy); Tue, 13 Jan 2026 04:07:16 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1768295236; x= 1768381636; bh=2jPHjzlUs+rU4tWi/pbdanaSIuDGE9OCbGI56Uk6sPY=; b=h kR+NKOq6D0El4/L0syoZLWaD++u5cgTO8N3CT6AsuLsbK9uxgj6YtqhhOBQ96Qqd mY4gEyHl92ycqa3czJ3UWzBb2woa4tCVZS9sge6/U+IxzcSS2Se7wpB1XjuTFkAT xfPn9x4XcKz0bgWfzzRgH9Bxk0elDgzySc1yeoJh2l4nFScbFjer6SVwvg11wbVv eqW77CcSAxmPX4ra/mRuC+aKOKem59kFhI0MvmygD2NJVOfVy55lMlG1nflMrHws ovZbilblcc8N80CpoCOnVex300RV+jq21hRJmKaOHLaDBW5bHy/UZjBQSBDYqv2b 9+gK5SvH2fJ5xPuRpilgw== 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 :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1768295236; x=1768381636; bh=2 jPHjzlUs+rU4tWi/pbdanaSIuDGE9OCbGI56Uk6sPY=; b=EQJpzOrawNnzhntw6 0Gt3YNBs1RiNAS5pF9ftA0gop0U/B3nnMLWFFr7JzdlGroPq34MjlL2c+5quSv+i gVh0XDXuoxqgvJMiVlJpHJSemAjfq4bYezj0FjTBoFKt15+cv1lNDxFL1Q/raijg Zz6Z4YHkfdJiLOUoekkjRj6sUH3blnPGA8pNRFCvNwwcFVc9azBBCwBoeGxYOVlW PGrg742CLYxLdWOX1VQsxSJvti0FIDrV7KlZFOKBuzd+X1m66afVxwKUYqQvNfwz BrQvJVpfl9T5KfoTl68hb8K5mM3+LzZVp3XYwd8wCj8WVBfik6+RR3eO23wbRqMh jUAng== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdduudelledvucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheplmhlvhgrrhho ucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvqeenucggtf frrghtthgvrhhnpeetuedvheffkeevgfeuheevteevkefggedttdeufeeuheduuddthfef fffhjeefffenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgv sehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtthhopeehpdhmohguvgepshhmthhpoh huthdprhgtphhtthhopegrnhgurhgvshesrghnrghrrgiivghlrdguvgdprhgtphhtthho pehmihhhrghilhhnihhkrghlrgihvghusehgmhgrihhlrdgtohhmpdhrtghpthhtohepnh horghhsehlvggruggsohgrthdrtghomhdprhgtphhtthhopehmihgthhgrvghlsehprghq uhhivghrrdighiiipdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtgh hrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 13 Jan 2026 04:07:15 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1768295233; bh=d4qYuiYJrGg0z/Ip1tiBPRtZTaT5hKcmiHGoWh8PsAw=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=cEpNsGZ4yKU0TCU1huEnproYao78HmGnnqjAaaAhu/37lImqY8s403fmr4/3gN8ZJ L8Hsu30YKuwXxo9dKAFfMBnlfVxm2XWy4OG24C/Zp+SoPLc73xqoK86HURw75atrio tSsWtym951+F/5sCwoU+j0dZQqybICkEiNQsuPBYsbIcvvIHLMdMioE9XxaitplW4S GHEIwk8Xgmcj/HtIzBOGMtn7UbMD8l/kXdKCQq9HWKO99BFK7lPk8risilGQVrAkal 6XL8eG2OMIhPFsDtZrPmda0qydhCj6aPFZsFcbNknmOfyjHpkcfqAk+ymHK+Pi9wy9 bxmlijwEmJoWg== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id C47C57A; Tue, 13 Jan 2026 10:07:13 +0100 (CET) Date: Tue, 13 Jan 2026 10:07:13 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Mihail Nikalayeu Cc: Andres Freund , Michael Paquier , Noah Misch , pgsql-hackers Subject: Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY Message-ID: <202601130905.u7ieo66nvc67@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-Jan-09, Mihail Nikalayeu wrote: > Fixes for the fixes are in attachment. Thanks, pushed 0001 with some minor tweaks. (My bug: sleep(0.1) doesn't do what one would expect.) > I am not very confident about the second commit, because I am not an > expert in meson/Makefiles. > Some additional explanations are available in commit messages. > > Tested with -DCLOBBER_CACHE_ALWAYS=1 I reworded the comments because the problem also manifests with RELCACHE_FORCE_RELEASE. > I hope this is the last one. Me too :-) -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "La persona que no quería pecar / estaba obligada a sentarse en duras y empinadas sillas / desprovistas, por cierto de blandos atenuantes" (Patricio Vogel)