On Fri, Mar 30, 2012 at 9:32 PM, Tomas Vondra <[email protected]> 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, [email protected] command like a king, http://www.highrise.ca/ work like a slave. -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
