Amazon Redshift Workload Management Powered by Machine Learning

Amazon Web Services (AWS) claims its cloud data warehouse, Amazon Redshift, powers mission-critical analytical workloads "for Fortune 500 companies, startups, and everything in between." Now machine learning is powering the automatic management of those workloads.

The recently announced Automatic workload management (WLM) for Redshift can dynamically manage memory and query concurrency to boost query throughput.

Users can enable concurrency scaling for a query queue to a virtually unlimited number of concurrent queries, AWS said, and can also prioritize important queries.

"By setting query priorities, you can now ensure that higher priority workloads get preferential treatment in Redshift including more resources during busy times for consistent query performance," AWS said last week. "Automatic WLM uses intelligent algorithms to make sure that lower priority queries don't stall, but continue to make progress. For more information, see Query Priority."

The cloud giant is advising all customers who manually manage their workloads to switch to Automatic WLM. Guidance on doing that is available in "Implementing Automatic WLM."

About the Author

David Ramel is an editor and writer for Converge360.


Subscribe on YouTube