> 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
No comments:
Post a Comment