Updated default settings for improved handling of high-load scenarios.
Details
| Detail name | Value |
|---|---|
| Changelog Number | 18797 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 8.24.0 |
| Resolution Date | 2023-12-20 |
Improvement
Under heavy load, system responsiveness and the throughput of system processes was improved by fine-tuning the operation of internal communication layers. As a result, if the system is under heavy load, system and service processes have a higher priority than SQL processes to ensure that the database remains available and responsive.
Changed behavior
Changed the default starting priority of user SQL queries to low (1) to ensure higher priority for essential service processes and improve response times under heavy system load.