News for hackers. Stuff that matters.

pingles

Re:BigQuery vs. Redshift vs. Athena simple benchmark on Monday June 19, 2017 @11:12AM (#14587542)
Difficult to draw much of/any conclusion without the Redshift schema.

From direct experience of working on a moderate Redshift cluster performance is horrific once you start querying tables outside of their designed with sort and distribution keys. This is fine when you have defined use but when you're doing ad-hoc analysis or want to query across lots of dimensions we couldn't make Redshift work.

In contrast, I've seen BigQuery perform much more consistently in the face of large datasets with varying workloads.

I built this fun app to help demonstrate the application and integration of Multi-armed Bandit strategies for product optimisation. It uses bandits to order the 3 videos, and select the thumbnails that are used. The slides for the presentation are at the bottom of the web page.