Re: best arrangement of 3 disks for (insert) performance

From: "Matt Clark" <matt(at)ymogen(dot)net>
To: <rj(at)last(dot)fm>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: best arrangement of 3 disks for (insert) performance
Date: 2003-09-12 11:06:12
Message-ID: OAEAKHEHCMLBLIDGAFELCEFLDIAA.matt@ymogen.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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's to pay for
it ;-)

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

M

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jose-Lopes Antunes 2003-09-12 11:35:54 Space
Previous Message Richard Jones 2003-09-12 10:26:29 best arrangement of 3 disks for (insert) performance

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff 2003-09-12 14:34:26 software vs hw hard on linux
Previous Message Richard Jones 2003-09-12 10:26:29 best arrangement of 3 disks for (insert) performance