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
- Amazon Redshift now supports allocating extra compute for automatic optimizations
- Amazon Neptune Analytics is now available in 7 additional regions
- (Updated) Microsoft Defender for Office 365: Enable users to report suspicious Teams messages in Plan 1 [MC1219788]
- (Updated) Realtime voice is now available in M365 Copilot Chat and M365 Copilot [MC1085684]
