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 1sS3ja-003VLF-Tr for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Jul 2024 00:01:59 +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 1sS3jY-001tY9-BH for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Jul 2024 00:01:56 +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 1sS3jX-001tXz-HO for pgsql-hackers@lists.postgresql.org; Fri, 12 Jul 2024 00:01:56 +0000 Received: from fhigh1-smtp.messagingengine.com ([103.168.172.152]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sS3jV-001dYl-0X for pgsql-hackers@lists.postgresql.org; Fri, 12 Jul 2024 00:01:54 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 532DB1140948; Thu, 11 Jul 2024 20:01:51 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Thu, 11 Jul 2024 20:01:51 -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:subject :subject:to:to; s=fm2; t=1720742511; x=1720828911; bh=nOgyr3xGS7 3WPiZ7cbUqrWccuVUCSiA5d4emmyqdqqo=; b=QO0sf5xMO+4w+0+YoZGAAg/dNR bd+4Z4J7qnuISrqvowX8Wj18C0mNiZ/1+YRk4WKWIVWriESfQnxUp8BTDK7+Euim UTSQL26PpjDVUGCULuBfoG/FPJWbT8Ty/g5OWA/i/KL2G+0yy727dja2lzfFo9aD osXyQhzwMQ8vQqnRskg6ZJ1GN2b7VwGxwpsK809CuXGEseyLUfZQoPLa5nQfVvuI iPKPiz56uHABBd6/m7TkRxkiS9q8DtB7q9w03jMLjzhaeDx9K6J2rBjKhD4D7QQk x0todysmikX6QKsGTliGD1e9qdaiGXSC+BYslsnIo6GsUHAi0kdQzllfqPMQ== 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=1720742511; x=1720828911; bh=nOgyr3xGS73WPiZ7cbUqrWccuVUC SiA5d4emmyqdqqo=; b=vBXUwBvWjvPXbDYJ5NGXksy3fuJfarquJL8GTXbsz/3U NWUbg40dViqjDo9JmbxHCWCvopTDIWm1dJwqQIzXhyE5WRXxmFPFb/7QJIJI3ZBu HwcORA4JJYce3Ttyj/KGXMg7exSbMomGZ+RpCAlOYQxZKjmmXDfJb5l/m88VKxA/ WKbRYqIoYOTx0bBgLk6i4drCxZPq91PYkRds6Tud50jpsC+jRJzuv6jkmP21lHN1 urc8PIGvebloJ9iB7TzrgP5jC8/CCBu+zh8+XZrvrRVfmP6pD9DlxW8GSFF1GE51 OeDRUG0fQrf2Am+5ye4ae+KFAZVDjYDcQM9O7kEKnw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrfeehgdefudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddt jeenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeevteejgfejveegudekheeiueei ueeiveeuiedugeehveeugffgudeuleegleeiteenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 11 Jul 2024 20:01:47 -0400 (EDT) Date: Fri, 12 Jul 2024 09:01:30 +0900 From: Michael Paquier To: Ilya Gladyshev Cc: Justin Pryzby , Alexander Pyhalov , pgsql-hackers@lists.postgresql.org, Masahiko Sawada , =?utf-8?B?IuadjuadsCjmhY7ov70pIg==?= Subject: Re: CREATE INDEX CONCURRENTLY on partitioned index Message-ID: References: <37d3f0a984a15f6465b83027eed8c588@postgrespro.ru> <8fe0027c-a4f9-43a0-afc1-20362c159d07@gmail.com> <76a11eea-c5ae-4034-971d-c8a2df0bb14d@gmail.com> <55cfae76-2ffa-43ed-a7e7-901bffbebee4@gmail.com> <5F602655-58E6-4562-85D3-34E04BE9D60C@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="c3Rt7b6BhTIT3lXn" Content-Disposition: inline In-Reply-To: <5F602655-58E6-4562-85D3-34E04BE9D60C@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --c3Rt7b6BhTIT3lXn Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Jul 11, 2024 at 09:35:24PM +0100, Ilya Gladyshev wrote: > It is broken in master, I just didn=E2=80=99t want to create a separate > thread, but it can be fixed independently. As I remember, the > problem is that progress is tracked for each table in the hierarchy > as if the table is processed separately, without ever setting > partitions_total and partitions_done counters. Please let's move this point to its own thread and deal with it with an independent patch. Hiding that in a thread that's already quite long is not a good idea. This needs proper review, and a separate thread with a good subject to describe the problem will attract a better audience to deal with the problem you are seeing. I was not paying much attention, until you've mentioned that this was an issue with HEAD. -- Michael --c3Rt7b6BhTIT3lXn Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmaQcloACgkQnvQgOdby QH02Eg/+LJe8O3v2B+egKEXuGFxGRJHk+ysT4aSwtWnNmpCgc8qEHdqSvqzAmtuZ 9nowDCFibWJ7a82cTvh10f/UKXu+D/zvwOlccd2eywsI2QwmEkaQNVRT/25y6M5+ fuMB1ujpRzzyazM8a6lpTQ1fkN7uKY+LSBSGwTJ0gqdUUEUnQvaGnFCT7eFOV6Vp HDVqsRbR65tyATa9T79RIjuz9hicOoRSO5SL1RZ07tpwKhbojfY3PydyOKBlgeVe D2jI66CH/TWbicMXPpBnp89INTmsNoTnd6oQyII1LJ3paQO3Rl6dSnGO4J825Kag MSMjiUxUbLjSJUuUETxIUpjlLd2CNM7S+b2uZh+r5XyqkwnjSBVNGgUuGAmMEhWG rsdshttUDIgVPMwVGAMNew6XvnZzGoRKjt/W5xW2Ie1K+kpey5EIWE4a8El3BO0b KTcOc6zmctqVG4R+oA5RtToQo9r4GpkRWQUcDaDXToH7m7h1o+y/CQ2d6D3g8PnN 3hn9dZLmAluYlP9lHwudxXJ28HwRqYaKN/efKFr55733lSJbkxyC4IrVLctrikqR g+GKgHC1HLQPp/1iUQr/IyBL39foyCDuq5XXpH569N4jp0OXMSb+5MsiGrYznkIp v/LPNnzDsWaCFhM5IcSuxuinbSrj3GDgbjxDjMkE4wMrgDl3MP8= =DHWu -----END PGP SIGNATURE----- --c3Rt7b6BhTIT3lXn--