Re: Filesystem benchmarking for pg 8.3.3 server - Mailing list pgsql-performance

From Greg Smith
Subject Re: Filesystem benchmarking for pg 8.3.3 server
Date
Msg-id Pine.GSO.4.64.0808081835320.21924@westnet.com
Whole thread Raw
In response to Filesystem benchmarking for pg 8.3.3 server  (Henrik <henke@mac.se>)
Responses Re: Filesystem benchmarking for pg 8.3.3 server
Re: Filesystem benchmarking for pg 8.3.3 server
List pgsql-performance
On Fri, 8 Aug 2008, Henrik wrote:

> It feels like there is something fishy going on. Maybe the RAID 10
> implementation on the PERC/6e is crap?

Normally, when a SATA implementation is running significantly faster than
a SAS one, it's because there's some write cache in the SATA disks turned
on (which they usually are unless you go out of your way to disable them).
Since all non-battery backed caches need to get turned off for reliable
database use, you might want to double-check that on the controller that's
driving the SATA disks.

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

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Filesystem setup on new system
Next
From: david@lang.hm
Date:
Subject: Re: Filesystem benchmarking for pg 8.3.3 server