From: Richard Huxton <dev@archonet.com>
To: apoc9009@yahoo.de
Cc: pgsql-performance@postgresql.org
Subject: Re: BLOB's bypassing the OS Filesystem for better Image
Date: Tue, 26 Apr 2005 10:05:32 +0100
Message-ID: <426E045C.7010601@archonet.com> (raw)
In-Reply-To: <426DFA46.8090402@yahoo.de>
References: <426DFA46.8090402@yahoo.de>
apoc9009@yahoo.de wrote:
> Hi all again,
>
> My next queststion is dedicated to blobs in my Webapplication (using
> Tomcat 5 and JDBC
> integrated a the J2EE Appserver JBoss).
>
> Filesystems with many Filesystem Objects can slow down the Performance
> at opening
> and reading Data.
Which filesystems? I know ext2 used to have issues with many-thousands
of files in one directory, but that was a directory scanning issue
rather than file reading.
> My Question:
> Can i speedup my Webapplication if i store my JPEG Images with small
> sizes inside my PostgreSQL Database (on verry large Databasis over 1 GByte
> and above without Images at this time!)
No. Otherwise the filesystem people would build their filesystems on top
of PostgreSQL not the other way around. Of course, if you want image
updates to be part of a database transaction, then it might be worth
storing them in the database.
> I hope some Peoples can give me a Tip or Hint where in can
> some usefull Information about it!
Look into having a separate server (process or actual hardware) to
handle requests for static text and images. Keep the Java server for
actually processing data.
--
Richard Huxton
Archonet 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-performance@postgresql.org
Cc: dev@archonet.com, apoc9009@yahoo.de
Subject: Re: BLOB's bypassing the OS Filesystem for better Image
In-Reply-To: <426E045C.7010601@archonet.com>
* 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