Handling of images via Postgressql

From: Suresh Borse <s(dot)borse(at)direction(dot)biz>
To: pgsql-admin(at)postgresql(dot)org
Subject: Handling of images via Postgressql
Date: 2010-04-07 12:50:13
Message-ID: 1270644614.2390.44.camel@dss-052.dsslp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Renato Oliveira 2010-04-07 13:30:09 turn pitr 'on' on PostgreSQL 8.2 - pg_standby
Previous Message Michael Gould 2010-04-07 12:25:52 Re: Database level encryption