Re: Simulating WAL on separate disks - Mailing list pgsql-general

From Guy Rouillier
Subject Re: Simulating WAL on separate disks
Date
Msg-id CC1CF380F4D70844B01D45982E671B2348E517@mtxexch01.add0.masergy.com
Whole thread Raw
In response to Simulating WAL on separate disks  ("Guy Rouillier" <guyr@masergy.com>)
Responses Re: Simulating WAL on separate disks
List pgsql-general
Tom Lane wrote:
>> Because we don't have separate disks for WAL in our test environment,
>> I'd like to minimize the effect of WAL.  I've read the sections in
>> both the tuning guide and the base documentation, and I'm still a
>> little unclear about fsync and wal_sync_method.  If I set fsync
>> FALSE, does this disable WAL entirely?
>
> No, but in any case it would entirely invalidate any performance
> testing you might do.  fsync off is a completely different regime of
> operation (unless perhaps you have hardly any updates).

Thanks, Tom.  This app has very high insert activity.  What's the best
way to minimize the effect of WAL given that we don't have separate
disks to put it on in our test environment?

--
Guy Rouillier


pgsql-general by date:

Previous
From: Brendan Jurd
Date:
Subject: Re: Function for retreiving datatype
Next
From: Tom Lane
Date:
Subject: Re: Simulating WAL on separate disks