2010/1/15 Pierre Frédéric Caillaud <lists@peufeu.com>:
> On Thu, 14 Jan 2010 22:28:07 +0100, fkater@googlemail.com <fkater@googlemail.com> wrote:
>
>> Pierre Frédéric Caillaud:
>>
>>> > 4 Core CPU 3 Ghz, WinXP, 1 TB SATA disk.
>>>
>>> Big CPU and slow disk...
>>>
>>> You should add another disk just for the WAL -- disks are pretty cheap
>>> these days.
>>> Writing the WAL on a second disk is the first thing to do on a
>>> configuration like yours, if you are limited by writes.
>>> It also reduces the fsync lag a lot since the disk is only doing WAL.
>>
>> Good idea -- where can I set the path to WAL?
>
> At install, or use a symlink (they exist on windows too !...)
>
> http://stackoverflow.com/questions/1901405/postgresql-wal-on-windows
>
> I've no idea of the other needed NTFS tweaks, like if there is a noatime/nodiratime ?...
It does. See http://www.hagander.net/talks/Advanced%20PostgreSQL%20on%20Windows.pdf
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/