Posted On: May 31, 2018
Amazon Redshift improved Short Query Acceleration (SQA) by automating the maximum time-out setting for short queries. On Nov 20th, 2017, we announced SQA which uses machine learning algorithms to predict the execution time of a query, and move short-running queries to an express queue for immediate processing. In the past, SQA needed user defined 'maximum run time' (between 1-20 seconds) to identify short queries. With this update, by setting the maximum short query run time to 'dynamic,' you can let Redshift automate this setting. In addition, SQA’s improved machine learning algorithm adapts the maximum run time to the changing workload, making it easier to use to minimize short query queuing time and increase throughput.
If you have SQA enabled already, select 'dynamic' in the 'Maximum run time for short queries' box to enable self-optimization. If you have not enabled SQA, you can enable dynamic SQA in three easy steps. Step one, edit your cluster parameter group by going to your Workload Management (WLM) settings in your console and click on 'Edit.' Step two, select the 'Enable short query acceleration' checkbox. Step three, 'Save' to enable dynamic SQA on your cluster. Alternatively, you can enable dynamic SQA using the AWS command line interface (CLI). To learn more, refer to our documentation.
Dynamic SQA is available with the latest build 1.0.2294 or Build 1.0.2369 in all AWS commercial regions. Please see the AWS Region Table for Amazon Redshift availability.