datamade / how-to

📚 Doing all sorts of things, the DataMade way
MIT License
86 stars 12 forks source link

Document Heroku "database disruption imminent" emails #118

Closed jeancochrane closed 3 years ago

jeancochrane commented 3 years ago

Documentation request

If a review app requires loading in data with more than 10,000 rows, Heroku will send an angry email to whoever "deployed" that review app saying that disruption of the database is imminent because of exceeded row limits. These emails can be safely ignored, but they're annoying.

The only way I can see to block these emails would be to upgrade review apps that require more than 10,000 rows to larger Heroku Postgres plans, but unfortunately there doesn't seem to be a way to do this in an automated fashion because Heroku defaults to the cheapest plan for review apps.

We should provide some guidance in the Heroku docs on how to deal with these emails. I think the potential ways of dealing with these emails are:

  1. Work to define a "sample" set of data that's smaller than 10,000 rows
  2. Ignore the emails
  3. Manually upgrade databases for review apps