Simulating WAL on separate disks

Поиск
Список
Период
Сортировка
От Guy Rouillier
Тема Simulating WAL on separate disks
Дата
Msg-id CC1CF380F4D70844B01D45982E671B2348E516@mtxexch01.add0.masergy.com
обсуждение исходный текст
Ответы Re: Simulating WAL on separate disks  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Simulating WAL on separate disks  (Alex Turner <armtuk@gmail.com>)
Список pgsql-general
We are soon to be doing performance testing.  Our testing environment
contains 4 SCSI disks in a RAID5 configuration, while our production
environment will have 6 SCSI disks, which I'm suggesting we allocate as
4 in RAID5 for data and 2 in RAID1 for WAL.

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?

--
Guy Rouillier


В списке pgsql-general по дате отправления:

Предыдущее
От: Daniel Schuchardt
Дата:
Сообщение: Re: PostgreSQL 8 on windows very slow
Следующее
От: Jamie Deppeler
Дата:
Сообщение: Re: PostgreSQL 8 on windows very slow