7 ms·
While I agree that the old plans were unintuitive, the new plan seems somewhat abuse able. How big can a blob be in PG?
by stonemetal 14y ago
While I agree that the old plans were unintuitive, the new plan seems somewhat abuse able. How big can a blob be in PG?
- fusiongyro 14y ago1 GB. You can see the other limits here: http://www.postgresql.org/about/ http://www.postgresql.org/about/
- einhverfr 14y agoactually 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.
- bartonfink 14y agoA 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_for_a_row.2C_a_table.2C_and_a_database.3F http://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size...
- masklinn 14y agohttp://www.postgresql.org/about/ 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)