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.