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 1tNYw4-000dEe-A1 for pgsql-docs@arkaria.postgresql.org; Tue, 17 Dec 2024 14:52:32 +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 1tNYw3-002Uyf-Ii for pgsql-docs@arkaria.postgresql.org; Tue, 17 Dec 2024 14:52:31 +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 1tNYw3-002UyR-A5 for pgsql-docs@lists.postgresql.org; Tue, 17 Dec 2024 14:52:31 +0000 Received: from relay3-d.mail.gandi.net ([2001:4b98:dc4:8::223]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tNYw0-000Cdj-II for pgsql-docs@lists.postgresql.org; Tue, 17 Dec 2024 14:52:30 +0000 Received: by mail.gandi.net (Postfix) with ESMTPSA id D5AC260003; Tue, 17 Dec 2024 14:52:26 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=vondra.me; s=gm1; t=1734447147; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=+c1a8TNp53GnWyDTm+fA+7pqL+77TBiyOBT/nQTETKs=; b=bc+1rhzfzt6YmbAV2bApxXfllTRU+Tx3UZEBMtdpRp6gkfAwSWOtWb0ZgNKGXFCdlX/IrL WroOzLkPZmPCrMr8OGS4JDWBPOF1y45ZSyIFoYDAaE1h3wHR/SAGOrv0hDwipr/8b8AOst FIOmm4vJt3oetzHB5w1hmrDq4sbPsTSMCA+US2L+T8ueKhZ2/R6aVP0xv9FdHIh/aNbMqm P3EZFSqOASpUWrmstlTZMdKDZRJdfiqqsUD8KU82zVUPQquyCccsw76lV1mEao/7Hw8W9r oHRbMH6ujw7iWtWeKEYaqGhQusLomciYonqjxYR4bE8PcVKNNRPxJRcxYf/OXQ== Message-ID: Date: Tue, 17 Dec 2024 15:52:25 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Parallel index build for BRIN To: Egor Rogov , 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> <33844913-7031-35ec-52e5-11908f2453fe@postgrespro.ru> Content-Language: en-US From: Tomas Vondra In-Reply-To: <33844913-7031-35ec-52e5-11908f2453fe@postgrespro.ru> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-GND-Sasl: tomas@vondra.me List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/17/24 07:40, Egor Rogov wrote: > 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. >      */ > Oh, thanks for noticing that. I'm not sure why I missed that, I must have used the first patch by mistake. Anyway, I found another obsolete comment in planner.c, so I fixed that too and pushed. Thanks -- Tomas Vondra