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 1peCQ1-0006Kc-BM for pgsql-committers@arkaria.postgresql.org; Mon, 20 Mar 2023 10:07:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peCQ0-0004d4-2a for pgsql-committers@arkaria.postgresql.org; Mon, 20 Mar 2023 10:07:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peCPz-0004cv-Gj for pgsql-committers@lists.postgresql.org; Mon, 20 Mar 2023 10:07:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peCPw-0005TO-QR for pgsql-committers@lists.postgresql.org; Mon, 20 Mar 2023 10:07:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=TF6Xla7JN34ZPEWrfFBW/VvRmqX7kSsS7n2YhBenz/8=; b=DUERj98CTdtCBety1ar07tO/QI XE5REPNNZ6fyuPXUFtkwqd9Cp8sVme06nfLv1a4zlS1Lr180ZauqhXQaLlHFkZJFFJHIhoVR9OxRF dCKQAY58NY+MO7hmeZyR4yRv0gwxVeReyP5TQIBR9Z70g815Vqh4YuEXdC4YeaPC3VqZWIooO+TbY ZjqW0C0q0AZ8UfJLjFbFX+PBFH8r8T+FaRhEiqPqWcNwgK8kQbTGFUuyj8qTMl36iM75E664QFief Ew+OADEgL5aGna5KuFUXRN4xaHZBbg0hfVtKVrXJlXfFPb+xm6MEMZeY4ZTB0KvhMDXDw5qSaJWLz WmB/zd9g==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peCPv-0005A2-Ey for pgsql-committers@lists.postgresql.org; Mon, 20 Mar 2023 10:07:03 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1peCPu-004SkQ-1A for pgsql-committers@lists.postgresql.org; Mon, 20 Mar 2023 10:07:02 +0000 Content-Type: multipart/mixed; boundary="===============0356759719792412916==" MIME-Version: 1.0 From: Tomas Vondra To: pgsql-committers@lists.postgresql.org Subject: pgsql: Ignore BRIN indexes when checking for HOT updates X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 20 Mar 2023 10:07:02 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0356759719792412916== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SWdub3JlIEJSSU4gaW5kZXhlcyB3aGVuIGNoZWNraW5nIGZvciBIT1QgdXBkYXRlcwoKV2hlbiBk ZXRlcm1pbmluZyB3aGV0aGVyIGFuIGluZGV4IHVwZGF0ZSBtYXkgYmUgc2tpcHBlZCBieSB1c2lu ZyBIT1QsIHdlCmNhbiBpZ25vcmUgYXR0cmlidXRlcyBpbmRleGVkIGJ5IGJsb2NrIHN1bW1hcml6 aW5nIGluZGV4ZXMgd2l0aG91dApyZWZlcmVuY2VzIHRvIGluZGl2aWR1YWwgdHVwbGVzIHRoYXQg bmVlZCB0byBiZSBjbGVhbmVkIHVwLgoKQSBuZXcgdHlwZSBUVV9VcGRhdGVJbmRleGVzIHByb3Zp ZGVzIGEgc2lnbmFsIHRvIHRoZSBleGVjdXRvciB0bwpkZXRlcm1pbmUgd2hpY2ggaW5kZXhlcyB0 byB1cGRhdGUgLSBubyBpbmRleGVzLCBhbGwgaW5kZXhlcywgb3Igb25seSB0aGUKc3VtbWFyaXpp bmcgaW5kZXhlcy4KClRoaXMgYWxzbyByZW1vdmVzIHJkX2luZGV4YXR0ciBsaXN0LCBhbmQgcmVw bGFjZXMgaXQgd2l0aCByZF9hdHRyc3ZhbGlkCmZsYWcuIFRoZSBsaXN0IHdhcyBub3QgdXNlZCBh bnl3aGVyZSwgYW5kIGEgc2ltcGxlIGZsYWcgaXMgc3VmZmljaWVudC4KClRoaXMgd2FzIG9yaWdp bmFsbHkgY29tbWl0dGVkIGFzIDU3NTNkNGVlMzIsIGJ1dCB0aGVuIGdvdCByZXZlcnRlZCBieQpl M2ZjY2EwZDBkIGJlY2F1c2Ugb2YgY29ycmVjdG5lc3MgaXNzdWVzLgoKT3JpZ2luYWwgcGF0Y2gg YnkgSm9zZWYgU2ltYW5laywgdmFyaW91cyBmaXhlcyBhbmQgaW1wcm92ZW1lbnRzIGJ5IFRvbWFz ClZvbmRyYSBhbmQgbWUuCgpBdXRob3JzOiBNYXR0aGlhcyB2YW4gZGUgTWVlbnQsIEpvc2VmIFNp bWFuZWssIFRvbWFzIFZvbmRyYQpSZXZpZXdlZC1ieTogVG9tYXMgVm9uZHJhLCBBbHZhcm8gSGVy cmVyYQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzA1ZWJjYjQ0LWYzODMtODZlMy00 ZjMxLTBhOTdhNTU2MzRjZkBlbnRlcnByaXNlZGIuY29tCkRpc2N1c3Npb246IGh0dHBzOi8vcG9z dGdyLmVzL20vQ0FGcDdRd3BNUkdjREFRdW1ON29uTjlIanJKM3U0WDNaUlhkR0ZUMEs1RzJKV3Zu YldnJTQwbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0t LS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8xOWQ4ZTIzMDhiYzUx ZWM0YWI5OTNjZTkwMDc3MzQyYzkxNWRkMTE2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0t LQpkb2Mvc3JjL3NnbWwvaW5kZXhhbS5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgfCAgMTMg KysrCnNyYy9iYWNrZW5kL2FjY2Vzcy9icmluL2JyaW4uYyAgICAgICAgICAgICAgICAgICB8ICAg MSArCnNyYy9iYWNrZW5kL2FjY2Vzcy9naW4vZ2ludXRpbC5jICAgICAgICAgICAgICAgICB8ICAg MSArCnNyYy9iYWNrZW5kL2FjY2Vzcy9naXN0L2dpc3QuYyAgICAgICAgICAgICAgICAgICB8ICAg MSArCnNyYy9iYWNrZW5kL2FjY2Vzcy9oYXNoL2hhc2guYyAgICAgICAgICAgICAgICAgICB8ICAg MSArCnNyYy9iYWNrZW5kL2FjY2Vzcy9oZWFwL2hlYXBhbS5jICAgICAgICAgICAgICAgICB8ICA0 OCArKysrKysrKystCnNyYy9iYWNrZW5kL2FjY2Vzcy9oZWFwL2hlYXBhbV9oYW5kbGVyLmMgICAg ICAgICB8ICAxOSArKystCnNyYy9iYWNrZW5kL2FjY2Vzcy9uYnRyZWUvbmJ0cmVlLmMgICAgICAg ICAgICAgICB8ICAgMSArCnNyYy9iYWNrZW5kL2FjY2Vzcy9zcGdpc3Qvc3BndXRpbHMuYyAgICAg ICAgICAgICB8ICAgMSArCnNyYy9iYWNrZW5kL2FjY2Vzcy90YWJsZS90YWJsZWFtLmMgICAgICAg ICAgICAgICB8ICAgMiArLQpzcmMvYmFja2VuZC9jYXRhbG9nL2luZGV4LmMgICAgICAgICAgICAg ICAgICAgICAgfCAgIDkgKy0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9pbmRleGluZy5jICAgICAgICAg ICAgICAgICAgIHwgIDM1ICsrKysrLS0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvY29weWZyb20uYyAg ICAgICAgICAgICAgICAgIHwgICA1ICstCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2luZGV4Y21kcy5j ICAgICAgICAgICAgICAgICB8ICAxMCArLQpzcmMvYmFja2VuZC9leGVjdXRvci9leGVjSW5kZXhp bmcuYyAgICAgICAgICAgICAgfCAgMzcgKysrKysrLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhl Y1JlcGxpY2F0aW9uLmMgICAgICAgICAgIHwgICA5ICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL25v ZGVNb2RpZnlUYWJsZS5jICAgICAgICAgICB8ICAxMyArKy0Kc3JjL2JhY2tlbmQvbm9kZXMvbWFr ZWZ1bmNzLmMgICAgICAgICAgICAgICAgICAgIHwgICA3ICstCnNyYy9iYWNrZW5kL3V0aWxzL2Nh Y2hlL3JlbGNhY2hlLmMgICAgICAgICAgICAgICB8ICA3MCArKysrKysrKysrLS0tLQpzcmMvaW5j bHVkZS9hY2Nlc3MvYW1hcGkuaCAgICAgICAgICAgICAgICAgICAgICAgfCAgIDIgKwpzcmMvaW5j bHVkZS9hY2Nlc3MvaGVhcGFtLmggICAgICAgICAgICAgICAgICAgICAgfCAgIDUgKy0Kc3JjL2lu Y2x1ZGUvYWNjZXNzL3RhYmxlYW0uaCAgICAgICAgICAgICAgICAgICAgIHwgIDIyICsrKystCnNy Yy9pbmNsdWRlL2V4ZWN1dG9yL2V4ZWN1dG9yLmggICAgICAgICAgICAgICAgICB8ICAgMyArLQpz cmMvaW5jbHVkZS9ub2Rlcy9leGVjbm9kZXMuaCAgICAgICAgICAgICAgICAgICAgfCAgIDIgKwpz cmMvaW5jbHVkZS9ub2Rlcy9tYWtlZnVuY3MuaCAgICAgICAgICAgICAgICAgICAgfCAgIDQgKy0K c3JjL2luY2x1ZGUvdXRpbHMvcmVsLmggICAgICAgICAgICAgICAgICAgICAgICAgIHwgICA0ICst CnNyYy9pbmNsdWRlL3V0aWxzL3JlbGNhY2hlLmggICAgICAgICAgICAgICAgICAgICB8ICAgNSAr LQpzcmMvdGVzdC9tb2R1bGVzL2R1bW15X2luZGV4X2FtL2R1bW15X2luZGV4X2FtLmMgfCAgIDEg KwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N0YXRzLm91dCAgICAgICAgICAgICAgfCAxMTEg KysrKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3RhdHMuc3FsICAg ICAgICAgICAgICAgICAgIHwgIDgyICsrKysrKysrKysrKysrKysrCjMwIGZpbGVzIGNoYW5nZWQs IDQ0OCBpbnNlcnRpb25zKCspLCA3NiBkZWxldGlvbnMoLSkKCg== --===============0356759719792412916==--