News for hackers. Stuff that matters.
Re:Heroku Postgres Basic Plan by stonemetal on Monday July 16, 2012 @02:59PM (#4251974)
While I agree that the old plans were unintuitive, the new plan seems somewhat abuse able. How big can a blob be in PG?
Re:Heroku Postgres Basic Plan by fusiongyro on Monday July 16, 2012 @03:34PM (#4252136)
1 GB. You can see the other limits here:

http://www.postgresql.org/about/

Re:Heroku Postgres Basic Plan by einhverfr on Monday July 16, 2012 @07:48PM (#4253317)
actually a lob can go up to 2GB. Byteas are limited to 1GB.

I store images and other binary data in the db all the time, when this is closely associated with data in the db and needs to be maintained together. Usually these files are store once, retrieve seldom. However for practical purposes I would not recommend going above a few megs on a bytea field. lobs are easier because you can seek in them, but access will never be as fast as it would be directly from the filesystem.

Re:Heroku Postgres Basic Plan by bartonfink on Monday July 16, 2012 @03:48PM (#4252205)
A row can be 400GB, so both size and row metrics make sense. I think that the size metric is likely helped tremendously by sane alerts.

http://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size...

Re:Heroku Postgres Basic Plan by masklinn on Tuesday July 17, 2012 @08:15AM (#4255333)
http://www.postgresql.org/about/ even quotes 1.6TB/row. Guessing it's under the two maximums of 1600 max columns, 1GB max/field (though they may not actually be compatible)