Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-performance by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group