BIG DATA

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...

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...

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...

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...

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...

In today’s electronically interconnected world, the amount of data generated by business operations can have an inundating effect on enterprise systems.

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...

Summary In this post, we’re talking to Melisa Kleen, the Head of Business Intelligence and Data Science at Blinkist. Blinkist distills non-fiction books into 15-minute summaries of key insights, aka...

Table of Contents Measuring & Improving Data SLAs for Query Latency Introducing the Cluster Health Dashboard Measure Data SLAs for any App or Users Cluster Recommendations Find & Fix Slow...