Re: sustained update load of 1-2k/sec - Mailing list pgsql-performance

From Jeffrey W. Baker
Subject Re: sustained update load of 1-2k/sec
Date
Msg-id 1124469284.29778.4.camel@toonses.gghcwest.com
Whole thread Raw
In response to Re: sustained update load of 1-2k/sec  (Ron <rjpeace@earthlink.net>)
Responses Re: sustained update load of 1-2k/sec
List pgsql-performance
On Fri, 2005-08-19 at 10:54 -0400, Ron wrote:
> Maxtor Atlas 15K II's.

> Areca's 1GB buffer RAID cards

The former are SCSI disks and the latter is an SATA controller.  The
combination would have a transaction rate of approximately 0.

I can vouch for the Areca controllers, however.  You can certainly
achieve pgbench transaction rates in the hundreds per second even with
only 5 7200RPM disks and 128MB cache.

Don't forget to buy the battery.

-jwb

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: LEFT JOIN ON vs. LEFT JOIN USING performance
Next
From: Jeremiah Jahn
Date:
Subject: Re: extremly low memory usage