Re: Storing a kazillion small blobs in postgresql. Smart? - Mailing list pgsql-general

From Leonel Nunez
Subject Re: Storing a kazillion small blobs in postgresql. Smart?
Date
Msg-id 43EE2305.8060508@enelserver.com
Whole thread Raw
In response to Storing a kazillion small blobs in postgresql. Smart?  (Stefan Arentz <stefan.arentz@norad.org>)
List pgsql-general
Stefan Arentz wrote:
> Hi there,
>
> I'm looking at the design for an application where i have to store
> potentially many gigabytes worth of small blobs of varying sizes (8K -
> 64K) in a database. I've always been told that it is smarter to store
> references to files in the database, and I think that is true in a lot
> of cases. But here I need this data to be transactional and probably
> replicated so I'm looking into storing it directly in the db.
>
> I know this is all rather vague but I'm interested in more experienced
> pgsql user's opinions about this. Is it smart? Would it work? Or would
> something like this blow up the db?
>
> S.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>


well I store images and  other  files on  the Database   with  ByteA
fields  works  great

leonel


pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Storing a kazillion small blobs in postgresql. Smart?
Next
From: Michael Fuhr
Date:
Subject: Re: Sequence skipping values