Big Data Customer Success Story: Fuze improves query performance by 10x Fuze is a cloud-based communications and collaboration platform provider. Fuze drives workplace transformation for its customers with data from 2.5 million meetings, 20 million calls, and 33 million messages each... Abe Dearmer Read More
Big Data Don’t Use Redshift as an OLTP Database It is common to connect an application framework like Django to Amazon Redshift. This is useful when using Redshift data in your application, i.e. in an OLTP scenario. Since Amazon... Donal Tobin Read More
Big Data Redshift’s Automatic WLM with Query Priority: A First Look at Performance Introduction The AWS team recently released a new feature of their Automatic WLM that we’re really excited about: Query Priorities. This feature aims to address the main limitation of Auto... Abe Dearmer Read More
Big Data Use Routine Vacuuming to Reclaim Unused Space Amazon Redshift databases require periodic maintenance known as vacuuming. Amazon Redshift is based on PostgreSQL, but unlike PostgreSQL, Redshift doesn’t offer autovacuum. So when a row is deleted from a... Abe Dearmer Read More
Big Data Use Column Encoding 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... Donal Tobin Read More
Big Data Use Amazon Redshift Spectrum for infrequently used data 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... Abe Dearmer Read More
Big Data Query Optimization: How to efficiently compare two rows in a SQL query 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... Donal Tobin Read More
Big Data How Wish Built Their Data Pipeline with Amazon Redshift 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... Abe Dearmer Read More
Big Data Benchmarking the Performance of Amazon Redshift ra3.16xlarge versus ds2.8xlarge instances 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... Abe Dearmer Read More