Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 0E6A6634DAC
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  7 Apr 2010 13:21:45 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 81354-04-6
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  7 Apr 2010 16:21:34 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web39702.mail.mud.yahoo.com (web39702.mail.mud.yahoo.com
	[209.191.106.48])
	by mail.postgresql.org (Postfix) with SMTP id C154C634A2F
	for <pgsql-admin@postgresql.org>; Wed,  7 Apr 2010 13:21:29 -0300 (ADT)
Received: (qmail 22329 invoked by uid 60001); 7 Apr 2010 16:21:28 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1270657288; bh=bsGWEm4SzQMt1/gXJPoIyxZvHKACoQuJFhbi0qve9VU=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=0+PKUorQlhqisFPhTqAREMihPJc44/ilsvuwZibRmjhZbd70xPX51VMpTjVdGLlP24Pk+Ql1ner6dOMws5d884B8KVSUD/ZtS86cEDTcK6L7Dpla2JPzCwoIlXJnsrDAdso4Nu0rGqVtueR0b1Svpn9Kioybv08P8RU0wY90hyc=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=hWH+EtePn4xYzrl/XD2yhKOq8uC1TNQCQf39Ev7wRH54DVref2zHFOipyYL7Kt4OrTv68giS/uB14tBFiVcpk5+/sdBKYqqLxn31EPnqNusdWFvJbosfawMfbFTcrbTsfwc1K45nnrtHdPfGXKmTOPxDSgKn9fUJ32Ya/+nAPz0=;
Message-ID: <333114.22026.qm@web39702.mail.mud.yahoo.com>
X-YMail-OSG: TqnGLUAVM1nYUB53IluwdqugLGKBiIO9PdCz.M0xoLEjANc
	WDGzlXbSCDMTvQ3RN6pXNGSeWEAQlk0kuSUcqVk5tbeZvh48cwdiJE0BTIVb
	ekanm2iqLqZQRpnd0hXHoac4.xes8dKHvGuTV4zsF5KpERtAxZo_rXMnAtc1
	TZnWrZTITR5oEIY99GIPPLyrMsX43CoGdcwnBbkDK7NLoXSiNUzB8VX61acG
	pegGVpNgEOZ0dQGrVgvA4tlIpaotgH8Dtacdd1szvuOWRPa1alLsGRyPXARU
	558lenOI3kY_az04tZj6wNY3N2RKgPJibEFtEddVXn9lpdt5WRLtRT844iMT
	ims6yK8warlan3ARuW9QoszVjQwsKuqTu
Received: from [64.126.29.122] by web39702.mail.mud.yahoo.com via HTTP;
	Wed, 07 Apr 2010 09:21:28 PDT
X-Mailer: YahooMailClassic/10.0.8 YahooMailWebService/0.8.100.260964
Date: Wed, 7 Apr 2010 09:21:28 -0700 (PDT)
From: Bob Lunney <bob_lunney@yahoo.com>
Subject: Re: Handling of images via Postgressql
To: pgsql-admin@postgresql.org
In-Reply-To: <1270644614.2390.44.camel@dss-052.dsslp.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1407091019-1270657288=:22026"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.184 tagged_above=-10 required=5
	tests=BAYES_40=-0.185, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201004/68
X-Sequence-Number: 34162

--0-1407091019-1270657288=:22026
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Suresh,
The real question is: =C2=A0does manipulation of the images have to be tran=
sactional? =C2=A0If so, store them in the database. =C2=A0If not, store the=
 images in the file system and put the file name in the database, thereby a=
voiding unecessary WAL overhead.
Bob Lunney

--- On Wed, 4/7/10, Suresh Borse <s.borse@direction.biz> wrote:

From: Suresh Borse <s.borse@direction.biz>
Subject: [ADMIN] Handling of images via Postgressql
To: pgsql-admin@postgresql.org
Date: Wednesday, April 7, 2010, 8:50 AM

=0A=0A=0A  =0A  =0A=0A =0A
=0A
=0AHow does PostGreSQL perform in case we have to store and use huge no of =
images:
=0A
=0A=C2=A0Eg 4000 =E2=80=93 10000 images, each approx 2 MB size.
=0A
=0A=C2=A0
=0A
=0AThe Questions that we have are:
=0A
=0AHow do we handle such huge no of images so that the application does not=
 slow down?
=0A
=0AHow does PostGreSQL use caching? In case of images does it cache?
=0A
=0ADo you suggest having the images in a different database by itself?
=0A
=0A
=0A
=0ARegards,
=0A
=0ASuresh=0A =0A=0A=0A=0A=0A      
--0-1407091019-1270657288=:22026
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">Suresh,<div><br></div><div>The real question =
is: &nbsp;does manipulation of the images have to be transactional? &nbsp;I=
f so, store them in the database. &nbsp;If not, store the images in the fil=
e system and put the file name in the database, thereby avoiding unecessary=
 WAL overhead.<div><br></div><div>Bob Lunney<br><br>--- On <b>Wed, 4/7/10, =
Suresh Borse <i>&lt;s.borse@direction.biz&gt;</i></b> wrote:<br><blockquote=
 style=3D"border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; paddin=
g-left: 5px;"><br>From: Suresh Borse &lt;s.borse@direction.biz&gt;<br>Subje=
ct: [ADMIN] Handling of images via Postgressql<br>To: pgsql-admin@postgresq=
l.org<br>Date: Wednesday, April 7, 2010, 8:50 AM<br><br><div id=3D"yiv12133=
55121">=0A=0A=0A  =0A  =0A=0A =0A<br>=0A<br>=0A<font size=3D"2">How does Po=
stGreSQL perform in case we have to store and use huge no of images:</font>=
<br>=0A<br>=0A<font size=3D"2">&nbsp;Eg 4000 =E2=80=93 10000 images, each a=
pprox 2 MB size.</font><br>=0A<br>=0A<font size=3D"2">&nbsp;</font><br>=0A<=
br>=0A<font size=3D"2">The Questions that we have are:</font><br>=0A<br>=0A=
<font size=3D"2">How do we handle such huge no of images so that the applic=
ation does not slow down?</font><br>=0A<br>=0A<font size=3D"2">How does Pos=
tGreSQL use caching? In case of images does it cache?</font><br>=0A<br>=0A<=
font size=3D"2">Do you suggest having the images in a different database by=
 itself?</font><br>=0A<br>=0A<br>=0A<br>=0A<font size=3D"2">Regards,</font>=
<br>=0A<br>=0A<font size=3D"2">Suresh</font>=0A =0A=0A</div></blockquote></=
div></div></td></tr></table><br>=0A=0A      
--0-1407091019-1270657288=:22026--