Re: Inserting 8MB bytea: just 25% of disk perf used?

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?

 Felix