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

From: Ron <rjpeace(at)earthlink(dot)net>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: sustained update load of 1-2k/sec
Date: 2005-08-19 15:03:54
Message-ID: 6.2.3.4.0.20050819105751.05c1a760@pop.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Diego de Lima 2005-08-19 15:22:35 LEFT JOIN ON vs. LEFT JOIN USING performance
Previous Message Ron 2005-08-19 14:54:57 Re: sustained update load of 1-2k/sec