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.