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

From Tom Lane
Subject Re: Bug: When user-defined AM is used, the index path cannot be selected correctly
Date
Msg-id 1606486.1660701833@sss.pgh.pa.us
Whole thread Raw
In response to Bug: When user-defined AM is used, the index path cannot be selected correctly  (Quan Zongliang <quanzongliang@yeah.net>)
Responses Re: Bug: When user-defined AM is used, the index path cannot be selected correctly
List 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 by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Add proper planner support for ORDER BY / DISTINCT aggregates
Next
From: John Naylor
Date:
Subject: Re: build remaining Flex files standalone