What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
92 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
124 Ratings

Amazon RDS

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
92 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Amazon Redshift

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
124 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101

Likelihood to Recommend

Amazon RDS

RDS is well suited if:
  1. You have a modest budget. If I were completely bootstrapped and not married to AWS, I might look elsewhere.
  2. You need a speedy, secure transactional, do-it-all database.
  3. You need the ability to scale seamlessly.
Kyle Reichelt profile photo

Amazon Redshift

Redshift is ideal for small teams. It is fully managed. CloudWatch metrics are provided out-of-the-box, and it integrates well with other AWS products, such as DMS. The Redshift console is among the better AWS consoles. Redshift offers adequate performance. Spectrum offers a convenient way to access our data lake, but we have encountered issues with recent versions.
Gavin Hackeling profile photo

Pros

Amazon RDS

  • Multiple availability zones for high assurance of uptime
  • Both hosted and local management/reporting utilities
  • Integration with CloudWatch and CloudFormation for automated creation and real-time performance metrics
Eric Mann profile photo

Amazon Redshift

  • Redshift is fully managed. Small teams do not have the resources to maintain a cluster. CloudWatch metrics are provided out-of-the-box, and it is easy to configure alarms.
  • Redshift's console allows you to easily inspect and manage queries, and manage the performance of the cluster.
  • Redshift is ubiquitous; many products (e.g., ETL services) integrate with it out-of-the-box.
  • Writing .csvs to S3 and querying them through Redshift Spectrum is convenient.
Gavin Hackeling profile photo

Cons

Amazon RDS

  • Postgres, in particular, is configured in such a way as to prevent access to the `postgres` user. Considering things like database extensions are installed under this user, if extensions ever need to be removed/modified, you have to rebuild and migrate your entire database!
  • Cross-system database migrations are somewhat slow and, in many cases, require a great deal of manual work to ensure data type information (i.e. UUIDs or Integers) is properly set-post migration (otherwise many types are re-cast to strings).
Eric Mann profile photo

Amazon Redshift

  • Lack of enforced constraints (except NOT NULL column constraints). You have to be very careful in your testing to make sure that you aren't duplicating rows.
  • No stored procedure support. Everything must be accomplished through ETL
  • Write operations are very slow and complex.Native SQL row level INSERT and UPDATE statements take an extremely long time to execute. In order to get around this for external data that needs to be loaded, you have to bulk load the data from a flat file to a stage table, then upsert the data from the stage table to your destination table. For data already present in the database, ELT is the only viable way of transforming the data.
  • No good native data modelling tools.
  • Random nondescript errors happen occasionally. The error messages are not decipherable and forums will have no clues as to what happened. It is just a fact of life.
  • No trigger support.
  • OLTP style queries are painfully slow. Don't even think about using Redshift for OLTP...
Seth Goldberg profile photo

Usability

Amazon RDS

Amazon RDS 8.3
Based on 3 answers
It's good. You just have to know its limitations and design around them. For example, there is no operating system level access to files for things like backup/restore. You can use workarounds with S3 storage. You can't use read replicas with MS SQL databases.
No photo available

Amazon Redshift

Amazon Redshift 8.6
Based on 8 answers
Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.
Brendan McKenna profile photo

Support

Amazon RDS

Amazon RDS 8.8
Based on 5 answers
Amazon support is always top-notch. You get immediate feedback on whatever you are working through and given several resources on how to resolve them. Additionally, they are able to do some things for us, meaning we don't need to have a database administrator around at all time to implement their suggestions.
No photo available

Amazon Redshift

No score
No answers yet
No answers on this topic

Alternatives Considered

Amazon RDS

Very similar. In our isolated usage, we saw mild performance advantage in GCP, but AWS RDS is cheaper and has more built-in.
No photo available

Amazon Redshift

No comment on this.
Vibhakar Prasad profile photo

Return on Investment

Amazon RDS

  • Amazon RDS helps our organization run lean.
  • We are able to scale as needed.
  • Our data is safe and secure.
Bob Smith profile photo

Amazon Redshift

  • Very positive for what it has done, providing a way to aggregate data sources.
  • It allows marketing to pull statistics across the consumer base that would not have been otherwise possible.
  • It allows actual analytics across the company, in an easily accessible manner.
No photo available

Pricing Details

Amazon RDS

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Amazon Redshift

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison