I like to know your opinion when to upgrade heroku database. We are putting tons of money in heroku dynos but still things are not good.
New relic screenshot : http://cl.ly/image/32423E2K2S2A
Everyday, we have to perform big database operation like 300k rows were updated or created. We are using very powerful server (just for 1 job) to do this. But, when we perform such operation our website barely works. I see tons of request timeout error. I have also included the image of newrelic, the database thing always takes much time. Is it normal ?
- Should i consider upgrading my database ?
- Why ? what was the thing which is missing. we are using heroku crane plan.
- How you will going to handle 300k transactions everyday.
We are using Rails 4 and postgres 9.3.2 version. But, for performing big operations like bulk updating and deleting we tend to use raw SQL.