pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gábriel Ákos <akos.gabriel@i-logic.hu>
To: Francisco Reyes <lists@stringsutils.com>
Cc: Michael Stone <mstone+postgres@mathom.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Inserts optimization?
Date: Sat, 15 Apr 2006 10:32:56 +0200
Message-ID: <4440AFB8.4080806@i-logic.hu> (raw)
In-Reply-To: <cone.1145037716.354055.283.5001@35st-server.simplicato.com>
References: <cone.1144888738.434948.92126.5001@35st-server.simplicato.com>
	<443DA715.4060606@gmail.com>
	<9549.1144903344@sss.pgh.pa.us>
	<cone.1144954763.735087.95544.5001@35st-server.simplicato.com>
	<20060414055923.GX49405@pervasive.com>
	<cone.1145014225.784898.23930.1000@zoraida.natserv.net>
	<20060414114911.GG32678@mathom.us>
	<cone.1145037716.354055.283.5001@35st-server.simplicato.com>

Francisco Reyes wrote:

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

you are right. raid5 is definitely not suitable for database activities.
it is good for file servers, though.

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



view thread (39+ messages)  latest in thread

Message-ID: <4440AFB8.4080806@i-logic.hu>
Permalink:  ../4440AFB8.4080806@i-logic.hu/
Also on:    postgresql.org/message-id/4440AFB8.4080806@i-logic.hu

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: akos.gabriel@i-logic.hu, lists@stringsutils.com, mstone+postgres@mathom.us
  Subject: Re: Inserts optimization?
  In-Reply-To: <4440AFB8.4080806@i-logic.hu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox