To enhance automated database maintenance, Amazon Redshift can assign extra compute capacity to autonomic processes like Automatic Table Optimization, Sorting, Vacuum, and Analyze. This ensures these optimization tasks proceed efficiently without impeding active user queries even at high cluster utilization.
A cost control mechanism lets administrators set resource limits for autonomics to manage expenses, and a new system table provides visibility into ongoing optimization activities. This feature, widely available across AWS regions, facilitates hands-off performance tuning aligned with cluster workload demands.
Source & further reading
Amazon Redshift now supports allocating extra compute for automatic optimizations ↗Source published 2026-02-09. This report was prepared with AI assistance from the linked primary-source material. Claims and limitations should be checked against the original announcement or research.