Konstantin Orlov created IGNITE-23957:
-----------------------------------------
Summary: Sql. Fix excessive memory consumption during query
processing
Key: IGNITE-23957
URL: https://issues.apache.org/jira/browse/IGNITE-23957
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Konstantin Orlov
Assignee: Konstantin Orlov
Attachments: Screenshot 2024-12-11 at 15.50.09.png
When running TPC-DS query 64 added in IGNITE-23944 on single node cluster, it
take ~5 minutes of execution time to exhaust 9GB of heap (see !Screenshot
2024-12-11 at 15.50.09.png! ).
Analysis of heap dump shows that heap is mostly occupied by small (up to 1.5KB)
byte arrays being referred by HashJoinNode. One of the possible candidates is
key objects of hashStore. Another candidate is table row after normalization in
{{FieldDeserializingProjectedTuple}} (the latter preallocates 1024 KB, while
the most biggest row barely occupies a couple of hundreds bytes).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
