Re: Inserting 8MB bytea: just 25% of disk perf used? - Mailing list pgsql-performance

From fkater@googlemail.com
Subject Re: Inserting 8MB bytea: just 25% of disk perf used?
Date
Msg-id 20100114212807.GF2384@comppasch2
Whole thread Raw
In response to Re: Inserting 8MB bytea: just 25% of disk perf used?  (Pierre Frédéric Caillaud<lists@peufeu.com>)
Responses Re: Inserting 8MB bytea: just 25% of disk perf used?
List pgsql-performance
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



pgsql-performance by date:

Previous
From: "fkater@googlemail.com"
Date:
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Next
From: "Fernando Hevia"
Date:
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?