Postgres Pro
Downloads
Home   >   mailing lists

Re: High cpu usage after many inserts - Mailing list pgsql-general

From Jordan Tomkinson
Subject Re: High cpu usage after many inserts
Date
Msg-id 6de2f13b0902241644w1058ce88lbf28b87b74d81cd1@mail.gmail.com
Whole thread Raw
In response to Re: High cpu usage after many inserts  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: High cpu usage after many inserts
List pgsql-general
Tree view


On Wed, Feb 25, 2009 at 9:23 AM, Joshua D. Drake <jd@commandprompt.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 ?

pgsql-general by date:

Previous
From: Greg Williamson
Date:
Subject: Re: High cpu usage after many inserts
Next
From: Scott Marlowe
Date:
Subject: Re: High cpu usage after many inserts