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 1rvZXo-00CpJw-2z for pgsql-hackers@arkaria.postgresql.org; Sat, 13 Apr 2024 09:19: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 1rvZXm-003awi-VR for pgsql-hackers@arkaria.postgresql.org; Sat, 13 Apr 2024 09:19:30 +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 1rvZXm-003avn-LN for pgsql-hackers@lists.postgresql.org; Sat, 13 Apr 2024 09:19:30 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rvZXj-000i2s-1o for pgsql-hackers@lists.postgresql.org; Sat, 13 Apr 2024 09:19:29 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-56829f41f81so2390902a12.2 for ; Sat, 13 Apr 2024 02:19:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1712999965; x=1713604765; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=4S5qfVDEmoJCA4GwA2FfHEtU99bVlmfTCh5mrk/i+EY=; b=CN1D455ibU3utePNNIzHvTOO8qW/XDmVW4/lE4mYn5pbzCJ3DTIFOeHXKhMun+8YHP VjAE6wDL4Te8+RG5GhJA0q91bz/ef1RXvY+Hu8Q/VNg1G/vzCP78nzlLoI/2gmEPeKJx URqlSpggU4QEtVaHuc+P08CMiEpN5SviY+xZ+3+DTXvCRu8C6tCYvT4en9YCSgH8H+mJ vvrr3GK4z/mjh3QzMgp+PmHFQZgD7mOy13+UuB6piBeMzsVUTvYvrso9XvFazCOQIYWH dM3agB0ClL9s8aZysZ0DRS7Q6EUaUjE0XsSLhBwKmFKP2gtTsnq0Uv/uwvZCGrVoGRyE LyIg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712999965; x=1713604765; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=4S5qfVDEmoJCA4GwA2FfHEtU99bVlmfTCh5mrk/i+EY=; b=Vc5vlL1Lfw5hxzGahOqTwDNza5Jwr5b+W0ExHpaw/TWn6K6pgHScZjavUPdjkOfy+7 uYffmUfYemtG65T53da5EueMG8iC170FkEVgIpGLPJa3s8MVmzPKGJhPGLB+HCt7sf+v FzjsBi9Yc2sv2yQ1EalEQF6LWxnNrDoSvJc6OkFAPisLNJPQtPPUt3FIGoPB/E+mLwzF xRW6gB48Cepk01vQc6H68ffhkGSyTxt1fHpEk01C51dKjKd5CqMusCO/q0BRF8wCGJqN kZMqYYzYaz5dwNH8sk/segTxenOq9I1fFmqHkb6OLk3LIZMpKiLLdn2zjT6jlhExvrv0 /yJQ== X-Forwarded-Encrypted: i=1; AJvYcCV6+yJVBq2yRNsvHCnL0V5I8UxoOnE0DAFO7608QN7NW0nctosL+T/Fn24j34eeIyHX4ChBR0p3E1fVUQP8pFzzxsaQ1hTPBOZh36oatytAiHVu X-Gm-Message-State: AOJu0YyLqCySFVYUw5BfrnkAvi5VJaPwCsPCw1YysdtuuvGcg0tnLzCo 2pL/FJOEEdquk+Qyk0mMVO9YGeCRexlepflmbJZxls8A6AEgG2PmrN2Ujh7AfA== X-Google-Smtp-Source: AGHT+IGBd+LUqJ+2tJJq9AVQuAmWM6jwDSHcSosgYeihLvgEdJVDRjkcplBH8gmG+rgeKe1eyzfIQw== X-Received: by 2002:a17:906:2987:b0:a52:2790:62f7 with SMTP id x7-20020a170906298700b00a52279062f7mr2445244eje.57.1712999965149; Sat, 13 Apr 2024 02:19:25 -0700 (PDT) Received: from [10.137.0.18] ([88.128.92.100]) by smtp.gmail.com with ESMTPSA id si1-20020a170906cec100b00a51a8d91397sm2792923ejb.73.2024.04.13.02.19.24 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 13 Apr 2024 02:19:24 -0700 (PDT) Message-ID: <4a9c0545-6697-47d3-bf7c-2f5d0d7a7319@enterprisedb.com> Date: Sat, 13 Apr 2024 11:19:21 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Parallel CREATE INDEX for BRIN indexes To: Andres Freund Cc: Matthias van de Meent , PostgreSQL Hackers References: <99f9ecbe-0976-8012-67b5-dbff58c7dbec@enterprisedb.com> <32e3f645-389d-87f9-2ce7-33d0087f47d4@enterprisedb.com> <3733d042-71e1-6ae6-5fac-00c12db62db6@enterprisedb.com> <20240413083635.47yve2c5pp2xt5b6@awork3.anarazel.de> Content-Language: en-US From: Tomas Vondra In-Reply-To: <20240413083635.47yve2c5pp2xt5b6@awork3.anarazel.de> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/13/24 10:36, Andres Freund wrote: > Hi, > > While preparing a differential code coverage report between 16 and HEAD, one > thing that stands out is the parallel brin build code. Neither on > coverage.postgresql.org nor locally is that code reached during our tests. > Thanks for pointing this out, it's definitely something that I need to improve (admittedly, should have been part of the patch). I'll also look into eliminating the difference between BTREE and BRIN parallel builds, mentioned in my last message in this thread. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company