På torsdag 22. juni 2017 kl. 17:10:40, skrev Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx>:
[snip]What's so better in LO's VS bytea? You do a lot updates on the binary data, changing only parts of it?
BYTEA really sucks when dealing with large objects and streaming to clients (JDBC). The only solution (I've found) which doesn't explode in memory-usage is using LOs (OIDs). Note that we're dealing with multi-gigabytes objects, which need to be "transactional safe" (hence stored in the DB).
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
