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.