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 1nrb7W-0007KA-37 for pgsql-bugs@arkaria.postgresql.org; Thu, 19 May 2022 08:02:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nrb7U-0003dl-FF for pgsql-bugs@arkaria.postgresql.org; Thu, 19 May 2022 08:02:52 +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 1nrb7S-0003dc-PV for pgsql-bugs@lists.postgresql.org; Thu, 19 May 2022 08:02:52 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nrb7I-0005m3-0n for pgsql-bugs@lists.postgresql.org; Thu, 19 May 2022 08:02:49 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 881D05C004D; Thu, 19 May 2022 04:02:38 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Thu, 19 May 2022 04:02:38 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc: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=fm1; t=1652947358; x=1653033758; bh=0FPfz6L/cC NaDCXg/QcsrsndorweAis5pnbPAyoOHyM=; b=MP4OZnEj/QK3lPTYBwNzmRsYEY ooy6F++bF9CBrZ6s4zu0ag0Im9clp2WOAvkbViGHLKRHCYYnI+DtmAUpj/Bf4mfj KXcuVMEPhcWSnK8sgKGQh+YkLp2QtomWHANFgv3KI6mZNbXqxgAfj1nShqszqw3L l8j5xgHhwiErxykpcRzju5/88ppAVCJZzdrvp0xGAdqJ1eaxF+Ickffauh8SzGdC SE4gDJhCNxsv28ljv8/rVHS7I2niywd+3tNY+3FC0yo6fCkraRcgEDWFthjASqyp gmcl4IB1ewQQkFDU+8/+8PadKLiHQ6klVHSYCWoxZa0JHgKvs9ymQWvvB2Tw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc: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= fm1; t=1652947358; x=1653033758; bh=0FPfz6L/cCNaDCXg/Qcsrsndorwe Ais5pnbPAyoOHyM=; b=yLXrX7tDzUKAT+UFMArknoCOcFJWEbTfhtK90mMulMrf Bvl/59s1/Q5KxUEM6hSttoj12p+G3UYaMlGBU5fSRM/rnuYVoSVdJ64yWy43wyJj 3halU5YYdcN62ReFCL/iKNnOt6plZqkUlXQf3qX10WUKLtuQjX6tmHmtdeHiNo/H ZgoUc/52YjhxDkQ4m6ELesukXyfKfJf2x7Tgv/9KWVtDLBXwlONUQZctMe8f8TPU c2K9BD31ZjmFdUZtpXG3pb8AiVMGL2JAJ+Nuvg2spJIBgMS18wSVJnqFojh3D7Tg dPlsWO/z+ycvJfZUVqTfZaSYbFJ/INBs/BBwKC7L4g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedriedtgdduvdekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvvefukfhfgggtuggjsehgtderredttdejnecuhfhrohhmpefoihgthhgrvghlucfrrghq uhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvg hrnhepveetjefgjeevgedukeehieeuieeuieevueeiudegheevuefggfduueelgeelieet necuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitg hhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 19 May 2022 04:02:36 -0400 (EDT) Date: Thu, 19 May 2022 17:02:32 +0900 From: Michael Paquier To: =?utf-8?B?0J/QtdGC0YrRgCDQodC70LDQstC+0LI=?= Cc: PostgreSQL mailing lists Subject: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Message-ID: References: <17485-396609c6925b982d@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Fdd/Zg4dA0jsSmWE" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Fdd/Zg4dA0jsSmWE Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, May 19, 2022 at 08:24:27AM +0300, =D0=9F=D0=B5=D1=82=D1=8A=D1=80 = =D0=A1=D0=BB=D0=B0=D0=B2=D0=BE=D0=B2 wrote: > Yes I have made the same test on PostgreSQL 13.7, but the reindex works as > expected there (no issues). > I haven't tested on older versions. Okay, thanks. Something that has changed in this area is the addition of c98763b, where spurious waits are avoided in some of the phaese of REINDEX CONCURRENTLY. I am wondering if this is related. -- Michael --Fdd/Zg4dA0jsSmWE Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmKF+ZgACgkQnvQgOdby QH2YNRAApUJUZGcj+U8L7HIemEgZS6oV75PFdc8YkDbcE46yT9Ory5iXcp4HTJ4p 9bI50PIca7gWePEQC2WWR7SDRcfCIePY+vkp1ct3ARpJX6Uw/U4FPEXwn7STmm3u 1hvdlaaNTlCP32WRciDqmBgQJaL9dHPjTrtXQKjkD7lr7CqxsGrQgPfW+LET84f2 0A9tqtBXXpfg5rghR/76+bCa4J8/yI2ZcXwc7RmvhN5tVoyJZhUAGQ0PtGN24Ahq /4akhwqcbIOY4y5WedAMGDHAx4C5w5Vh6QvKXOKKbD9EEiQ+9i+GpugkIIE/M82H l68mBC2ftebStOpGc+F24nOUGXEzH0msfCny8p6inA/Jbx2Nmy8SyUmPI/+nYwuP UdVMfbBxjUcfQ0TFj76fShKnMSckAjhRt/ClUykQPclmPr0I5AANtNgoFORn2k49 JVm3oc6/oktL4JALGDNbKYPynOk+yo/UP56CIr5W0xU3Q1dte8JjddTGaGERHqev 4LOVpvtxMMh001XlIu0mwfYapB7S5M5Hw3/W8869NpfcX5F3wzS1dYKnonfaor9B RofAaGHhew0bRTxCnXzzYuszEgk57YZSvwqqbew27c0hRO0MwEe0cO1bnn2zEbWQ 4fLaIBLwc0SingnmvZivyEogKv0hauo4F76H81GYZu7BfCyOhV4= =V4xu -----END PGP SIGNATURE----- --Fdd/Zg4dA0jsSmWE--