Storing/Retrieving large attachments from Postgresql database results in OOM Error

Postgresql uses bytea data type to store attachments in the database, when attachments are too large the postgresql fails with OOM errors as the entire attachment is held in memory.