Amazon Redshift now supports allocating extra compute for automatic optimization features, known as autonomics. Database administrators managing Amazon Redshift workloads can now allocate additional resources for their clusters to enable autonomics even during periods of 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 extends Amazon Redshift’s autonomics capabilities to automatically leverage extra compute resources, to run reliably without impacting user workloads. It also includes a cost control feature for provisioned clusters, allowing database administrators to limit the amount of resources available to autonomics. Additionally, the new SYS_AUTOMATIC_OPTIMIZATION system table enhances observability by providing detailed information on autonomics operations for both provisioned clusters and serverless workgroups.
This feature is available in all AWS Regions where Amazon Redshift is supported. To learn more, see Allocating extra compute resources for automatic database optimization.
Categories: marketing:marchitecture/analytics,general:products/amazon-redshift
Source: Amazon Web Services
Latest Posts
- AWS HealthOmics introduces a Kiro Power and Kiro IDE extension for bioinformatics workflow development

- (Updated) Microsoft Viva: Copilot Dashboard – Broader access to M365 Copilot Chat insights [MC1191915]
![(Updated) Microsoft Viva: Copilot Dashboard - Broader access to M365 Copilot Chat insights [MC1191915] 3 pexels padrinan 1061136](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- (Updated) Introducing New Paid Extended Service Term (EST) [MC1216259]
![(Updated) Introducing New Paid Extended Service Term (EST) [MC1216259] 4 pexels jeshoots com 147458 451590](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- Introducing Surveys Agent and Copilot Chat in Microsoft Forms [MC1229954]
![Introducing Surveys Agent and Copilot Chat in Microsoft Forms [MC1229954] 5 pexels olly 3762371](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)


![(Updated) Microsoft Viva: Copilot Dashboard - Broader access to M365 Copilot Chat insights [MC1191915] 3 pexels padrinan 1061136](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-padrinan-1061136-150x150.webp)
![(Updated) Introducing New Paid Extended Service Term (EST) [MC1216259] 4 pexels jeshoots com 147458 451590](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-jeshoots-com-147458-451590-150x150.webp)
![Introducing Surveys Agent and Copilot Chat in Microsoft Forms [MC1229954] 5 pexels olly 3762371](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-olly-3762371-150x150.webp)
![Updated Filter Pane in SharePoint Document Libraries and Lists [MC1229956] 7 Updated Filter Pane in SharePoint Document Libraries and Lists [MC1229956]](https://mwpro.co.uk/wp-content/uploads/2025/06/pexels-steve-12891176-96x96.webp)