From: Robert Gravsjö <tekniksupport@blogg.se>
To: s.borse@direction.biz
Cc: pgsql-admin@postgresql.org
Subject: Re: Handling of images via Postgressql
Date: Wed, 07 Apr 2010 16:01:04 +0200
Message-ID: <4BBC9020.8090209@blogg.se> (raw)
In-Reply-To: <1270644614.2390.44.camel@dss-052.dsslp.com>
References: <1270644614.2390.44.camel@dss-052.dsslp.com>
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
>
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-admin@postgresql.org
Cc: tekniksupport@blogg.se, s.borse@direction.biz
Subject: Re: Handling of images via Postgressql
In-Reply-To: <4BBC9020.8090209@blogg.se>
* 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