Re: How to make a REALLY FAST db server?

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: Raw Message | Whole Thread | 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

In response to

Browse pgsql-general by date

  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