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
