Heroku Database Limits

I've been using Heroku for years and it is a great service with great support. Our company, AtomicJolt uses it for all new projects since we an quickly bring up a new site on a free account and show it to our customers.

One problem we frequently run into is the database row limit when using the development plan. Once you hit 10,000 rows your database write permissions are turned off and you will start to see this error:

PG::Error: ERROR: permission denied for relation [table name here]

At that point you have a couple of options:

  1. Upgrade your database to a paid plan (which can get expensive fast).
  2. Reduce your rows to under 10k by deleting records. Then email [email protected] and as them to give you back permissions. They are really nice about it and fast to respond.
  3. Try out a different host. It's a bit more work but we're also loving Digital Ocean. They support Docker which makes deployment really simple.