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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly