From: David Warnock <david@sundayta.co.uk>
To: Collin F. Lynch <clynch@water2.cs.umass.edu>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Images
Date: Wed, 23 Jun 1999 17:50:02 +0100
Message-ID: <3771103A.4160DA47@sundayta.co.uk> (raw)
References: <199906231533.LAA02731@water2.cs.umass.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: david@sundayta.co.uk, clynch@water2.cs.umass.edu
Subject: Re: [INTERFACES] Images
In-Reply-To: <3771103A.4160DA47@sundayta.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox