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
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
