2010/1/15 Pierre Frédéric Caillaud <lists@xxxxxxxxxx>: > On Thu, 14 Jan 2010 22:28:07 +0100, fkater@xxxxxxxxxxxxxx <fkater@xxxxxxxxxxxxxx> 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/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
