[
https://issues.apache.org/jira/browse/TRAFODION-2738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16168696#comment-16168696
]
ASF GitHub Bot commented on TRAFODION-2738:
-------------------------------------------
Github user selvaganesang commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1232#discussion_r139270056
--- Diff: core/sql/sqlcomp/nadefaults.cpp ---
@@ -1336,6 +1336,8 @@ SDDkwd__(EXE_DIAGNOSTIC_EVENTS, "OFF"),
SDDui___(EXE_MEMORY_FOR_PROBE_CACHE_IN_MB, "100"),
+ SDDui___(EXE_MEMORY_FOR_UNPACK_ROWS_IN_MB, "100"),
--- End diff --
Because there is an easy way to change the memory size, we can determine
the optimal default at a later date. I believe the current default of 100 MB
should be good enough for most of the use cases.
> Rowset buffer size during insert/upsert should be limited
> ---------------------------------------------------------
>
> Key: TRAFODION-2738
> URL: https://issues.apache.org/jira/browse/TRAFODION-2738
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Selvaganesan Govindarajan
>
> Currently, the rowset size for upsert and insert can be given in a such way
> that it would be allocate unlimited buffer size to move the data from client
> to Trafodion SQL engine. This can cause memory corruption and unexpected
> behavior. Hence, we need a way to limit the number of rows in the rowset.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
