oTree Forum >

How to configure higher tier postgres on heroku (standard)

#1 by GKarreskog

Hi, 

We are planning on running quite a large and simultaneous experiment. When stresstesting it using browser_bots it is much slower on heroku than on local server. Looking at the dyno load they don't seem to be the problem, so I suspect the postgres instance is at fault. 

Looking at the descriptions of the different tiers I suspect we need on of the standard-tier postgres instances and not the essential ones. However, from the interface on otreehub it is only possible to pick the essential ones. It is not enough to simply start up a higher tier postgres on heroku. 

Does anyone have experience with this? 

On a related note, would be a great improvement if it were possible to select also higher tiers of the DB from the otreehub configure interface.

#2 by woodsd42

I had a similar issue recently: https://www.otreehub.com/forum/1240/

The 'solution' was to provision it myself using the Heroku CLI with the command line.  After that, everything still works with otreehub (except for changing DB's of course).

I suspect the reason why we can't do this on otreehub is that the higher tiers require activating maintenance mode and have more steps involved and are not near-instant, whereas the lower tiers can be provisioned and switched with just one line in the command line.

#3 by GKarreskog

Thank you! 

Works well. And I guess that is a good reason not to include it in the configure dashboard.

Write a reply

Set forum username