Filesystem vs. Postgres for images

From: Michal Hlavac <hlavki(at)medium13(dot)sk>
To: pgsql-general(at)postgresql(dot)org
Subject: Filesystem vs. Postgres for images
Date: 2004-04-13 08:44:30
Message-ID: 407BA86E.4010904@medium13.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holger Klawitter 2004-04-13 09:11:11 verifying unicode locale support
Previous Message Richard Huxton 2004-04-13 08:37:01 Re: Executing script file