At Silota, Amazon's Redshift is our data warehouse of choice. As we've onboarded our customers to this amazing piece of technology, we've picked up some tips and tricks along the way that we're sharing here:
Though Amazon's marketing suggests that Redshift is a fully managed data warehouse, in our experience it requires ongoing maintenance to maintain its performance characteristics:
- Vacuuming for Table Performance
- Monitoring Disk Space
- Monitoring Query Performance
- Column Compression
No spam, ever! Unsubscribe any time. Learn more about the product.