Message-ID: <4BBC9020.8090209@blogg.se>
Date: Wed, 07 Apr 2010 16:01:04 +0200
From: =?UTF-8?B?Um9iZXJ0IEdyYXZzasO2?= <tekniksupport@blogg.se>
Reply-To: robert@blogg.se
Organization: Blogg Esse AB
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; sv-SE;
	rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
To: s.borse@direction.biz
CC: pgsql-admin@postgresql.org
Subject: Re: Handling of images via Postgressql
References: <1270644614.2390.44.camel@dss-052.dsslp.com>
In-Reply-To: <1270644614.2390.44.camel@dss-052.dsslp.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit


Suresh Borse skrev 2010-04-07 14.50:
>
>
> 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?

I'd suggest storing meta information in PostgreSQL and the images in the 
filesystem.

Regards,
roppert

>
>
>
> Regards,
>
> Suresh
>