Re: Two hard drives --- what to do with them? - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: Two hard drives --- what to do with them?
Date
Msg-id 20070301032846.GA14102@wolff.to
Whole thread Raw
In response to Re: Two hard drives --- what to do with them?  ("Peter Kovacs" <maxottovonstirlitz@gmail.com>)
List pgsql-performance
On Sun, Feb 25, 2007 at 23:11:01 +0100,
  Peter Kovacs <maxottovonstirlitz@gmail.com> wrote:
> A related question:
> Is it sufficient to disable write cache only on the disk where pg_xlog
> is located? Or should write cache be disabled on both disks?

With recent linux kernels you may also have the option to use write
barriers instead of disabling caching. You need to make sure all of
your stacked block devices will handle it and most versions of software
raid (other than 1) won't. This won't be a lot faster, since at sync
points the OS needs to order a cache flush, but it does give the disks a chance
to reorder some commands in between flushes.

pgsql-performance by date:

Previous
From: Carlos Moreno
Date:
Subject: Re: Upgraded to 8.2.3 --- still having performance issues
Next
From: Bruno Wolff III
Date:
Subject: Re: Two hard drives --- what to do with them?