Re: Practical usage of large objects.

2020-05-14 Thread Thomas Markus
Am 14.05.20 um 15:36 schrieb Laurenz Albe: 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 We used lo a lot in a project for large uploads (>4G

Re: Practical usage of large objects.

2020-05-14 Thread Laurenz Albe
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 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 que

Sv: Practical usage of large objects.

2020-05-14 Thread Andreas Joseph Krogh
På onsdag 13. mai 2020 kl. 19:53:38, skrev Dmitry Igrishin mailto:dmit...@gmail.com>>: Hello all, As you know, PostgreSQL has a large objects facility [1]. I'm curious are there real systems which are use this feature? I'm asking because and I'm in doubt should the Pgfe driver [2] provide the

Re: Practical usage of large objects.

2020-05-13 Thread Michael Paquier
On Wed, May 13, 2020 at 01:55:48PM -0400, Tom Lane wrote: > Dmitry Igrishin 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 ap

Re: Practical usage of large objects.

2020-05-13 Thread Ron
Our databases use bytea instead.  (I don't know why the application vendor decided on that.) On 5/13/20 12:53 PM, Dmitry Igrishin wrote: Hello all, As you know, PostgreSQL has a large objects facility [1]. I'm curious are there real systems which are use this feature? I'm asking because and I'

Re: Practical usage of large objects.

2020-05-13 Thread Tom Lane
Dmitry Igrishin 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. regards, tom lane

Practical usage of large objects.

2020-05-13 Thread Dmitry Igrishin
Hello all, As you know, PostgreSQL has a large objects facility [1]. I'm curious are there real systems which are use this feature? I'm asking because and I'm in doubt should the Pgfe driver [2] provide the convenient API for working with large objects or not. Thanks! [1] https://www.postgresql.