pgsql: Fix handling of multi-column BRIN indexes

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема pgsql: Fix handling of multi-column BRIN indexes
Дата
Msg-id E1pTXsa-001pdf-BK@gemulon.postgresql.org
обсуждение исходный текст
Список 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
------
REL_14_STABLE

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

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


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: pgsql: Fix handling of multi-column BRIN indexes
Следующее
От: Michael Paquier
Дата:
Сообщение: pgsql: Refactor tests of pg_stat_statements for planning, utility and l