Re: use BLOBS or use pointers to files on the filesyste

From: Troy(dot)Campano(at)LibertyMutual(dot)com
To: ec9098(at)www2(dot)us(dot)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: use BLOBS or use pointers to files on the filesyste
Date: 2001-12-10 16:17:42
Message-ID: 9534B16F750ED2118CF90008C724C4460C2222D8@lmig-msg-20.lmig.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From what I understand performance will be very slow if you are storing that
much in the database.
It would be better just to store the pointer.

-----Original Message-----
From: Travis Bear [mailto:ec9098(at)www2(dot)us(dot)postgresql(dot)org]
Sent: Sunday, December 09, 2001 6:49 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] use BLOBS or use pointers to files on the filesystem?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

I'm kind of a database newbie in general, so be nice to me if this is a
bonehead question. I am building a java servlet based web application to
manage photos and images. My first thougth has been to store the images as
BLOBs in the database, but I read one user say that you're better off not
using BLOBs. Instead, he says, store your large data objects as files on
the filesystem, and just use the database to store the path to the file and
any file-related meta data.

I wasn't sure what to think of this, so I was hoping to get some other ideas
and opinions. I expect to accumulate 1-2 gigs of new data per year, max,
with average image size being 700k.

Also, if I've missed any obvious documentation on this issue please feel
free to send it my way.

Thanks!

Travis

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>

iQA/AwUBPBP9vKBIzo/FCjIeEQLffgCePrTcI3ugWC9NhdRT12Pt1XFnW0gAoLl3
t8HQbiGAOJt6jDhZNZlk+2GL
=N3bL
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Browse pgsql-general by date

  From Date Subject
Next Message wsheldah 2001-12-10 16:21:41 Re: Inserting the current date
Previous Message Frank Joerdens 2001-12-10 16:09:46 Re: use BLOBS or use pointers to files on the filesystem?