Re: Where to store Blobs?

Поиск
Список
Период
Сортировка
От Hannes Erven
Тема Re: Where to store Blobs?
Дата
Msg-id 111be01e-c8b1-eab0-a87e-d7410ff02789@erven.at
обсуждение исходный текст
Ответ на Where to store Blobs?  (Thomas Güttler <guettliml@thomas-guettler.de>)
Ответы Re: Where to store Blobs?  (Jamesie Pic <jpic@yourlabs.org>)
Список pgsql-general
Hi,


Am 13.03.19 um 15:28 schrieb Thomas Güttler:
> 
> Where do you store Blobs?


Within PostgreSQL, of course. The system I have in mind stores ZIP and 
PDF files, usually a few MBs each; we're currently at a total of about 
100 GB and there are no evident problems.

For this application, it is extremely important that saving/modifying 
the binaries is part of a larger transaction that completes/fails 
atomically.
Replication is almost real-time and access to the binaries is provided 
with the same libraries (JDBC/Hibernate) as everything else.


Best regards,

    -hannes



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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Where to store Blobs?
Следующее
От: Jamesie Pic
Дата:
Сообщение: Re: Where to store Blobs?