All our apps at work run on Heroku. Most of our apps use the dev database in production (they don't get much load and handle tiny amounts of data). But we have one or two that get some significant load.
The biggest advantage of running on Heroku for us has been the ability to upgrade the postgres database with little trouble (of course, there is cost). Literally run a few commands and you have migrated to a completely new database server. I can't give you performance comparisons between running our own and hosting on Heroku (because we've always been on Heroku), but on the higher cost databases we get some pretty excellent performance (between 1-15ms response) across tables with hundreds of thousands of rows with hundreds of inserts and updates per second. - Ben On Friday, 12 October 2012 at 2:06 PM, Pat Allan wrote: > Most of my active apps these days are on Heroku, and they pretty much all use > Heroku's PostgreSQL databases. Granted, the vast majority of them handle > almost no traffic. > > The exception is flying-sphinx.com (http://flying-sphinx.com), which in the > scheme of things isn't massive, but handles around 30 queries/minute, every > one of which hits the db at least once. With the proper database indices in > place, my API's calls take generally 30-50ms, and I'm on the crane > ($50/month) plan. > > There's been one minor (a few minutes) outage in the past six months, plus > two major AWS/Heroku incidents, though from memory only one of those affected > the database - to some extent, you're at the mercy of Amazon. > > Hopefully those are some useful data points. > > -- > Pat > > On 12/10/2012, at 12:34 PM, Fabio Vilela wrote: > > > Hi guys, hope you all are having a happy Friday!! > > > > is anyone using this postgresql on heroku? what can you say about speed and > > reliability? > > > > I'd like to hear any comments on that before I begin any kind of testing :) > > > > thanks, > > Fabio. > > > > > > > > -- > > You received this message because you are subscribed to the Google Groups > > "Ruby or Rails Oceania" group. > > To post to this group, send email to [email protected] > > (mailto:[email protected]). > > To unsubscribe from this group, send email to > > [email protected] > > (mailto:[email protected]). > > For more options, visit this group at > > http://groups.google.com/group/rails-oceania?hl=en. > > > > > > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" group. > To post to this group, send email to [email protected] > (mailto:[email protected]). > To unsubscribe from this group, send email to > [email protected] > (mailto:[email protected]). > For more options, visit this group at > http://groups.google.com/group/rails-oceania?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rails-oceania?hl=en.
