På torsdag 22. juni 2017 kl. 17:10:40, skrev Achilleas Mantzios <
ach...@matrix.gatewaynet.com <mailto:ach...@matrix.gatewaynet.com>>:
[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
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
