[teiid-issues] [JBoss JIRA] (TEIID-5421) Regression with enhanced sort join performance
Steven Hawkins (JIRA)
issues at jboss.org
Tue Jul 17 14:05:00 EDT 2018
[ https://issues.jboss.org/browse/TEIID-5421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13607100#comment-13607100 ]
Steven Hawkins commented on TEIID-5421:
---------------------------------------
I'm seeing two related issues. The first is that TEIID-5017 allows for some joins to be processed sub-optimally - the avoidance of buffering is causing more work by searching an index that is too large. A follow on issue that is probably not directly related is that running a reproducer for the case described by TEIID-5417 repeatedly shows that as more of the materialization is pushed out of the heap memory space performance significantly drops.
> Regression with enhanced sort join performance
> ----------------------------------------------
>
> Key: TEIID-5421
> URL: https://issues.jboss.org/browse/TEIID-5421
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 9.3
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 11.1
>
>
> A regression was introduced in 9.3 with enhanced sort join performance over moderately large row sets.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list