Postgres Pro
Downloads
Home   >   mailing lists

Handling of images via Postgressql - Mailing list pgsql-admin

From Suresh Borse
Subject Handling of images via Postgressql
Date
Msg-id 1270644614.2390.44.camel@dss-052.dsslp.com
Whole thread Raw
Responses Re: Handling of images via Postgressql  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Handling of images via Postgressql  (Bob Lunney <bob_lunney@yahoo.com>)
Re: Handling of images via Postgressql  (Robert Gravsjö <tekniksupport@blogg.se>)
List pgsql-admin
Tree view


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

pgsql-admin by date:

Previous
From: Michael Gould
Date:
Subject: Re: Database level encryption
Next
From: Renato Oliveira
Date:
Subject: turn pitr 'on' on PostgreSQL 8.2 - pg_standby