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 1tNRG6-00B0jf-HN for pgsql-docs@arkaria.postgresql.org; Tue, 17 Dec 2024 06:40:43 +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 1tNRG3-00FgXb-24 for pgsql-docs@arkaria.postgresql.org; Tue, 17 Dec 2024 06:40:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tNRG2-00FgUR-K6 for pgsql-docs@lists.postgresql.org; Tue, 17 Dec 2024 06:40:39 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tNRG0-003FGP-Ax for pgsql-docs@lists.postgresql.org; Tue, 17 Dec 2024 06:40:38 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1734417632; bh=zwUJDeM5Pp0kjzLhrzIEDYyZm+i5a2gDjUNER5UQBi4=; h=Message-ID:Date:User-Agent:Subject:To:References:From:In-Reply-To: From; b=cRZCaY1auIa9Pw+6jn7zVkV4Y41LbPBfsfGqzKIO9f8l3B+DoR0yBM3TYb7pYZXoy WL9na3fmNbhQvzfoYbo/LQdhC7Fp48Hw4q8RykSYwu3Unp3lfKlvbbQ7LL9Puf1ou4 U3WiR7NNHutsVMcd30eTyyHoQabQW2zzh+TN3QbWlGcKb7lkGjW5g7BCBjLIBskl4q C3cOUXJoFaEfYcRP/QC0xhP6WsdQbB23EYuDabWIY7AvtPFtgsMXany8SqO21YFfb3 zhygXD/r6Fa648sY1WA3+/8ALg+D+GnZ+NfsWOZDMrhFL8AD0zSa3v5ECWEzSOEbaI K0I35Bex6CDig== Received: from [192.168.0.14] (broadband-46-242-15-139.ip.moscow.rt.ru [46.242.15.139]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (Client did not present a certificate) (Authenticated sender: e.rogov@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id 67263601E3; Tue, 17 Dec 2024 09:40:32 +0300 (MSK) Message-ID: <33844913-7031-35ec-52e5-11908f2453fe@postgrespro.ru> Date: Tue, 17 Dec 2024 09:40:31 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.9.1 Subject: Re: Parallel index build for BRIN Content-Language: en-US To: Tomas Vondra , pgsql-docs@lists.postgresql.org References: <114e2d5d-125e-07d8-94aa-5ad175fb7443@postgrespro.ru> <009f4101-29a2-850e-6767-72a9104ec89a@postgrespro.ru> <908b63e1-4b79-2889-98d1-1909cac39785@postgrespro.ru> <733bf5ec-2bb9-4e51-805d-b5e33a37609c@vondra.me> <61ed20a9-6b75-4f2e-b87f-0daf1b3fdf5a@vondra.me> From: Egor Rogov In-Reply-To: <61ed20a9-6b75-4f2e-b87f-0daf1b3fdf5a@vondra.me> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-KSMG-AntiPhishing: NotDetected X-KSMG-AntiSpam-Interceptor-Info: not scanned X-KSMG-AntiSpam-Status: not scanned, disabled by settings X-KSMG-AntiVirus: Kaspersky Secure Mail Gateway, version 2.1.0.7854, bases: 2024/12/17 03:27:00 #26882321 X-KSMG-AntiVirus-Status: NotDetected, skipped X-KSMG-LinksScanning: not scanned, disabled by settings X-KSMG-Message-Action: skipped X-KSMG-Rule-ID: 1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 16.12.2024 21:24, Tomas Vondra wrote: > On 12/9/24 19:54, Tomas Vondra wrote: >> On 12/8/24 16:00, Egor Rogov wrote: >>> Hi, >>> >>> ... >>> >>> I've spotted another mention of B-tree being the only AM that supports >>> parallel builds: comment in src/backend/catalog/index.c. As this mention >>> is not visible to the users, I'd propose removing it altogether rather >>> than fixing it. Updated patch is attached. >>> >> Thanks for noticing this and the patches. You're right, this should have >> been updated with the BRIN parallel builds. I'll get this committed >> sometime the week. >> > I've pushed the doc fix, and backpatched it to PG 17. Thanks so much, Tomas! Please note that the comment in src/backend/catalog/index.c remains unchanged: --- a/src/backend/catalog/index.c +++ b/src/backend/catalog/index.c @@ -2988,8 +2988,7 @@ index_build(Relation heapRelation, Assert(PointerIsValid(indexRelation->rd_indam->ambuildempty));     /* -    * Determine worker process details for parallel CREATE INDEX.  Currently, -    * only btree has support for parallel builds. +    * Determine worker process details for parallel CREATE INDEX.      *      * Note that planner considers parallel safety for us.      */