Re: postgresql to support 50GB of data?

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