Re: best arrangement of 3 disks for (insert) performance - Mailing list pgsql-performance

From Matt Clark
Subject Re: best arrangement of 3 disks for (insert) performance
Date
Msg-id OAEAKHEHCMLBLIDGAFELCEFLDIAA.matt@ymogen.net
Whole thread Raw
In response to best arrangement of 3 disks for (insert) performance  (Richard Jones <rj@last.fm>)
List pgsql-performance
> the machine will be dealing with lots of inserts, basically as many as we can
> throw at it

If you mean lots of _transactions_ with few inserts per transaction you should get a RAID controller w/ battery backed
write-back
cache.  Nothing else will improve your write performance by nearly as much.  You could sell the RAM and one of the
CPU'sto pay for 
it ;-)

If you have lots of inserts but all in a few transactions then it's not quite so critical.

M



pgsql-performance by date:

Previous
From: Richard Jones
Date:
Subject: best arrangement of 3 disks for (insert) performance
Next
From: Jeff
Date:
Subject: software vs hw hard on linux