Re: Simulating WAL on separate disks

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