Re: Weird XFS WAL problem - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Weird XFS WAL problem
Date
Msg-id 4C06EC01.3060506@catalyst.net.nz
Whole thread Raw
In response to Weird XFS WAL problem  (Craig James <craig_james@emolecules.com>)
Responses Re: Weird XFS WAL problem  (Craig James <craig_james@emolecules.com>)
List 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


pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Weird XFS WAL problem
Next
From: Bob Lunney
Date:
Subject: Re: requested shared memory size overflows size_t