On 06/02/11 2:19 AM, Ognjen Blagojevic wrote:
1. Files stored on the filesystem:
- Small database footprint
- Faster backup, export and import
2. Files stored in the database
- RDBMS takes care of transactions and ref. int.
- Slower backup, export and import but all done in one step
- Easier continuous archiving
with many terabytes of large file data accumulating, the database will
become very unweildy to do any maintenance on. a simple pg_dump will
take many hours vs a few minutes.
I would almost certainly use a filesystem for an app like this, and just
store the metadata in the database.
--
john r pierce N 37, W 123
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
