[
https://issues.apache.org/jira/browse/IGNITE-23957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-23957:
--------------------------------------
Fix Version/s: 3.0
> 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
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0
>
> Attachments: Screenshot 2024-12-11 at 15.50.09.png, Screenshot
> 2024-12-12 at 12.18.29.png
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
