Re: Weird XFS WAL problem

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Weird XFS WAL problem
Date: 2010-06-02 23:40:49
Message-ID: 4C06EC01.3060506@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 03/06/10 11:30, Craig James wrote:
> I'm testing/tuning a new midsize server and ran into an inexplicable
> problem. With an RAID10 drive, when I move the WAL to a separate
> RAID1 drive, TPS drops from over 1200 to less than 90! I've checked
> everything and can't find a reason.
>
>

Are the 2 new RAID1 disks the same make and model as the 12 RAID10 ones?

Also, are barriers *on* on the RAID1 mount and off on the RAID10 one?

Cheers

Mark

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bob Lunney 2010-06-03 01:26:56 Re: requested shared memory size overflows size_t
Previous Message Craig James 2010-06-02 23:30:28 Weird XFS WAL problem