jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3192874888
@serdarmicrosoft After doing some research, I'm not sure we can improve this particular query any further with indexes. As it is using hash joins - > In PostgreSQL, a hash join typically ignores indexes because it is designed to use a different strategy for joining tables. Here's why this happens and how it works: > > Why Hash Joins Ignore Indexes > Hash Table Construction: > > A hash join creates a hash table in memory for the smaller table (or the inner table in the join). This hash table maps the join key to the corresponding rows. > The larger table (outer table) is then scanned, and its rows are matched against the hash table. I think the only target left would be the aggregation functions. -- 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
