Re: Bug: When user-defined AM is used, the index path cannot be selected correctly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug: When user-defined AM is used, the index path cannot be selected correctly
Дата
Msg-id 1606486.1660701833@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Bug: When user-defined AM is used, the index path cannot be selected correctly  (Quan Zongliang <quanzongliang@yeah.net>)
Ответы Re: Bug: When user-defined AM is used, the index path cannot be selected correctly  (Quan Zongliang <quanzongliang@yeah.net>)
Список pgsql-hackers
Quan Zongliang <quanzongliang@yeah.net> writes:
> 1. When using extended PGroonga
> ...
> 3. Neither ID = 'f' nor id= 't' can use the index correctly.

This works fine for btree indexes.  I think the actual problem
is that IsBooleanOpfamily only accepts the btree and hash
opclasses, and that's what needs to be improved.  Your proposed
patch fails to do that, which makes it just a crude hack that
solves some aspects of the issue (and probably breaks other
things).

It might work to change IsBooleanOpfamily so that it checks to
see whether BooleanEqualOperator is a member of the opclass.
That's basically what we need to know before we dare generate
substitute index clauses.  It's kind of an expensive test
though, and the existing coding assumes that IsBooleanOpfamily
is cheap ...

            regards, tom lane



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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Add proper planner support for ORDER BY / DISTINCT aggregates
Следующее
От: John Naylor
Дата:
Сообщение: Re: build remaining Flex files standalone