jrgemignani commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1722084293
@vladiksun I have another PR to enhance performance and indexes #1232 Also, I want to point out that, for whatever reason, your particular dataset and query does best **without** using a GIN index. I've checked our GIN index components and they are largely the same as PG's JSONB GIN components, so I'm thinking it's your dataset. I found that a BTREE index, **by itself**, works best for your dataset. **On my server**, the above PR cut the query time, for your queries above, in half without using any indexes. Adding the GIN index only gave a very minor improvement. The BTREE index (*_idx2) cut the query time in half again. -- 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
