Amazon RDS vs Amazon Redshift

• 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

Read full review

• 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.

Read full review

• 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).

Read full review

• 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...

Read full review

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

Read full review

• 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.

Read full review