Simulating WAL on separate disks

From: "Guy Rouillier" <guyr(at)masergy(dot)com>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Simulating WAL on separate disks
Date: 2005-01-10 23:33:51
Message-ID: CC1CF380F4D70844B01D45982E671B2348E516@mtxexch01.add0.masergy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Smith 2005-01-10 23:42:14 Re: to_char(0,'9999.99') -> ".00"
Previous Message Daniel Schuchardt 2005-01-10 22:55:45 Re: PostgreSQL 8 on windows very slow