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 <dmitigr@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
