I am working on web portal. There are some ads. We have about 200 000 ads. Every ad have own directory called ID, where is 5 subdirectories with various sizes of 5 images.
Filesystem is too slow. But I don't know, if I store these images into postgres, performace will grow.
Second question is, what kind of hardware I need for storing in DB. Now I have Intel(R) Pentium(R) 4 CPU 1.70GHz with 512MB RAM and 120GB HDD.
thanx for advices...
miso
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings