| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Need suggestion |
| Date: | 2011-06-02 16:58:51 |
| Message-ID: | 4DE7C14B.3080902@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2011-06-02 18:46:49 | Re: Passing parameters into an in-line psql invocation |
| Previous Message | Gauthier, Dave | 2011-06-02 16:58:23 | Passing parameters into an in-line psql invocation |