Re: hardware for a server - Mailing list pgsql-general

From Bruce Momjian
Subject Re: hardware for a server
Date
Msg-id 201003161427.o2GERJN15000@momjian.us
Whole thread Raw
In response to Re: hardware for a server  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Greg Smith wrote:
> Bruce Momjian wrote:
> > Greg Smith wrote:
> >
> >> Given what you've said about your budget here, I suspect that you're
> >> heading toward either 3ware or LSI and all SATA drives.  I wouldn't
> >> expect that big of a performance difference between the two with only 8
> >> drives on there.  If you had 24, the 3ware controller would likely turn
> >> into the bottleneck, and if this was an all SAS system the LSI one would
> >> also be the only sensible choice.  (Make sure you get the right battery
> >> included with whatever controller you pick)
> >>
> >
> > Is this documented somewhere, like on our wiki?  It seems we have a
> > clear consensus on this and we should document this.
> >
>
> The documentation we do have on the wiki in this area is out of date:
> http://wiki.postgresql.org/wiki/SCSI_vs._IDE/SATA_Disks
>
> I just finished testing a bunch of LSI card recently enough that I
> haven't gotten to fixing the outdated info on there yet about that company.

I am thinking we should point to that wiki from our official docs so
people find that information easily.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do

pgsql-general by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Re: UPDATE with JOIN not using index
Next
From: Richard Huxton
Date:
Subject: Re: UPDATE with JOIN not using index