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

From Ron
Subject Re: sustained update load of 1-2k/sec
Date
Msg-id 6.2.3.4.0.20050819105751.05c1a760@pop.earthlink.net
Whole thread Raw
In response to Re: sustained update load of 1-2k/sec  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-performance
At 09:58 AM 8/19/2005, Andreas Pflug wrote:

>The 1-2k xact/sec for MySQL seems suspicious, sounds very much like
>write-back cached, not write-through, esp. considering that heavy
>concurrent write access isn't said to be MySQLs strength...

Don't be suspicious.

I haven't seen the code under discussion, but I have seen mySQL
easily achieve these kinds of numbers using the myISAM storage engine
in write-through cache
mode.

myISAM can be =FAST=.  Particularly when decent HW is thrown at it.

Ron



pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: sustained update load of 1-2k/sec
Next
From: Jeremiah Jahn
Date:
Subject: Re: I'm configuraing a new system (Bigish) and need some