PostgreSQL maximum multimedia size of 1GB

[nilshansen94]

The current internal multimedia type of the PostgreSQL store is the BYTEA type. It has the drawback that it can only save up to 1GB of binary data. An alternative would be the OID type, but using this type brings a lot of complexity. For every multimedia insert, the object identifier (OID) has to be stored individually. When a row with a OID is deleted, the binary object is not automatically deleted. For every delete and truncate (and probably update as well), the affected binary objects have to be deleted manually. See the PostgreSQL documentation for more information.