What users are saying about

Amazon RDS

Top Rated
68 Ratings

Amazon Redshift

88 Ratings

Amazon RDS

Top Rated
68 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101

Amazon Redshift

88 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101

Add comparison

Likelihood to Recommend

Amazon RDS

If you want to run a database in the cloud, RDS is definitely the way to go. I have not come across any scenarios that would indicate a better option.
Tim Weisbrod 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 is exceptionally good as it offers a wide variety of database engines.
  • Adding the security model to the RDS instance is amazing, you don't need to worry setting up SQL managers and servers for this purpose of handling security, it can be easily done using the security groups.
  • You can place the database instance in public/private subnets as needed, and it's easily accessible remotely which I feel is another big advantage.
No photo available
  • 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

  • Not fully configurable. It's a hosted service and you sometimes needs to work around RDS's rules, especially when it comes to administrating the service. But, it's similar to AWS's general architecture, so not a huge issue.
  • Aurora is the "better" service from a performance perspective. From a cost perspective, RDS is fine and will likely improve over time.
  • Cheaper to run your own database on your own instance, but I'm really stretching for a con here as it's relatively so inexpensive.
Michael E. Gruen profile photo
  • Can propose better optimization techniques based on the business use case.
  • Can provide option to set the upper bound on number of connections to cluster
  • Can improve on optimized writes/updates
Vinaybabu Raghunandha Naidu profile photo

Alternatives Considered

Honestly, there aren't a lot of great alternatives to RDS, and most likely the real alternative is just running an instance on your local box. While lots of other services (like Rackspace) offer hosted database solutions, RDS in my opinion, is the clear winner on price, availability, and failover support
Justin Schroeder profile photo
Some organizations use PostgreSQL as an OLAP store. PostgreSQL offers a modern SQL dialect, data types, and features that Redshift lacks. RDS is a great managed PostgreSQL product. However, PostgreSQL is a poor choice for a data warehouse. It's row-oriented storage requires careful schema and index design to ensure analytical queries perform adequately.
Gavin Hackeling profile photo

Return on Investment

  • ROI can't be judged with just one factor, if the hardware has to be brought and maintained, we might need an additional resource for maintaining the database (database admin).
  • Comparatively there are only positive ROIs to date, so we would highly recommend using Amazon RDS.
No photo available
  • Redshift has had a very positive impact on our business. It has been used to provide analytics on marketing campaigns to boost revenue.
  • Redshift is instrumental in our payment collection business processes. It powers everything from who gets called to who gets sent collection emails.
Seth Goldberg profile photo

Pricing Details

Amazon RDS

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

Amazon Redshift

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