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

From: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Blob data type and it's efficiency on PostgreSQL
Date: 2005-09-20 09:27:36
Message-ID: dgokm4$2t3h$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-09-20 09:33:47 Re: shared Locks
Previous Message Daniel Schuchardt 2005-09-20 09:18:48 shared Locks