Amazon Redshift now supports allocating extra compute for automatic optimizations

Amazon Redshift Release Notes

Amazon Redshift now supports allocating extra compute for automatic optimization features, known as autonomics. Database administrators can now allocate additional resources for their clusters to enable autonomics during high user activity, eliminating the need to manually schedule optimizations such as Automatic Table Optimization (ATO), Automatic Table Sorting (ATS), Auto Vacuum, and Auto Analyze.

This enhancement allows for automatic leverage of extra compute resources without impacting user workloads and includes a cost control feature for provisioned clusters. The new SYS_AUTOMATIC_OPTIMIZATION system table enhances observability by providing detailed information on autonomics operations.

What to do

• Allocate extra compute resources for your clusters to enable autonomics.
• Use the SYS_AUTOMATIC_OPTIMIZATION system table for detailed information on autonomics operations.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.