We have an instance hosted on Heroku. When it’s being used for complex queries, we need to up the Dyno formation to use the M setup instead of the 2X setup. This greatly improves the performance of the system, but comes at a cost. Is anyone hosting their instance somewhere that can auto-scale easily enough? At the moment I need to remember to scale-down the instance to avoid paying the full $250/month charge all the time.
I deployed it via the one-click button.