Re: sustained update load of 1-2k/sec

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: Ron <rjpeace(at)earthlink(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: sustained update load of 1-2k/sec
Date: 2005-08-19 16:34:44
Message-ID: 1124469284.29778.4.camel@toonses.gghcwest.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeremiah Jahn 2005-08-19 16:48:29 Re: extremly low memory usage
Previous Message John A Meinel 2005-08-19 15:40:59 Re: LEFT JOIN ON vs. LEFT JOIN USING performance