På torsdag 22. juni 2017 kl. 17:10:40, skrev Achilleas Mantzios < [email protected] <mailto:[email protected]>>: [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 [email protected] <mailto:[email protected]> www.visena.com <https://www.visena.com> <https://www.visena.com>
- [GENERAL] pglogical vs. built-in logical replication ... Andreas Joseph Krogh
- Re: [GENERAL] pglogical vs. built-in logical rep... Achilleas Mantzios
- Re: [GENERAL] pglogical vs. built-in logical... Andreas Joseph Krogh
- Re: [GENERAL] pglogical vs. built-in log... Achilleas Mantzios
- Re: [GENERAL] pglogical vs. built-in... Andreas Joseph Krogh
- Re: [GENERAL] pglogical vs. bui... Achilleas Mantzios
- Re: [GENERAL] pglogical vs.... Andres Freund
- Re: [GENERAL] pglogical... Andreas Joseph Krogh
- Re: [GENERAL] pglogical... Achilleas Mantzios
- Re: [GENERAL] pglogical vs.... Andreas Joseph Krogh
- Re: [GENERAL] pglogical vs. built-in logical... Andres Freund
- Re: [GENERAL] pglogical vs. built-in logical rep... Peter Eisentraut
