Re: Tablespaces on a raid configuration

[Aidan Van Dyk <aidan@xxxxxxxxxxx>]

On Fri, Mar 30, 2012 at 9:32 PM, Tomas Vondra <tv@xxxxxxxx> 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@xxxxxxxxxxx                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance