Re: Inserts optimization?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Michael Stone <mstone+postgres(at)mathom(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Inserts optimization?
Date: 2006-04-14 18:01:56
Message-ID: cone.1145037716.354055.283.5001@35st-server.simplicato.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Michael Stone writes:

> I guess the first question is why 2 hot spares?

Because we are using RAID 10

> larger array with more spindles with outperform a smaller one with
> fewer, regardless of RAID level (assuming a decent battery-backed
> cache).

Based on what I have read RAID 10 is supposed to be better with lots of
random access.

> 5 RAID5
> 2 RAID1
> 1 spare

That is certainly something worth considering... Still I wonder if 2 more
spindles will help enough to justify going to RAID 5. My understanding is
that RAID10 has simpler computations requirements which is partly what makes
it better for lots of random read/write.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2006-04-14 19:01:25 Re: bad performance on Solaris 10
Previous Message Christian Storm 2006-04-14 18:01:10 Re: pgmemcache