From: Suresh Borse <s.borse@direction.biz>
To: pgsql-admin@postgresql.org
Subject: Handling of images via Postgressql
Date: Wed, 07 Apr 2010 18:20:13 +0530
Message-ID: <1270644614.2390.44.camel@dss-052.dsslp.com> (raw)
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
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: s.borse@direction.biz
Subject: Re: Handling of images via Postgressql
In-Reply-To: <1270644614.2390.44.camel@dss-052.dsslp.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