In response to Vick Khera <vi...@khera.org>: > On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk <gil.nunes.rese...@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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
