Alternatives to Amazon RDS for PostgreSQL logo

Alternatives to Amazon RDS for PostgreSQL

Heroku Postgres, Google Cloud SQL for PostgreSQL, Azure Database for PostgreSQL, ElephantSQL, and Database Labs are the most popular alternatives and competitors to Amazon RDS for PostgreSQL.
414
191
+ 1
37

What is Amazon RDS for PostgreSQL and what are its top alternatives?

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.
Amazon RDS for PostgreSQL is a tool in the PostgreSQL as a Service category of a tech stack.

Amazon RDS for PostgreSQL alternatives & related posts

Heroku Postgres logo

Heroku Postgres

259
149
37
259
149
+ 1
37
Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL
Heroku Postgres logo
Heroku Postgres
VS
Amazon RDS for PostgreSQL logo
Amazon RDS for PostgreSQL

related Heroku Postgres posts

Amazon RDS
Amazon RDS
Heroku Postgres
Heroku Postgres
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL
Amazon EBS
Amazon EBS
PostgreSQL
PostgreSQL
Amazon EC2
Amazon EC2

I could spin up an Amazon EC2 instance and install PostgreSQL myself, review latest configuration best practices, sort Amazon EBS storage for data, set up a snapshot process etc.

Alternatively I could use Amazon RDS, Amazon RDS for PostgreSQL or Heroku Postgres and have most of that work handled for me, by a team of world experts...

See more
Tim Nolet
Tim Nolet
Founder, Engineer & Dishwasher at Checkly · | 10 upvotes · 31.4K views
atChecklyHQChecklyHQ
Knex.js
Knex.js
Node.js
Node.js
Heroku Postgres
Heroku Postgres
Heroku
Heroku
PostgreSQL
PostgreSQL

PostgreSQL Heroku Heroku Postgres Node.js Knex.js

Last week we rolled out a simple patch that decimated the response time of a Postgres query crucial to Checkly. It quite literally went from an average of ~100ms with peaks to 1 second to a steady 1ms to 10ms.

However, that patch was just the last step of a longer journey:

  1. I looked at what API endpoints were using which queries and how their response time grew over time. Specifically the customer facing API endpoints that are directly responsible for rendering the first dashboard page of the product are crucial.

  2. I looked at the Heroku metrics such as those reported by heroku pg:outlier and cross references that with "slowest response time" statistics.

  3. I reproduced the production situation as best as possible on a local development machine and test my hypothesis that an composite index on a uuid field and a timestampz field would reduce response times.

This method secured the victory and we rolled out a new index last week. Response times plummeted. Read the full story in the blog post.

See more
Google Cloud SQL for PostgreSQL logo

Google Cloud SQL for PostgreSQL

50
31
0
50
31
+ 1
0
Fully-managed database service- set up, maintain, manage, and administer your relational PostgreSQL databases in the cloud
    Be the first to leave a pro
    Google Cloud SQL for PostgreSQL logo
    Google Cloud SQL for PostgreSQL
    VS
    Amazon RDS for PostgreSQL logo
    Amazon RDS for PostgreSQL
    Azure Database for PostgreSQL logo

    Azure Database for PostgreSQL

    11
    12
    0
    11
    12
    + 1
    0
    Managed PostgreSQL database service for app developers
      Be the first to leave a pro
      Azure Database for PostgreSQL logo
      Azure Database for PostgreSQL
      VS
      Amazon RDS for PostgreSQL logo
      Amazon RDS for PostgreSQL