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

From: "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>
To: Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Date: 2010-01-14 21:28:07
Message-ID: 20100114212807.GF2384@comppasch2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Fernando Hevia 2010-01-14 21:33:11 Re: Inserting 8MB bytea: just 25% of disk perf used?
Previous Message fkater@googlemail.com 2010-01-14 21:27:19 Re: Inserting 8MB bytea: just 25% of disk perf used?