Don’t Use Redshift as an OLTP Database December 06, 2021 by Donal Tobin 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...
Redshift’s Automatic WLM with Query Priority: A First Look at Performance December 06, 2021 by Abe Dearmer 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...
Use Routine Vacuuming to Reclaim Unused Space December 06, 2021 by Abe Dearmer 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...
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...
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...
Using Opsworks and HAProxy for Routing December 06, 2021 by Mark Smallcombe At Integrate.io, with much of our infrastructure on AWS, we try to make use of the various AWS services available to us. One of these is Amazon Opsworks.
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...
Handling Column Characters in MySQL vs Amazon Redshift December 06, 2021 by Abe Dearmer When you build an application that works with different kinds of databases, you have to be aware of and deal with many subtle differences between databases.
AWS Announces DS2 Amazon Redshift with 50% Better Performance at the Same Price December 06, 2021 by Mark Smallcombe AWS announced yesterday that they are rolling out a newer generation DS2 Amazon Redshift that has 50% better performance compared to what they previously offered, at the exact same price.