[
https://issues.jboss.org/browse/TEIID-3583?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3583:
---------------------------------------
what is considered a large intermediate results
scrolling cursors or sorting over millions of rows
how much to increase max-processing-kb based on how large
how much to decrease max-reserve-kb base on how large
My belief it that we shouldn't be too specific here as this is reactive / based upon
the workload and already an uncommon case - large intermediate results and ideally a low
query volume. Given the amount to increase / decrease is highly dependent upon the query
/ workload specifics it seems more straight-forward to describe the concept. It would
probably make just as much sense to just reference this scenario or auto-tune for example
we perform more than a 2-pass sort due to memory being held by other processing - rather
than expecting anyone to make the determination on their own.
Need documentation on possible property settings to use
-------------------------------------------------------
Key: TEIID-3583
URL:
https://issues.jboss.org/browse/TEIID-3583
Project: Teiid
Issue Type: Enhancement
Reporter: Van Halbert
Assignee: Steven Hawkins
In the Administration and Configuration Guide there is some indication on how to perform
active heap throttling.
"Memory Management Considerations " there is a reference to parameters like:
max-processing-kb and the max-reserve-kb.
Anyway there is no indication of the indicative values to associate to those parameters
to obtain a certain result.
It would be good to get some examples to understand the cause and effect of the changes (
max-reserve-kb and related settings ).
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)