On Sun, 23 Jun 2002, Hitesh wrote:
> We are building a distributed application where we need to support the
> database of around 50GB in size.
Postgres handles much much larger databases than that, so the size is
not an issue.
> Also there will be around 300 users connected to the system.
I have seen people here with 800 users connected to a system at once.
> The database server needs to be up 24/7.
Depends on your maintenance tasks. Quite frankly, running *any*
database system 24/7, with no time off for maintenance, is an
extremely expensive and difficult proposition.
> Also please suggest what kind of hardware (number of processors,
> RAM, etc.) will be needed to get a good speed of execution from the
> database?
> sorry for some vague parameters like speed and number of requests
> per sec.
Given the parameters you've stated, here are the ranges in which
the hardware you need is likely to reside:
CPU:
minimum: 133 MHz Pentium III
maximum: 8-way 2.4 GHz Xeon
Memory:
minimum: 64 MB
maximum: 8 GB
Disk:
minimum: one 3600 RPM IDE drive
maximum: EMC storage system with 256 x 36 GB 15000 RPM SCSI drives
So the server should cost somewhere between $500 and $12,000,00. (US dollars.)
cjs
--
Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
