Re: Blob data type and it's efficiency on PostgreSQL

Поиск
Список
Период
Сортировка
От Daniel Schuchardt
Тема Re: Blob data type and it's efficiency on PostgreSQL
Дата
Msg-id dgokm4$2t3h$2@news.hub.org
обсуждение исходный текст
Ответ на Blob data type and it's efficiency on PostgreSQL  ("Stas Oskin" <stas@neo.co.il>)
Список pgsql-general
Stas Oskin schrieb:

> Hi.
>
>
>
> We are using PostgreSQL as the RDBMS for our product, and are very
> happy with it. Recently, we have encountered a need to store a lot of
> binary files, mainly images (up to ~100,000 files, with sizes varying
> from 300K-2MB).
>
>
>
> The question is, how well PostgreSQL performs with the blob data type,
> and is it practical to store these files as blobs?
>
>
>
> Thanks in advance,
>
> Stas Oskin.
>
We save binary data in pgsql without problems. (Especially icons, Report
definitions, Images, ...) Be carefull with dump and restore because it
is a bit complicated to work with blobs here.

Daniel

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

Предыдущее
От: Daniel Schuchardt
Дата:
Сообщение: shared Locks
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: shared Locks