Thread: Raid and tablespaces configuration

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....

Regards
Himanshu




__________________________________
Do you Yahoo!?
Make Yahoo! your home page
http://www.yahoo.com/r/hs

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

You sure there are 5 HD ?

Raid 10 suppose to have 4 HD

Raid 0 suppose to have 2 HD


Total of 6 ??


Any way Raid 0 is fast but give no reability. i prefer raid 1 or 10.


Himanshu Baweja wrote:

>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....
>
>Regards
>Himanshu
>
>
>
>
>__________________________________
>Do you Yahoo!?
>Make Yahoo! your home page
>http://www.yahoo.com/r/hs
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>

--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Cel: 972-52-8555757
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------