From: Greg Smith <gsmith@gregsmith.com>
To: Henrik <henke@mac.se>
Cc: pgsql-performance@postgresql.org
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
Date: Fri, 8 Aug 2008 18:47:03 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0808081835320.21924@westnet.com> (raw)
In-Reply-To: <32A7A76B-16CA-4CDB-AD43-973AD6A3FC7B@mac.se>
References: <32A7A76B-16CA-4CDB-AD43-973AD6A3FC7B@mac.se>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsmith@gregsmith.com, henke@mac.se
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
In-Reply-To: <Pine.GSO.4.64.0808081835320.21924@westnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox