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 ]