Re: 3 x PostgreSQL in cluster/redunant

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Michelle Konzack <linux4michelle(at)freenet(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 3 x PostgreSQL in cluster/redunant
Date: 2005-11-15 20:06:20
Message-ID: 437A3FBC.5050905@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michelle Konzack wrote:
> Am 2005-11-14 16:54:41, schrieb Jim C. Nasby:
>
>> On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote:
>>
>>> Hello *,
>>>
>>> I have three Sun Server where I have reserved on each Server a Raid-5
>>> of 1 TByte for my PostgreSQL. The first PostgreSQL is up and running
>>> with a database of 150 GByte.
>>>
>> Keep in mind that databases and RAID5 generally don't mix very well.
>>
>
> Can you explain me why?
>
RAID 5 is very expensive for writes.

> Unfortunatly the Controllers in the three SUN-Servers do not support
> 300 GByte SCSI-Drives, so I have to continue with the Raid-5 of 16x
> 76 GByte.
>
Could you do RAID 10?

Sincerely,

Joshua D. Drake

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2005-11-15 20:06:42 Re: PREPARE TRANSACTION and webapps
Previous Message Jim C. Nasby 2005-11-15 20:04:01 Re: ablilty to test record for foreign key before deleting the record?