Amazon Redshift UNION ALL queries and VACUUM commands now run up to 10x faster
UNION ALL performance improvement: Business analytics often involves time-series data, which is data generated or aggregated daily, weekly, monthly or at other intervals. By storing time-series data in separate tables—one table for each time interval—and using a UNION ALL view over those tables, you can avoid potentially costly table updates. Amazon Redshift now runs UNION ALL queries up to 10 times faster if they involve joins, and up to 2 times faster if they don’t involve any joins. This performance improvement is automatic and requires no action on your part and is available in version 1.0.1057 and above. For more information about UNION ALL views and time-series tables, see Using Time-Series Tables in the Amazon Redshift Database Developer Guide.
VACUUM performance improvement: You can use the VACUUM command to clean up tables following a significant number of deletes or updates, and reclaim space and improve query performance. Amazon Redshift now runs VACUUM commands up to 10 times faster in version 1.0.1056 and above. This performance improvement is automatic and requires no action on your part. For more information about vacuuming, see Vacuuming Tables in the Amazon Redshift Database Developer Guide.
Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze all of your data using your existing business intelligence tools for less than a tenth the cost of traditional data warehousing solutions. You can get started with Amazon Redshift with our 2-month free trial from the AWS Management Console.