On Thu, 14 Jan 2010 22:28:07 +0100, fka...@googlemail.com
<fka...@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 ?...
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance