Sv: Practical usage of large objects.

Поиск

Список

Период

Сортировка

От	Andreas Joseph Krogh
Тема	Sv: Practical usage of large objects.
Дата	14 мая 2020 г. 07:41:17
Msg-id	VisenaEmail.21.581b820415f7eba2.172121e6553@tc7-visena обсуждение исходный текст
Ответ на	Practical usage of large objects. (Dmitry Igrishin <dmitigr@gmail.com>)
Список	pgsql-general

Дерево обсуждения

På onsdag 13. mai 2020 kl. 19:53:38, skrev Dmitry Igrishin <dmitigr@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 convenient API
for working with large objects or not.

Thanks!

Yea, we use LOs, because using JDBC bytea reallys doesn't stream (at least using the pgjdbc-ng driver). When retrieving bytea using JDBC it retunrs an InputStream but it's backed by an in-memory byte[]. With LOs and java.sql.Blob (which the standard pgjdbc-dirver doesn't support ,but pgjdbc-ng does) it acutally uses strams and memory is kept down to a minimum.

--
Andreas Joseph Krogh

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Sv: Practical usage of large objects.