On 2008-08-14 20:03, [EMAIL PROTECTED] 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 ] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general