how to determine the hardware I need

From: raphael(at)be(dot)easynet(dot)net
To: pgsql-admin(at)postgresql(dot)org
Subject: how to determine the hardware I need
Date: 2002-08-24 09:23:58
Message-ID: 20020824092358.GA10975@raphael
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I need to determine the hardware I need to host a postgresql database.
The problem is, I have to make some guess on the number of tables,
records/table, etc as it is a new website that will be launched. Needs
will evolve, and hardware has to be prepared.
The other problem is I don't know how to evaluate hardware needs based
on assumptions about the number of tables, rows/tables, number of
queries/day, ....

I browsed the history of the ML, but I didn't see an answer to this
question: how does one evaluate the hardware needed?
>From my readings, I have this idea:

RAM is important, but how do I evaluate how much RAM I need?
Putting logs on a different disk than data is important.
RAID: doesn't give a performance boost, but increases reliability.
CPU power isn't that important.
SCSI can be more reliable in extreme circonstances, but IDE does a good
job also.

Remaining questions, knowing that Apache will run on the same computer:
-How do I evaluate how much RAMI need?
-idem CPU. is a dual CPU an advantage?
-how much space will the database take?

If you have good pointers to documentation, it would be very helpful
too!

Thanks for your help!

Raph

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-08-25 23:45:49 Re: Backup and Recovery (revisited)
Previous Message Bhuvan A 2002-08-24 05:11:44 Re: Preserving datatypes in dblink.