Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

Specs:

  • Rails 4
  • Postgresql 9.1

Any advice is humbly welcome.

Cheers, Jake

share|improve this question

migrated from stackoverflow.com Mar 21 at 4:10

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

3  
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 at 1:29
1  
Out of interest, what "cloud server" exactly? Something on AWS? Elsewhere? –  Craig Ringer Mar 21 at 1:31

Your Answer

 
discard

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