08-09-2020 11:06 AM
While I was browsing our Marketing Ressources today I 're-found' a whitepaper that we created earlier this year.
Benchmarking Exasol against an Amazon Redshift installation.
Find the whitepaper here: https://www.exasol.com/en/resource/benchmark-exasol-and-amazon-redshift/
What are your experiences with the Performance of Cloud Warehouses, did you directly compare? We would love to hear from you
exa-Chris
17-09-2020 12:04 PM
Hi Chris,
I had the possibility to work with Redshift for a while and I could compare it with Exasol. It was a mixed bag.
From an SQL prospective working with Redshift is like working with a 15 years old PostgreSQL:
If you are a DBA you would love Redshift, spinning up a cluster takes very little time (and you can script it with CloudFormation). Backups are done automatically and can be restored quickly, you can also pick specific tables from a backup. Scaling is also quite easy and is managed by AWS. There is a monitoring dashboard to see what is happening and even a Query Advisor. Compared to Exasol Redshift here has the upper hand.
Not sure if you notice but, for me, the interesting features are the ones related to cloud functionalities where they can charge you more (backups or scaling) or keep you in the AWS ecosystem. In fact it is no coincidence that the user management in Redshift is bad, you will be much better off if you use AWS IAM Role instead of groups or the introduction of Redshift Spectrum (Impala), a convenient way to run queries on top of big data formats.
Final words. I would not recommend people to use Redshift if they are not already heavily involved with the AWS ecosystem or have real use cases for a growing and shrinking database (even in that case a product like Snowflake is much more developer friendly than Redshift offering the same pros for the DBAs - there the problems are the costs). But, because Redshift is an AWS product, it is very easy for a medium/small company to start the first cluster and start playing with it (then they will hardly move from there).
08-09-2020 02:51 PM
Nice but registered for the download in the morning and still did not receive a download link 😉
08-09-2020 04:33 PM
Hi Charlie, that is odd, I tested it and had an e-Mail within seconds. May be spam?
Rgds
exa-Chris
Then it's time to become part of a unique family! Discover helpful tips and support other Community members with your knowledge.
Sign In