[
https://issues.apache.org/jira/browse/TRAFODION-2604?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15995328#comment-15995328
]
ASF GitHub Bot commented on TRAFODION-2604:
-------------------------------------------
Github user sandhyasun commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1081#discussion_r114610600
--- Diff: core/sql/executor/ex_sort.cpp ---
@@ -218,7 +304,8 @@ ExSortTcb::ExSortTcb(const ExSortTdb & sort_tdb,
sortStats_ = NULL;
childTcb_ = &child_tcb;
- CollHeap * space = glob->getSpace();
+ //Create heap to be used by sort.
+ sortHeap_ = new(getHeap()) NAHeap("Sort Heap", (NAHeap *)getHeap(),
204800);
--- End diff --
Isn't there a SORT_MAX_HEAP_SIZE_MB CQD ?
> sort operator merge phase memory pool improvement
> --------------------------------------------------
>
> Key: TRAFODION-2604
> URL: https://issues.apache.org/jira/browse/TRAFODION-2604
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Prashanth Vasudev
> Assignee: Prashanth Vasudev
> Fix For: 2.2-incubating
>
>
> Currently, executor sort goes through initial sort phase followed by merge
> phase in overflow situation. The memory pool used during sort phase is not
> efficiently reused for merge phase , causing sort merge to slow down in case
> of large merge. Sort merge happens only if sort overflows.
> Fix is to detect overflow situation and reuse the memory pool for merge phase.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
