Skip site navigation (1) Skip section navigation (2)

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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>
Cc: "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Date: 2010-01-15 05:38:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
2010/1/15 Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>:
> On Thu, 14 Jan 2010 22:28:07 +0100, fkater(at)googlemail(dot)com <fkater(at)googlemail(dot)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 !...)
>        I've no idea of the other needed NTFS tweaks, like if there is a noatime/nodiratime ?...

It does. See

 Magnus Hagander

In response to


pgsql-performance by date

Next:From: Greg SmithDate: 2010-01-15 05:46:26
Subject: Re: new server I/O setup
Previous:From: Greg SmithDate: 2010-01-15 05:17:15
Subject: Re: New server to improve performance on our large and busy DB - advice?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group