how to determine the hardware I need
От | raphael@be.easynet.net |
---|---|
Тема | how to determine the hardware I need |
Дата | |
Msg-id | 20020824092358.GA10975@raphael обсуждение исходный текст |
Ответы |
Re: how to determine the hardware I need
|
Список | 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
В списке pgsql-admin по дате отправления: