Blob data type and it's efficiency on PostgreSQL
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.
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