CODEWITHSUNDEEP
ruby-on-railsheroku
sibnerian
sibnerian

Reputation: 93

Obtvse- Heroku database approaching row limit

I recently set up an Obtvse blog with Heroku, and today I got an email saying that it was approaching its row limit with 7749 rows. I only have two blog posts! How is this possible? And should I be worried?

Upvotes: 1

Views: 102

Answers (1)

fdr
fdr

Reputation: 467

It is probably session data, or spam comments. At some point Heroku will revoke your write access, but unless one is being outright abusive that is about as far as enforcement goes right now. Perhaps you should consider profiling your use of rows in tables:

$ heroku pg:psql -a my-app
=> \dt

             List of relations
 Schema |       Name        | Type  | Owner 
--------+-------------------+-------+-------
 public | foo               | table | fdr
 public | schema_migrations | table | fdr
(2 rows)

=> SELECT count(*) FROM foo;
 count 
-------
     1
(1 row)

Upvotes: 1

Related Questions