Re: partition question for new server setup - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: partition question for new server setup
Date
Msg-id dcc563d10904281719o6eef8f53xa486a4073e442069@mail.gmail.com
Whole thread Raw
In response to Re: partition question for new server setup  (Scott Carey <scott@richrelevance.com>)
List pgsql-performance
On Tue, Apr 28, 2009 at 5:58 PM, Scott Carey <scott@richrelevance.com> wrote:

> 1.  If everything is on the same partition/file system, fsyncs from the
> xlogs may cross-pollute to the data.  Ext3 is notorious for this, though
> data=writeback limits the effect you especially might not want
> data=writeback on your OS partition.  I would recommend that the OS, Data,
> and xlogs + etc live on three different partitions regardless of the number
> of logical RAID volumes.

Note that I remember reading some comments a while back that just
having a different file system, on the same logical set, makes things
faster.  I.e. a partition for OS, one for xlog and one for pgdata on
the same large logical volume was noticeably faster than having it all
on the same big partition on a single logical volume.

pgsql-performance by date:

Previous
From: Whit Armstrong
Date:
Subject: Re: partition question for new server setup
Next
From: Scott Carey
Date:
Subject: Re: partition question for new server setup