| From: | "Steve Wolfe" <steve(at)iboats(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to make a REALLY FAST db server? |
| Date: | 2001-09-11 15:53:01 |
| Message-ID: | 008101c13ad9$d6dff400$50824e40@iboats.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Tunning is somewhat of a black art to get the right balance. If you
have to
> make a choice, buy fewer processors, faster disks, and as much RAM as
the
> board will handle.
Wow. I'd buy more RAM and processors, and maybe skimp a *little* on the
disks. The RAID array in my machine is made up of some 9-gig Quantum
Atlas 4's that I bought for something like $80 each, far from being
state-of the art: But with all of the RAM, the disk lights only blink
*occasionally*. The number of drives makes up for the lower transfer rate
of each individual unit, and the disk cache (both on the controller and
from the kernel) make up for the latency.
steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-09-11 16:11:58 | Installation location of Perl and Python modules |
| Previous Message | Peter Eisentraut | 2001-09-11 15:05:06 | Re: Ridicolus Postgresql review |