Re: Simulating WAL on separate disks
От | Guy Rouillier |
---|---|
Тема | Re: Simulating WAL on separate disks |
Дата | |
Msg-id | CC1CF380F4D70844B01D45982E671B2348E517@mtxexch01.add0.masergy.com обсуждение исходный текст |
Ответ на | Simulating WAL on separate disks ("Guy Rouillier" <guyr@masergy.com>) |
Ответы |
Re: Simulating WAL on separate disks
|
Список | 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 по дате отправления: