Re: Postgresql Hardware

In response to Vick Khera <vivek@khera.org>:

> On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk <gil.nunes.resende@gmail.com> wrote:
>
> > What HW is more important to postgresql performance?
> > Assuming that the database will have some load, what hardware must i
> > buy?
>
>
> Generally, you put as much RAM as you can afford, and then buy the
> fastest disks you can afford.

More specifically, for high loads, get fast SCSI or SAS disks, directly
attached, and arrange them in a RAID-10.

Whether or not such a setup is overkill (sometimes it is) depends on
how much load you're really generating.  But (as Vick stated) DB servers
are usually bottlenecked on how fast they can access the disks, not RAM
or CPU.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/