Re: Experiences with BLOB + PostgreSQL

On 2008-08-14 20:03, juliano(dot)freitas(at)ati(dot)pe(dot)gov(dot)br wrote:

> I'd like to ask you about some experience in managing huge databases which
> store mostly binary files.

Do you mean BYTEA or large objects? Both have pros and cons.

> We're developing a system which is likely to grow up to terabytes in
> some years and I'd like to hear something from people who really
> administrate these kinds of databases.

I do not really administrate this kind of database, but I see one
serious problem - a major version upgrade would be very hard.

A filesystem storage with metadata stored in a database would be much
better.

Pozdrawiam
Tometzky
--
Best of prhn - najzabawniejsze teksty polskiego UseNet-u
http://prhn.dnsalias.org/
Chaos zawsze pokonuje porządek, gdyż jest lepiej zorganizowany.
[ Terry Pratchett ]