On Thu, 2020-05-14 at 12:59 +0900, Michael Paquier wrote: > On Wed, May 13, 2020 at 01:55:48PM -0400, Tom Lane wrote: > > Dmitry Igrishin <dmit...@gmail.com> writes: > > > As you know, PostgreSQL has a large objects facility [1]. I'm curious > > > are there real systems which are use this feature? > > > > We get questions about it regularly, so yeah people use it. > > I recall that some applications where I work make use of it for some > rather large log-like data. At the end of the day, it really boils > down to if you wish to store blobs of data which are larger than 1GB, > the limit for toasted fields, as LOs can be up to 4TB. Also, updating > or reading a LO can be much cheaper than a toasted field, as the > latter would update/read the value as a whole.
Interesting; only recently I played with that a little and found that that is not necessarily true: https://www.cybertec-postgresql.com/en/binary-data-performance-in-postgresql/ Yours, Laurenz Albe
