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 1ox828-0005w5-8s for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Nov 2022 14:44:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ox827-00009I-58 for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Nov 2022 14:44:27 +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 1ox826-00007c-Lr for pgsql-hackers@lists.postgresql.org; Mon, 21 Nov 2022 14:44:26 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ox823-0004kd-Qi for pgsql-hackers@lists.postgresql.org; Mon, 21 Nov 2022 14:44:25 +0000 Received: from mail.postgrespro.ru (cyclops.postgrespro.ru [93.174.131.138]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 7E66221C224E; Mon, 21 Nov 2022 17:44:22 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1669041862; bh=6CwsMVtcgaH3OORiBnVCNRSVM00EGj6DKJonE9ZyKrE=; h=Date:From:To:Cc:Subject:In-Reply-To:References; b=HvAOwewngOus8rgYBTa5RnaHdI6Mm8JazKNzcxCPUQe3oFY0OtkfRweof/ADFZqd6 LwVl0//lVwkn4jTPEt5xi11AOiEN59BdOsVhn6u56lFCvUBksCjyggI5JnXRpw6qdQ sWSZ7GOcP5oZZKk5EoJFsabalaFpTmUwZ42lMmMs= MIME-Version: 1.0 Date: Mon, 21 Nov 2022 17:44:22 +0300 From: Alexander Pyhalov To: Justin Pryzby Cc: pgsql-hackers@lists.postgresql.org, Masahiko Sawada , Michael Paquier , =?UTF-8?Q?=E6=9D=8E=E6=9D=B0=28=E6=85=8E=E8=BF=BD=29?= , =?UTF-8?Q?=E6=9B=BE=E6=96=87=E6=97=8C=28?= =?UTF-8?Q?=E4=B9=89=E4=BB=8E=29?= , Alvaro Herrera Subject: Re: CREATE INDEX CONCURRENTLY on partitioned index In-Reply-To: <20221121030011.GU11463@telsasoft.com> References: <20201031063117.GF3080@telsasoft.com> <20201129202221.GA9477@telsasoft.com> <20210128143013.GC7450@telsasoft.com> <20210226182019.GU20769@telsasoft.com> <04657227cc37b6353cf0c72bedac70cc@postgrespro.ru> <20220628183309.GD28130@telsasoft.com> <20221121030011.GU11463@telsasoft.com> User-Agent: Roundcube Webmail/1.4.11 Message-ID: X-Sender: a.pyhalov@postgrespro.ru Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Justin Pryzby писал 2022-11-21 06:00: > I finally found time to digest and integrate your changes into my local > branch. This fixes the three issues you reported: FORCE_RELEASE, issue > with INVALID partitions issue (for which I adapted your patch into an > earlier patch in my series), and progress reporting. And rebased. Hi. Thank you for the effort. I've looked through and tested new patch a bit. Overall it looks good to me. The question I have is whether we should update pg_stat_progress_create_index in reindex_invalid_child_indexes(), when we skip valid indexes? -- Best regards, Alexander Pyhalov, Postgres Professional