Re: type of field

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: type of field
Date: 2010-01-18 22:09:04
Message-ID: 4B54DC00.3070004@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark a écrit :
> On Mon, Jan 18, 2010 at 8:24 PM, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)com> wrote:
>> I've got to store many small videos; to make things simple (backup/restore,
>> because users don't know very much about IT) I've choosen BYTEA + EXTERNAL,
>> is it the right choice?
>
> If you want to store them in the database then yes, that sounds right to me.
>
> The debate over whether to store things like this in the database or
> outside won't be resolved on this thread but you should be aware of
> the pros and cons of each method. It sounds like you've done some
> research already.

Yeah, you're right: dunno wanna feed the Troll :)

I choosed this solution because people are only users, they can't afford
a full time admin & they can't loose many time in complicated procedures,
so the backup/restore procedure must stay as simple as possible on big tapes.

BTW, for my own knowledge, could you point me to pages that describes
out-of-db big blobs (>5GB) link/unlink & store/wipe to/from DB?

Thanks.
--
"Benson, you are so free of the ravages of intelligence"
-- Time Bandits

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2010-01-18 22:48:29 Re: data dump help
Previous Message Terry 2010-01-18 22:08:48 data dump help