Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id D6AA663351F
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  7 Apr 2010 10:01:12 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 44831-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  7 Apr 2010 13:00:53 +0000 (UTC)
X-Greylist: delayed 00:06:39.301146 by SQLgrey-1.7.6
Received: from ns1.corpmailserver.com (ns1.corpmailserver.com [72.35.70.2])
	by mail.postgresql.org (Postfix) with ESMTP id 91E6D63344C
	for <pgsql-admin@postgresql.org>; Wed,  7 Apr 2010 10:01:01 -0300 (ADT)
Received: (qmail 4175 invoked by uid 89); 7 Apr 2010 12:46:29 -0000
Received: by simscan 1.3.1 ppid: 4102, pid: 4163, t: 0.5790s
	scanners: attach: 1.3.1 clamav: 0.95.3/m:
Received: from unknown (HELO direction.biz)
	(postmaster@direction.biz@59.163.21.131)
	by ns2.corpmailserver.com with ESMTPA; 7 Apr 2010 12:46:29 -0000
Received: from [172.16.2.20] ([172.16.2.20])
	(authenticated user s.borse@direction.biz)
	by direction.biz (direction.biz) (MDaemon PRO v9.0.0)
	with ESMTP id md50000973959.msg
	for <pgsql-admin@postgresql.org>; Wed, 07 Apr 2010 18:24:39 +0530
Subject: Handling of images via Postgressql
From: Suresh Borse <s.borse@direction.biz>
Reply-To: s.borse@direction.biz
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary="=-ao1qcOrDTPbsNvK2j78A"
Organization: DSS
Date: Wed, 07 Apr 2010 18:20:13 +0530
Message-Id: <1270644614.2390.44.camel@dss-052.dsslp.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.10.3 (2.10.3-9.fc7) 
X-Authenticated-Sender: s.borse@direction.biz
X-Spam-Processed: direction.biz, Wed, 07 Apr 2010 18:24:39 +0530
	(not processed: spam filter heuristic analysis disabled)
X-MDRemoteIP: 172.16.2.20
X-Return-Path: s.borse@direction.biz
X-MDaemon-Deliver-To: pgsql-admin@postgresql.org
X-MDAV-Processed: direction.biz, Wed, 07 Apr 2010 18:24:39 +0530
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201004/65
X-Sequence-Number: 34159


--=-ao1qcOrDTPbsNvK2j78A
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit



How does PostGreSQL perform in case we have to store and use huge no of
images:

 Eg 4000 – 10000 images, each approx 2 MB size.

 

The Questions that we have are:

How do we handle such huge no of images so that the application does not
slow down?

How does PostGreSQL use caching? In case of images does it cache?

Do you suggest having the images in a different database by itself?



Regards,

Suresh

--=-ao1qcOrDTPbsNvK2j78A
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.14.1">
</HEAD>
<BODY>
<BR>
<BR>
<FONT SIZE="2">How does PostGreSQL perform in case we have to store and use huge no of images:</FONT><BR>
<BR>
<FONT SIZE="2">&nbsp;Eg 4000 &#8211; 10000 images, each approx 2 MB size.</FONT><BR>
<BR>
<FONT SIZE="2">&nbsp;</FONT><BR>
<BR>
<FONT SIZE="2">The Questions that we have are:</FONT><BR>
<BR>
<FONT SIZE="2">How do we handle such huge no of images so that the application does not slow down?</FONT><BR>
<BR>
<FONT SIZE="2">How does PostGreSQL use caching? In case of images does it cache?</FONT><BR>
<BR>
<FONT SIZE="2">Do you suggest having the images in a different database by itself?</FONT><BR>
<BR>
<BR>
<BR>
<FONT SIZE="2">Regards,</FONT><BR>
<BR>
<FONT SIZE="2">Suresh</FONT>
</BODY>
</HTML>

--=-ao1qcOrDTPbsNvK2j78A--