2010/1/15 Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>:
> On Thu, 14 Jan 2010 22:28:07 +0100, fkater(at)googlemail(dot)com <fkater(at)googlemail(dot)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 !...)
> 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
In response to
pgsql-performance by date
|Next:||From: Greg Smith||Date: 2010-01-15 05:46:26|
|Subject: Re: new server I/O setup|
|Previous:||From: Greg Smith||Date: 2010-01-15 05:17:15|
|Subject: Re: New server to improve performance on our large and
busy DB - advice?|