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
Best Answer
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.