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.
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 |