2

I have recently set up a new RDS instance to test out working with a AWS postgres instance vs a heroku postgres instance. What I've found is that when I load an instance of 1000 entries in RDS its taking 100ms to read where when I do the same thing in heroku its taking 20ms.

I imagine its something I did wrong during set up. I followed https://reinteractive.net/posts/128-heroku-app-backed-by-an-aws-rds-postgres-database for the set up.

Is there something I missing that I should have done after setup?

RDS Build:
Instance: db.m3.xlarge Ram: 15GB Storage: Purpose (SSD)
IOPS: disabled
StorageAmount: 100 GB
Multi-AZ: NO

Heroku Build:
1 GB RAM
64 GB storage

5
  • What are the specs on the Heroku hardware? Different systems will perform differently. Jun 10, 2015 at 20:04
  • How do you measure the time? It can be the network speed/latency between the different data centres, too.
    – dezso
    Jun 10, 2015 at 20:54
  • @JohnM- The heroku is a much weaker machine I believe. It's their basic standard. Added the stats to the post. Jun 10, 2015 at 21:03
  • @dezso Currently I'm running queries in a rails console that gives me a rough time it took to run. Jun 10, 2015 at 21:04
  • Did you check network latency? Did you try timing the insert of 100K rows instead of a mere 1000? Jun 10, 2015 at 21:38

1 Answer 1

3

So I came to find out that my heroku instance wasn't in the same availability region as my rds instance. Once I changed it over to east coast the RDS DB was slightly quicker then my heroku DB.

Incase anyone is stuck on how to create a rds instance in a different region through aws console, you need to click on region (i.e. Oregon) button in the top right corner and then create your instance.

2
  • Please mark your own answer as correct (when you can). This may help those who come across the same problem. Thanks. BTW, welcome to the forum. Jun 12, 2015 at 13:26
  • "Availability regions"... There are Regions and there are Availability Zones. Availability Zones (or AZ's) are multiple, isolated locations within each Region. Jan 18, 2021 at 8:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.