Use Column Encoding December 06, 2021 by Donal Tobin Adding compression to large, uncompressed columns will have a big impact on cluster performance. Compression accomplishes two things: Reduce storage utilization . Because file compression reduces the size footprint of...
Use Amazon Redshift Spectrum for infrequently used data December 06, 2021 by Abe Dearmer Amazon Redshift launched with disruptive pricing. To compare the cost, we’re looking at the price for storing 1TB of data for one year ($ / TB / Year). With a...
Query Optimization: How to efficiently compare two rows in a SQL query December 06, 2021 by Donal Tobin Table of Contents The Simplified Problem A Better Solution A Real-World Example Lessons Learned Query optimization that dramatically reduces runtime for queries which use window functions . The Simplified Problem...
How Wish Built Their Data Pipeline with Amazon Redshift December 06, 2021 by Abe Dearmer Wish Wish is a mobile commerce platform. It provides online services that include media sharing and communication tools, personalized and other content, as well as e-commerce. During the last few...
Benchmarking the Performance of Amazon Redshift ra3.16xlarge versus ds2.8xlarge instances December 06, 2021 by Abe Dearmer A first look at the new RA3 Amazon Redshift node type Table of Contents Introduction Specs Copy Performance I/O Performance Real-world performance Separation of Storage and Compute Conclusion Introduction Today...
5 Signs You Need Business Intelligence December 06, 2021 by Abe Dearmer In today’s electronically interconnected world, the amount of data generated by business operations can have an inundating effect on enterprise systems.
How to Fix Disk-based Queries and High Disk Usage in Amazon Redshift December 06, 2021 by Abe Dearmer Table of Contents The WLM and Disk-Based queries How to Prevent Queries From Going Disk-based Intermediate Storage Ways to Limit the Amount of Intermediate Storage Used. Impact to Cluster Storage...
Integrate.io Query Groups – Intelligent Query Classification in Amazon Redshift December 06, 2021 by Mark Smallcombe Table of Contents What are Query Groups in Amazon Redshift and Integrate.io? How Do Query Groups Work in Amazon Redshift and Integrate.io? Example: Find the Queries Causing a Query Spike...
The rise of data products and what that means for Integrate.io December 06, 2021 by Donal Tobin Two years ago we launched a product to manage performance for data warehouses. Today we launched a new product , a new website , and a new mission to help...