Posted On: Feb 1, 2021
Improved cold query performance is now available in South America (São Paulo), Canada (Central) and Asia Pacific (Mumbai) regions.
With this improvement, Amazon Redshift can process queries up to 2x faster when they need to be compiled. This improvement gives you better query performance when you create a new Redshift cluster, onboard a new workload on an existing cluster, or after a software update of an existing cluster. These query performance improvements are available at no additional cost, and no action is needed to enable it on your clusters.
With this update, query compilations are scaled to a serverless compilation service beyond the compute resources of the leader node of your cluster. We are also releasing an unlimited cache to store compiled objects to increase cache hits, from 99.60% to 99.95%, when your mission-critical queries are submitted to Amazon Redshift.
When queries are sent to Amazon Redshift, the query execution engine compiles the query into machine code and distributes it to the cluster nodes. The compiled code executes faster because it eliminates the overhead of using an interpreter. For a new cluster with no code cache or after an existing cluster is upgraded with the latest release, code cache is flushed, and queries must undergo query compilation. As a result, the latency of a query may vary, which may not meet the requirements of some workloads. With this update, unlimited cache minimizes the need to compile code, and when compilation is needed, a scalable compilation farm compiles it in parallel to speed up your workloads. The magnitude of workload speed up depends on its complexity and concurrency. To learn more about code compilation, see Query Processing under the Database developer guide.
Cold query performance improvement is now available in US East (Ohio, N. Virginia), US West (N. California, Oregon), Canada (Central), Asia Pacific (Seoul, Singapore, Sydney, Tokyo, Mumbai), EU (Frankfurt, Ireland, London) and South America (São Paulo) regions.