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
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. |