2 ms·
Thanks for info! What about binary large objects instead of bytea? Size/speed of backups is a good point to consider.
by jrochkind1 5y ago
Thanks for info! What about binary large objects instead of bytea?
Size/speed of backups is a good point to consider.
- yarcob 5y agoI've never used PostgreSQLs large objects. You have to use this awkward API to use them, they aren't stored efficiently either, and as far as I can tell it's just a legacy feature that nobody has bothered to deprecate yet. In my opinion the only neat thing about large objects is that you can edit files with a posix-like API in a database transaction, but I can't think of a scenario where that would actually be useful.