Re: Inserts optimization?

From: Gábriel Ákos <akos(dot)gabriel(at)i-logic(dot)hu>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: Michael Stone <mstone+postgres(at)mathom(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Inserts optimization?
Date: 2006-04-15 08:35:41
Message-ID: 4440B05D.8070002@i-logic.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Francisco Reyes wrote:
> Michael Stone writes:
>
>> I still don't follow that. Why would the RAID level matter? IOW, are
>> you actually wanting 2 spares, or are you just stick with that because
>> you need a factor of two disks for your mirrors?
>
> RAID 10 needs pairs.. so we can either have no spares or 2 spares.

hm, interesting. I have recently set up a HP machine with smartarray 6i
controller, and it is able to handle 4 disks in raid10 plus 1 as spare.
with some scripting you can even use linux software raid in the same setup.

--
Üdvözlettel,
Gábriel Ákos
-=E-Mail :akos(dot)gabriel(at)i-logic(dot)hu|Web: http://www.i-logic.hu=-
-=Tel/fax:+3612367353 |Mobil:+36209278894 =-

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Francisco Reyes 2006-04-15 13:16:15 Re: Inserts optimization?
Previous Message Gábriel Ákos 2006-04-15 08:32:56 Re: Inserts optimization?