[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Tablespaces on a raid configuration
From:       Aidan Van Dyk <aidan () highrise ! ca>
Date:       2012-03-31 13:42:49
Message-ID: CAC_2qU-DrOZSV3gVfZnqdVQ3TWo-pbD3SuCYKessNHaWs0LVKg () mail ! gmail ! com
[Download RAW message or body]

On Fri, Mar 30, 2012 at 9:32 PM, Tomas Vondra <tv@fuzzy.cz> wrote:

> And it's not just about fsync operations - WAL is written in sequential
> manner. By placing it on the same device as data files you're
> effectively forcing it to be written randomly, because the the database
> has to write a WAL record, seeks somewhere else to read something, etc.

Or, if you put WAL on a journalled FS, even if it's on dedicated spindles ;-)

a.
-- 
Aidan Van Dyk                                                                   Create like a god,
aidan@highrise.ca                                                          command like a king,
http://www.highrise.ca/                                                    work like a slave.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]