Amazon RDS for PostgreSQL vs Amazon Redshift

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL

404
182
+ 1
37
Amazon Redshift
Amazon Redshift

620
309
+ 1
86
Add tool

Amazon RDS for PostgreSQL vs Amazon Redshift: What are the differences?

What is Amazon RDS for PostgreSQL? * Set up, operate, and scale PostgreSQL deployments in the cloud*. Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and back-ups for disaster recovery. With just a few clicks in the AWS Management Console, you can deploy a PostgreSQL database with automatically configured database parameters for optimal performance. Amazon RDS for PostgreSQL database instances can be provisioned with either standard storage or Provisioned IOPS storage. Once provisioned, you can scale from 10GB to 3TB of storage and from 1,000 IOPS to 30,000 IOPS.

What is Amazon Redshift? Fast, fully managed, petabyte-scale data warehouse service. Redshift makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. It is optimized for datasets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.

Amazon RDS for PostgreSQL can be classified as a tool in the "PostgreSQL as a Service" category, while Amazon Redshift is grouped under "Big Data as a Service".

Some of the features offered by Amazon RDS for PostgreSQL are:

  • Monitoring and Metrics –Amazon RDS provides Amazon CloudWatch metrics for you DB Instance deployments at no additional charge.
  • DB Event Notifications –Amazon RDS provides Amazon SNS notifications via email or SMS for your DB Instance deployments.
  • Automatic Software Patching – Amazon RDS will make sure that the PostgreSQL software powering your deployment stays up-to-date with the latest patches.

On the other hand, Amazon Redshift provides the following key features:

  • Optimized for Data Warehousing- It uses columnar storage, data compression, and zone maps to reduce the amount of IO needed to perform queries. Redshift has a massively parallel processing (MPP) architecture, parallelizing and distributing SQL operations to take advantage of all available resources.
  • Scalable- With a few clicks of the AWS Management Console or a simple API call, you can easily scale the number of nodes in your data warehouse up or down as your performance or capacity needs change.
  • No Up-Front Costs- You pay only for the resources you provision. You can choose On-Demand pricing with no up-front costs or long-term commitments, or obtain significantly discounted rates with Reserved Instance pricing.

"Easy setup, backup, monitoring" is the primary reason why developers consider Amazon RDS for PostgreSQL over the competitors, whereas "Data Warehousing" was stated as the key factor in picking Amazon Redshift.

Lyft, Coursera, and 9GAG are some of the popular companies that use Amazon Redshift, whereas Amazon RDS for PostgreSQL is used by Netflix, Instacart, and Product Hunt. Amazon Redshift has a broader approval, being mentioned in 269 company stacks & 67 developers stacks; compared to Amazon RDS for PostgreSQL, which is listed in 167 company stacks and 29 developer stacks.

No Stats
- No public GitHub repository available -
- No public GitHub repository available -

What is Amazon RDS for PostgreSQL?

Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and back-ups for disaster recovery. With just a few clicks in the AWS Management Console, you can deploy a PostgreSQL database with automatically configured database parameters for optimal performance. Amazon RDS for PostgreSQL database instances can be provisioned with either standard storage or Provisioned IOPS storage. Once provisioned, you can scale from 10GB to 3TB of storage and from 1,000 IOPS to 30,000 IOPS.

What is Amazon Redshift?

Redshift makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. It is optimized for datasets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Amazon RDS for PostgreSQL?
Why do developers choose Amazon Redshift?

Sign up to add, upvote and see more prosMake informed product decisions

    Be the first to leave a con
      Be the first to leave a con
      What companies use Amazon RDS for PostgreSQL?
      What companies use Amazon Redshift?

      Sign up to get full access to all the companiesMake informed product decisions

      What tools integrate with Amazon RDS for PostgreSQL?
      What tools integrate with Amazon Redshift?

      Sign up to get full access to all the tool integrationsMake informed product decisions

      What are some alternatives to Amazon RDS for PostgreSQL and Amazon Redshift?
      Heroku Postgres
      Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.
      Google Cloud SQL for PostgreSQL
      Cloud SQL offers high performance, scalability, and convenience. Hosted on Google Cloud Platform, Cloud SQL provides a database infrastructure for applications running anywhere.
      Azure Database for PostgreSQL
      Azure Database for PostgreSQL provides a managed database service for app development and deployment that allows you to stand up a PostgreSQL database in minutes and scale on the fly – on the cloud you trust most.
      ElephantSQL
      ElephantSQL hosts PostgreSQL on Amazon EC2 in multiple regions and availability zones. The servers are continuously transferring the Write-Ahead-Log (the transaction log) to S3 for maximum reliability.
      Database Labs
      We manage an optimized Postgres image. You focus on your core app, not on becoming a database administrator.
      See all alternatives
      Decisions about Amazon RDS for PostgreSQL and Amazon Redshift
      No stack decisions found
      Interest over time
      Reviews of Amazon RDS for PostgreSQL and Amazon Redshift
      No reviews found
      How developers use Amazon RDS for PostgreSQL and Amazon Redshift
      Avatar of Olo
      Olo uses Amazon RedshiftAmazon Redshift

      Aggressive archiving of historical data to keep the production database as small as possible. Using our in-house soon-to-be-open-sourced ETL library, SharpShifter.

      Avatar of Mark Walle
      Mark Walle uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

      Using PostGIS to serve GeoJSON data for the Leaflet front-end.

      Avatar of Christian Moeller
      Christian Moeller uses Amazon RedshiftAmazon Redshift

      Connected to BI (Pentaho)

      Avatar of Tinkhaven
      Tinkhaven uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

      Main relational DB engine

      Avatar of Solcast
      Solcast uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

      Store and query data

      Avatar of Kovid Rathee
      Kovid Rathee uses Amazon RedshiftAmazon Redshift

      OLAP and BI

      How much does Amazon RDS for PostgreSQL cost?
      How much does Amazon Redshift cost?
      Pricing unavailable