On 06/16/2014 08:10 PM, sunpeng wrote:
We have many small size(most fixed size) images, how to store them? There are 
two options:
1. Store images in folders, managed by os file system, only store path in 
postgresql
2. Store image as bytea in postgresql
How do you usually store images?
Thanks!

peng

I think it depends on how you are going to use them.  I, for example, have lots 
of images that are served on a web page, after benchmarks I found it was faster 
to store them on filesystem and let apache serve them directly.

-Andy


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to