Search Postgresql Archives

Re: Hardware recommendation: which is best

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 11 Sep 2007, Phoenix Kiula wrote:

I'll have a raid controller in both scenarios, but which RAID should
be better: RAID1 or RAID10?

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.

--
* Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux