dehowef commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1700137474
@vladiksun I have been looking into how B-tree indexing works and indexing in general, and I came across [documentation](https://www.postgresql.org/docs/15/xindex.html#XINDEX-BTREE-STRAT-TABLE) that shows that B-tree indexes rely on operators (=,<,>,<=,>=) to work. Since the IN operator filter as shown by EXPLAIN ANALYZE is a function call, I feel that this might contribute to why the index is not being used. The agtype operator class is defined in the age--x.x.x.sql file, maybe looking there might offer further insight. Just thought I'd share what I've been looking into with you. Hope this might be helpful. -- 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
