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 1qTlYR-00AbB2-TN for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Aug 2023 15:57:00 +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 1qTlYQ-006cuc-66 for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Aug 2023 15:56:58 +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 1qTlYP-006ct3-S8 for pgsql-hackers@lists.postgresql.org; Wed, 09 Aug 2023 15:56:58 +0000 Received: from mail-ej1-x630.google.com ([2a00:1450:4864:20::630]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qTlYK-001VYi-Oa for pgsql-hackers@lists.postgresql.org; Wed, 09 Aug 2023 15:56:57 +0000 Received: by mail-ej1-x630.google.com with SMTP id a640c23a62f3a-986d8332f50so4720666b.0 for ; Wed, 09 Aug 2023 08:56:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1691596610; x=1692201410; 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=pG+0TmKrfaStn7hKM3QsWqsBSyw89iP9+XTnuQlABOI=; b=auNWsGhahX+DtMV+uMxbHkEZiGT6HkD+P5XgJeSllPwpxAceoCH8TmDz6Peg7CFFG4 t8r1X5Jgk92Vmz7ize9kVuH7DbQbHxaR/HD+K4zqkb9exsauSjldHhP5d4F7KEH4g7Jw XOk2KAIQmyGE7jDt41zlZJ0WagfwP6TiQZl0ZFQ0I6FDYH1h+0fPz9a3j06l6u2TtAkm O9vqaBtDK6bfaFxgpjqIBWNOMf10S9KyRnhKTr1FMbe837MkFpygJ1LKhgizkAYX7cHX LwIsB7MX2tIsnOVGa3MiBqcSXO4en38ZWuIahU6n9Y5Aq3PkntyactammSHTiK3mqvZT 4yrQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1691596610; x=1692201410; 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=pG+0TmKrfaStn7hKM3QsWqsBSyw89iP9+XTnuQlABOI=; b=R2r08VnUjyJARrAEQmmhw36/Lq4brnbagBP4FBwJX2wzD6CTzpFaKAl762oiJpDX3r 7n3fNd/rezngKfTj5nI5kJbhF7MtFfZL2TCj+dzDM+KEXDnRxlNlubq2DdT54sjc7XdK HhNKWdUaqIOQl29+GjeunqmdZekegIzu1RAojbSI+WJbNDD/eyzVW9KNkSUaEo52inuC KFw2DtuB2kRQX5wYuimjqm9DEZ4Lg94Yz14VZbdBFQa/yX/tm2soeobZgkSLx7E+jEVV C1OsipP2ppmzN6UrtbzGqleXeL9aVpbNxxM9HedkwTGnVAYCtfFhL4TjvjKuVTCHYI5n gUAQ== X-Gm-Message-State: AOJu0YyZIXL3g4jahAJpWm8CFE8koXOLlYiMPKmDWSNGZtNU732VD0YI /JWGs7+NfUQTwmWLnvDSelvDwsur836zChNglqI= X-Google-Smtp-Source: AGHT+IH6iBiy6DQa/arcdpQWgqXwmQ6QayWL8WiQ7Y3aDuNZV3ISZzjd6fGx3Fh4Q40aE6pYv+tiiA== X-Received: by 2002:a17:906:5e:b0:99c:bcb1:3a67 with SMTP id 30-20020a170906005e00b0099cbcb13a67mr2716176ejg.30.1691596610143; Wed, 09 Aug 2023 08:56:50 -0700 (PDT) Received: from [10.137.0.17] (static-84-42-175-93.bb.vodafone.cz. [84.42.175.93]) by smtp.gmail.com with ESMTPSA id o24-20020a1709064f9800b00993a9a951fasm8309384eju.11.2023.08.09.08.56.49 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 09 Aug 2023 08:56:49 -0700 (PDT) Message-ID: <486f389c-9306-23db-dbb5-5ffc3fec411d@enterprisedb.com> Date: Wed, 9 Aug 2023 17:56:48 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: pgsql: Ignore BRIN indexes when checking for HOT udpates To: Alvaro Herrera , pgsql-hackers@lists.postgresql.org Cc: Matthias van de Meent , Tomas Vondra , =?UTF-8?B?Sm9zZWYgxaBpbcOhbmVr?= References: <20230809091155.7c7f3gttjk3dj4ze@alvherre.pgsql> Content-Language: en-US From: Tomas Vondra In-Reply-To: <20230809091155.7c7f3gttjk3dj4ze@alvherre.pgsql> 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 8/9/23 11:11, Alvaro Herrera wrote: > On 2021-Nov-30, Tomas Vondra wrote: > >> Ignore BRIN indexes when checking for HOT udpates > > I was trying to use RelationGetIndexAttrBitmap for something and > realized that its header comment does not really explain things very > well. That was already the case before this commit, but it (this > commit) did add new possible values without mentioning them. I propose > the attached comment-only patch. > +1 -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company