Re: Raid and tablespaces configuration

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: Himanshu Baweja <himanshubaweja(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Raid and tablespaces configuration
Date: 2005-06-24 12:58:16
Message-ID: m27jgjc3o7.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> writes:

> Currently my server has two raid controllers both with
> 5 disks attached::
> On raid1: i have the database (RAID 1/0)
> on raid2: i have the pg_xlog (RAID 0)
>
> is this the optimal configuration or do i need to make
> some changes for better performance....

pg_xlog is basically write-only during normal use, so you might want
to use RAID1 or RAID0+1 rather than RAID5, which has slow write
performance.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-06-24 13:31:47 Re: Problem with catching my own exception messages.
Previous Message Douglas McNaught 2005-06-24 12:50:29 Re: Postgres 8.0 windows processes, field testing, and Hibernate