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

Re: [INTERFACES] Images

From: David Warnock <david(at)sundayta(dot)co(dot)uk>
To: "Collin F(dot) Lynch" <clynch(at)water2(dot)cs(dot)umass(dot)edu>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] Images
Date: 1999-06-23 16:50:02
Message-ID: 3771103A.4160DA47@sundayta.co.uk (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
Collin,

We have a document system that has approx 270,000 tif images. These can
be quite large (500k is not uncommon I think we now have over 50gb of
images).  We keep these out of the dbms and in separate files (dbms just
has filename) for several reasons.

1. We can have the same image in multiple formats if required.

2. We can distribute the images and dbms onto different disks or even
different servers (ie clients get data from one server and images from
another). In our latest multi-tier application again we get better speed
by accessing the images and data from different servers.

3. If the db is not available at least the images can be viewed (NB as
we are currently forced to run a db on a Windows NT server this is sadly
the case far too often).

4. We are able to cache/mirror the images around the wan so that users
pick images up from a more local copy reducing bandwidth requirements

5. Backing up is simpler as the database is much smaller and the images
are readonly

6. We can have multiple dbms and/or applications easily accessing the
images if required.

"Collin F. Lynch" wrote:
> 
>         Greetings,
>         I'm working for the computer vision group at UMass's CS department and we are looking
> at using Postgres to catalog Images and video for a large data coordination project.  I am
> running my own experiments, but I wanted to know if anyone has any data on internally stored
> versus externally stored images.
> 
>         Collin Lynch.

-- 
David Warnock
Sundayta Ltd

In response to

  • Images at 1999-06-23 15:33:49 from Collin F. Lynch

pgsql-hackers by date

Next:From: Collin F. LynchDate: 1999-06-23 16:50:21
Subject: ARC/Info and Intergraph
Previous:From: Frank MortonDate: 1999-06-23 16:15:43
Subject: Re: [INTERFACES] Images

pgsql-interfaces by date

Next:From: Collin F. LynchDate: 1999-06-23 16:50:21
Subject: ARC/Info and Intergraph
Previous:From: Frank MortonDate: 1999-06-23 16:15:43
Subject: Re: [INTERFACES] Images

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