View a markdown version of this page

Operations - Data Warehousing on AWS

This whitepaper is for historical reference only. Some content might be outdated and some links might not be available.

Operations

As a managed service, Amazon Redshift completely automates many operational tasks, including:

  • Cluster Performance — Amazon Redshift performs Auto ANALYZE to maintain accurate table statistics. It also performs Auto VACUUM to ensure that the database storage is efficient and deleted data blocks are reclaimed.

  • Cost Optimization — Amazon Redshift enables you to pause and resume the clusters that need to be available only at a specific time, enabling you to suspend on-demand billing while the cluster is not being used. Pause and resume can also be automated using a schedule you define to match your operational needs. Cost controls can be defined on Amazon Redshift clusters to monitor and control your usage and associated cost for Amazon Redshift Spectrum and Concurrency Scaling features.