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