pgsql: Fix handling of multi-column BRIN indexes - Mailing list pgsql-committers

From Tomas Vondra
Subject pgsql: Fix handling of multi-column BRIN indexes
Date
Msg-id E1pTXrZ-001pcD-Dq@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix handling of multi-column BRIN indexes

When evaluating clauses on multiple scan keys of a multi-column BRIN
index, we can stop processing as soon as we find a scan key eliminating
the range, and the range should not be added to tbe bitmap.

That's how it worked before 14, but since a681e3c107a the code treated
the range as matching if it matched at least the last scan key.

Backpatch to 14, where this code was introduced.

Backpatch-through: 14
Discussion: https://postgr.es/m/ebc18613-125e-60df-7520-fcbe0f9274fc%40enterprisedb.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/e72910f8080185b6ade9ef7caa5c891dba3cb51c

Modified Files
--------------
src/backend/access/brin/brin.c | 7 +++++++
1 file changed, 7 insertions(+)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Print the correct aliases for DML target tables in ruleutils.
Next
From: Tomas Vondra
Date:
Subject: pgsql: Fix handling of multi-column BRIN indexes