Search Postgresql Archives

Re: Experiences with BLOB + PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 2008-08-14 20:03, juliano.freitas@xxxxxxxxxxxxx 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 ]


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux