Re: Video storage in Postgres? - Mailing list pgsql-advocacy

If it is so now, would it make sense to have also a different version that
would require less memory? Or even change the current one? In any case the
data comes from the disk, and is going out using a network connection that
very often is slower than the speed from the disk.

I don't know, if there is enough demand for such a feature, but I don't see
that it would be sensible to use memory in that way.

Rgs,

Jussi




Joshua D. Drake (jd@commandprompt.com) kirjoitti:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Bob Zurek wrote:
> > What hear from the video companies is that they would find it easier
> > than using a file system and that they could have the database handle
> > backups, fault tolerance, security, recovery and replication.
>
> I assume then that the performance hit the database is going to take is
> acceptable? Keep in mind that if you stored in Bytea, a 700 Meg video,
> you are going to use 700 Meg of ram to pull that video out "per pull".
>
> Joshua D. Drake
>
>
> >
> > Z.
> >
> > -----Original Message-----
> > From: pgsql-advocacy-owner@postgresql.org
> > [mailto:pgsql-advocacy-owner@postgresql.org] On Behalf Of JoshuaKramer
> > Sent: Thursday, August 16, 2007 11:43 PM
> > To: pgsql-advocacy@postgresql.org
> > Subject: Re: [pgsql-advocacy] Video storage in Postgres?
> >
> >
> > This, along with the "appropriate apps for mySQL", reminds me of the
> > Parable of the Porsche that I just made up.
> >
> > My buddy Bob wanted to tow a horse trailer with a Porsche.  He could
> > haul
> > the jockeys around to drive horses listed in the directories at
> > different
> > stables, but he'd love to haul his horses with his Porsche.
> >
> > Bob decided to seek the expertise of wise men Chris Titus and Tim
> > Taylor.
> > "Yes, you can haul a horse trailer with a Porsche, but it won't be easy.
> >
> > You see, the Porsche is not designed to haul trailers.  You need
> > something
> > that is, but is also a Porsche."
> >
> > So the wise men thought some more.  "You must get a Volkswagen Toureg
> > with
> > the diesel V10, for diesels are designed to tow trailers.  Then, to
> > satisfy the requirement of it being a Porsche, you must purchase the
> > fenders, bumpers, and other bling from a Porsche Cayenne and fix it to
> > your Toureg.  Then you will have a Porsche that can tow a horse
> > trailer."
> >
> > Moral of the story: Yep, you can tow a horse trailer with a Porsche, or
> > serve video with your DB server, or base your enterprise app on MySQL -
> > but it just isn't right.  :)
> >
> > In all seriousness, what advantages accrue by serving video from the DB?
> >
> > Cheers,
> > JK
> >
> > BTW - there's a guy near where I live who drives a Cayenne.  I've always
> >
> > wanted to go up to him and comment on how nice his Taureg is - but that
> > just wouldn't be right, now would it? ;) The two SUV's are actually the
> > same platform; the Porsche just has differently styled bling.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: don't forget to increase your free space map settings
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> >        subscribe-nomail command to majordomo@postgresql.org so that your
> >        message can get through to the mailing list cleanly
> >
>
>
> - --
>
>       === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
> PostgreSQL solutions since 1997  http://www.commandprompt.com/
>             UNIQUE NOT NULL
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL Replication: http://www.commandprompt.com/products/
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFGxcrPATb/zqfZUUQRAjuNAJ4+fMO4QA1lRRGJPyK30sqq0YsDkACcDi6G
> BLn31ICs0fxElAYWpz/WcLM=
> =cFqY
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>