Re: Raid and tablespaces configuration - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Raid and tablespaces configuration
Date
Msg-id m27jgjc3o7.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to Raid and tablespaces configuration  (Himanshu Baweja <himanshubaweja@yahoo.com>)
List pgsql-general
Himanshu Baweja <himanshubaweja@yahoo.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

pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: Postgres 8.0 windows processes, field testing, and Hibernate
Next
From: "mrix"
Date:
Subject: Re: multi-languages in a table