From: | Rod <cckramer(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Storing many big files in database- should I do it? |
Date: | 2010-04-27 09:23:31 |
Message-ID: | j2ib4c00a111004270223xe2764897w4e8938caa83c6eb7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
S3 is not primary storage for the files, it's a distribution system.
We want to be able to switch form S3 to other CDN if required.
So, "Master" copies of files is kept on private server. Question is
should it be database of filesystem.
On Tue, Apr 27, 2010 at 7:03 PM, Massa, Harald Armin <chef(at)ghum(dot)de> wrote:
>> No, I'm not storing RDBMS in S3. I didn't write that in my post.
>> S3 is used as CDN, only for downloading files.
>
>
> So you are storing your files on S3 ?
>
> Why should you store those files additionally in a PostgreSQL database?
>
> If you want to keep track of them / remember metadata, hashes will do the
> job with much less memory.
>
> Harald
>
> --
> GHUM Harald Massa
> persuadere et programmare
> Harald Armin Massa
> Spielberger Straße 49
> 70435 Stuttgart
> 0173/9409607
> no fx, no carrier pigeon
> -
> %s is too gigantic of an industry to bend to the whims of reality
>
From | Date | Subject | |
---|---|---|---|
Next Message | Allan Kamau | 2010-04-27 09:33:41 | Re: Efficient intersect operation (Full Text Search) |
Previous Message | Cédric Villemain | 2010-04-27 09:17:42 | Re: Storing many big files in database- should I do it? |