5 Replies Latest reply on Feb 13, 2017 10:39 AM by Steven Hawkins

    Aggregation over big table consuming memory

    Mark Tawk Novice

      I'm using Teiid 9.0.0 with MSSQL translator

      I have a table containing around 8 million records.

      I'm running a query with sum aggregation and grouped by 5 fields.

      While executing the query, Teiid is consuming almost all the JVM memory (7 out of 8GB)

      When the query finishes execution, the memory do not drop down to its initial state before the query execution. Which is affecting the application performance.

      Is there a way to release the memory used by Teiid for the cases simular to this one?