[jira] [Resolved] (TRAFODION-3192) UNION ALL up and down queue size default value too small, or not dynamically adjusted

["Sandhya Sundaresan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sandhya Sundaresan resolved TRAFODION-3192.
-------------------------------------------
    Resolution: Fixed

> UNION ALL up and down queue size default value too small, or not dynamically adjusted
> -------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-3192
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3192
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>    Affects Versions: any
>            Reporter: Sandhya Sundaresan
>            Assignee: Sandhya Sundaresan
>            Priority: Major
>             Fix For: 2.4
>
>
> The union up queue size is hardcoded in nadefaults.cpp as a start value as 16 which
> is very low if large number of rows are being returned. Scan operator has it set to 2048.
> Some operators further adjust this up size from the original value based on estimate of
> the number of rows being returned. We can do that for union codegen method and
> also change the original up queue size to 2048.
>  
> Noticed that Transpose, Sequence also have the same issue and dynamic queue resizing is missing. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)