Raid and tablespaces configuration

Started by Himanshu Bawejaalmost 21 years ago3 messagesgeneral
Jump to latest
#1Himanshu Baweja
himanshubaweja@yahoo.com

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

#2Doug McNaught
doug@mcnaught.org
In reply to: Himanshu Baweja (#1)
Re: Raid and tablespaces configuration

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

#3Ben-Nes Michael
miki@canaan.co.il
In reply to: Himanshu Baweja (#1)
Re: Raid and tablespaces configuration

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