Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am running a Rails application with a Postgresql database. I am exited to say that I am scaling rapidly, and I now have over 1,000,000 posts, not including the User table, in Postgresql(approx 22GB). What instance size should I purchase? I currently have an 8x core, 8GB, SSD cloud server, and it is sh^tting a brick. Reviewing both cloud and dedicated hardware solutions.

Price, for the most part, is not a factor.


  • Rails 4
  • Postgresql 9.1

Any advice is humbly welcome.

Cheers, Jake

share|improve this question

migrated from Mar 21 '14 at 4:10

This question came from our site for professional and enthusiast programmers.

8GB RAM for an only 22GB DB, and you're having performance problems? I strongly suspect the problem isn't your hardware, it's your database configuration and your access patterns (your SQL). You may also need a caching layer like Redis with some simple cache invalidation code like LISTEN/NOTIFY triggers. Also, seriously, why aren't you on the current version of PostgreSQL if you're having performance issues? In particular, 9.2 adds index-only scans. – Craig Ringer Mar 21 '14 at 1:29
Out of interest, what "cloud server" exactly? Something on AWS? Elsewhere? – Craig Ringer Mar 21 '14 at 1:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.