[teiid-issues] [JBoss JIRA] (TEIID-5421) Regression with enhanced sort join performance

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13607100#comment-13607100 ] 

Steven Hawkins edited comment on TEIID-5421 at 7/17/18 2:04 PM:
----------------------------------------------------------------

I'm seeing two 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.


was (Author: shawkins):
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)