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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
