Re: High cpu usage after many inserts

From: Jordan Tomkinson <jordan(at)moodle(dot)com>
To: jd(at)commandprompt(dot)com
Cc: Aidan Van Dyk <aidan(at)highrise(dot)ca>, Greg Smith <gsmith(at)gregsmith(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: High cpu usage after many inserts
Date: 2009-02-25 00:44:59
Message-ID: 6de2f13b0902241644w1058ce88lbf28b87b74d81cd1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 25, 2009 at 9:23 AM, Joshua D. Drake <jd(at)commandprompt(dot)com>wrote:

>
> RAID5 outside of RAID 0 is the worst possible RAID level to run with a
> database. (of the commonly used raid level's that is).
>
> It is very, very slow on random writes which is what databases do.
> Switch to RAID 10.
>

surely being (real) hardware raid with 15k rpm disks this wouldn't be a huge
issue unless a large amount of data was being written ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-02-25 00:50:41 Re: High cpu usage after many inserts
Previous Message Greg Williamson 2009-02-25 00:29:00 Re: High cpu usage after many inserts