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