Re: very slow largeobject transfers through JDBC

Поиск
Список
Период
Сортировка
От Mate Varga
Тема Re: very slow largeobject transfers through JDBC
Дата
Msg-id CAK4GaZ7w4yfNCcwcchxJkGc_HC9Pv-s7jzqQh=8t_mV2VqsKCg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: very slow largeobject transfers through JDBC  (Dmitry Igrishin <dmitigr@gmail.com>)
Ответы Re: very slow largeobject transfers through JDBC  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-general
Дерево обсуждения
I see -- we could try that, though we're mostly using an ORM (Hibernate) to do this. Thanks!

On Fri, Aug 31, 2018 at 3:57 PM Dmitry Igrishin <dmitigr@gmail.com> wrote:
пт, 31 авг. 2018 г. в 16:35, Mate Varga <m@matevarga.net>:
>
> Hi,
>
> we're fetching binary data from pg_largeobject table. The data is not very large, but we ended up storing it there. If I'm copying the data to a file from the psql console, then it takes X time (e.g. a second), fetching it through the JDBC driver takes at least 10x more. We don't see this difference between JDBC and 'native' performance for anything except largeobjects (and bytea columns, for the record).
>
> Does anyone have any advice about whether this can be tuned or what the cause is?
I don't know what a reason of that, but I think it's reasonable and
quite simple to call lo_import()/lo_export() via JNI.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgrade fails saying function unaccent(text) doesn't exist
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgrade fails saying function unaccent(text) doesn't exist