My Amazon Redshift query performance is suboptimal. What steps can I take to improve query performance?
Redshift query performance is related to several factors, including:
- Table design
- Query planning and processing optimization.
- Workload management and implementation of query queues.
- Table maintenance via the VACUUM command.
- Implementation of best practices for loading data.
To improve Redshift query performance, follow these steps:
- For table design, see Amazon Redshift Best Practices for Designing Tables and Analyzing Tables and complete recommended actions as appropriate.
- To optimize query processing, see Amazon Redshift Best Practices for Designing Queries and Tuning Query Performance and subtopics.
- To minimize query bottlenecks, see Implementing Workload Management and subtopics.
- To reclaim storage space and maintain consistent query performance, complete the steps in Vacuuming Tables and subtopics on a regular basis. VACUUM should be run when you expect minimal activity on the cluster.
- To minimize the impact that loading data can have on query performance, follow recommendations in Amazon Redshift Best Practices for Loading Data. Because loading data uses a workload management query queue, data loading performance can affect Redshift query performance. Optimal data loading performance minimizes use of the query queue and its impact on Redshift query performance. For information about how to load data and troubleshoot data loading, see Loading Data. For related troubleshooting information, see Load Fails, Load Takes Too Long, and Load Data Is Incorrect.
Slow, query, performance, Amazon Redshift, VACUUM, analyze, cluster, load data
Did this page help you? Yes | No
Back to the AWS Support Knowledge Center
Need help? Visit the AWS Support Center.