Skip site navigation (1) Skip section navigation (2)

Re: not really SQL but I need info on BLOBs

From: Theodore Petrosky <tedpet5(at)yahoo(dot)com>
To: Denis Braekhus <denis(at)startsiden(dot)no>, pgsql-sql(at)postgresql(dot)org
Subject: Re: not really SQL but I need info on BLOBs
Date: 2004-05-10 11:41:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

Interesting, have you had any experience using a SAN
for the images? Do you know anyone that has
successfully used a SAN to store images that are
accessable to multiple servers?

I do not, however the last place I worked was in the
beginning stages of putting in a SAN. As it was
explained, the raid that would store the images would
be seen as 'local' to as many servers (running
different client services) as the SAN could support.

Thanks for the reply.


--- Denis Braekhus <denis(at)startsiden(dot)no> wrote:
> Hash: SHA1
> Theodore Petrosky wrote:
> | I am working on a project where the IT department
> is
> | pushing really hard to have all the images in the
> db.
> | I don't know what the agenda is. I am hopeful to
> come
> | up with reasons either why this is good or not
> good.
> We have never used BLOB support for images, however
> one additional
> feature of using BLOBs vs files on a disk would be
> having easier setup
> if multiple servers/clients need to access those
> images.
> In the case of using a filesystem you would either
> have to provide
> access to the images over a network filesystem or
> replication, whereas
> using the DB for storage does not require anything
> more than access to
> the DB..
> We are using filesystem replication for situations
> like this (multiple
> webservers needing access to exactly the same
> images), however there are
> multiple other options for this situation. Of course
> needing to do
> editing on the images aswell provides additional
> hurdles.
> Bottom line seems to me to be that if this is all to
> be located on one
> server there is no good reason to not use filesystem
> storage for images,
> whereas if you need multiple servers and generally a
> more complex setup
> you should weigh the pros to the cons..
> Regards
> - --
> Denis
> Version: GnuPG v1.2.2-nr2 (Windows XP)
> EyIqpTqWbZimUFdOjaFdpbI=
> =Uzfm

Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs 

In response to

pgsql-sql by date

Next:From: Christoph HallerDate: 2004-05-10 12:49:35
Subject: Re: working with schema
Previous:From: William Anthony LimDate: 2004-05-10 08:10:31
Subject: working with schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group