Re: Where to store Blobs?

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Where to store Blobs?
Дата
Msg-id 7e1cf29a-bd11-dba3-2b4a-48080c6bc60d@aklaver.com
обсуждение исходный текст
Ответ на Where to store Blobs?  (Thomas Güttler <guettliml@thomas-guettler.de>)
Список pgsql-general
On 3/13/19 7:28 AM, Thomas Güttler wrote:
> Some days ago I asked "Where **not** to use PostgreSQL?" on this mailing 
> list.
> 
> Now I realized: Nobody talked about Blobs.
> 
> I guess most people do not store Blobs in PostgresSQL.
> 
> Where do you store Blobs?

Probably the preferred method:
https://www.postgresql.org/docs/11/datatype-binary.html

Another method:
https://www.postgresql.org/docs/11/largeobjects.html

> 
> (In my case Blobs are PDF/image files with size up to 20 MByte.
> I do not talk about very big blobs which are several hundret MByte)
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: ERROR: XX000: cannot update SecondarySnapshot during a paralleloperation
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Where to store Blobs?