Re: Use bytearray for blobs or not?

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Use bytearray for blobs or not?
Дата
Msg-id 07d16f3f-0352-7802-ef1c-bd9987ec623b@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Use bytearray for blobs or not?  (Thomas Güttler <guettliml@thomas-guettler.de>)
Ответы Re: Use bytearray for blobs or not?  (Thomas Güttler <guettliml@thomas-guettler.de>)
Re: Use bytearray for blobs or not?  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-general
On 4/1/19 1:41 μ.μ., Thomas Güttler wrote:
> Some months ago I wrote a little application with Python+Django which stores
> blob data in bytearrays.
>
> It works.
>
> In the future there will be a lot more traffic, and I am unsure
> if this is really a good solution. I know this is more FUD than
> concrete PG issue.
>
> What do you think?

Performance (at least for JDBC) is known to be better with blobs.
However, with bytea life is just easier for many reasons (backups, logical replication, other types of replication, sys
management,etc).
 

>
> Which alternatives could be useful?
>
> Regards,
>   Thomas
>
>
>
>


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt



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

Предыдущее
От: Rijo Roy
Дата:
Сообщение: Refresh using barman
Следующее
От: Kristjan Tammekivi
Дата:
Сообщение: Re: Potentially undocumented behaviour change in Postgres 11concerning OLD record in an after insert trigger