Re: Storing many big files in database- should I do it? - Mailing list pgsql-general

From Rod
Subject Re: Storing many big files in database- should I do it?
Date
Msg-id j2ib4c00a111004270223xe2764897w4e8938caa83c6eb7@mail.gmail.com
Whole thread Raw
In response to Re: Storing many big files in database- should I do it?  ("Massa, Harald Armin" <chef@ghum.de>)
List 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@ghum.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
>

pgsql-general by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Storing many big files in database- should I do it?
Next
From:
Date:
Subject: Re: PostgreSQL Performance issue