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: 9837222c1001142138m3a1d9aa0q215fd52751af2d39@mail.gmail.com (view raw or flat)
Thread:
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 !...)
>
>        http://stackoverflow.com/questions/1901405/postgresql-wal-on-windows
>
>        I've no idea of the other needed NTFS tweaks, like if there is a noatime/nodiratime ?...

It does. See http://www.hagander.net/talks/Advanced%20PostgreSQL%20on%20Windows.pdf


-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

Responses

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-2014 The PostgreSQL Global Development Group