vladiksun commented on issue #1235:
URL: https://github.com/apache/age/issues/1235#issuecomment-1772247878

   @jrgemignani @rafsun42 @dehowef Thank you for looking into this.
   We will try to check the btree index feature for IN operator as well as new 
option 
   ```
   SET age.enable_containment = OFF; -- default is ON
   ```
   Though I don't know if it makes sense to use btree indexes for MATCH instead 
of GIN indexes because MATCH can only work with object patterns (@> operator). 
I believe for that we should create several btree indexes for each field of an 
object. But in that case I don't know how the object pattern is treated under 
the hood.
   
   @jrgemignani I agree that in some scenarios index traversal could be more 
expensive than full scan and we should always check the plan first.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to