Re: Hardware recommendation: which is best

From: Franz(dot)Rasper(at)izb(dot)de
To: gsmith(at)gregsmith(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Hardware recommendation: which is best
Date: 2007-09-11 16:08:24
Message-ID: 11EC9A592C31034C88965C87AF18C2A702B8369F@m0000s61
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>The point people are trying to make to you is that the differences between
>RAID controllers can be as big as that between RAID architectures in cases
>like yours. Which controller you're using and how the cache is setup can
>have a larger impact on INSERT performance than how many/what type of
>disks are involved. If you've comparing a fast SAS controller to a slow
>SATA2 one, than the SAS setup may very well run faster no matter how many
>disks the SATA2 one has. Conversely, it's not unheard of to have a SAS
>controller with such miserable operating system drivers that there is no
>performance advantage to using faster SCSI disks instead of SATA2.

>You're not going to get a particularly useful answer here without giving
>some specifics about the two disk controllers you're comparing, how much
>cache they have, and whether they include a battery backup.

Exactly, thats the point.

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo De León 2007-09-11 16:10:49 Re: avg() of array values
Previous Message David Fetter 2007-09-11 16:03:53 Re: Question about a query with two count fields