Re: Need suggestion

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