DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=BxsYWN4NlD5M0CqxghRVJmsCldrwxjUy+vQjSky2vHl+A7lnxk1Ve1mr/lcV1PCgL7MiefKusq2LRrmwFLSe1WugK+GG9xJmV4SUFe0FFe5bxK+/CDi4JMvR0sr1XeSSS8efCYCpW7/kfYYNxEnQzvsEk7BxxG7zWBkfGMS56os=
Message-ID: <5482c80a0705311319k359a3cbbm20795385a8d46f87@mail.gmail.com>
Date: Thu, 31 May 2007 22:19:15 +0200
From: Dimitri <dimitrik.fr@gmail.com>
To: "Alexander Staubo" <alex@purefiction.net>
Subject: Re: Some info to share: db_STRESS Benchmark results
Cc: "PostgreSQL Performance" <pgsql-performance@postgresql.org>
In-Reply-To: <88daf38c0705311248s63945ca9u74657dd378a9c9e5@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <5482c80a0705311228o32ccaa19r116a71144fcaafd1@mail.gmail.com>
	<88daf38c0705311248s63945ca9u74657dd378a9c9e5@mail.gmail.com>

Well, let's say I want to have compact graphs  :)

So, few comments on graphs:
  - Title: compact name of test and execution conditions
  - X-axis: is always representing time scale
  - Y-axis: is showing a value level (whatever)
  - Legend: gives you a value Name and its metric (KB/s, Op/s, TPS, etc)

TPS: (transactions per second)
  - ALL-tps TR_all: all transactions (READ+WRITE) per second level
  - ALL-tps TR_Read: only READ tps level
  - ALL-tps TR_Write: only WRITE tps level

I must say I was more intrested by databases tuning rather documenting
each my step... But well, without documenting there is no result :)
As well I did not think to compare database initially (don't know why
but it's always starting a small war between DB vendors :)), but
results were so surprising so I just continued until it was possible
:))

Rgds,
-Dimitri

On 5/31/07, Alexander Staubo <alex@purefiction.net> wrote:
> On 5/31/07, Dimitri <dimitrik.fr@gmail.com> wrote:
> > just wanted to share some benchmark results from one long performance
> > study comparing MySQL, PostgreSQL and Oracle transactions throughput
> > and engine scalability on T2000 and V890 (under Solaris).
>
> Interesting, if awfully cryptic. The lack of axis labels, the lack of
> axis normalization, and the fact that you put the graphs for different
> databases and parameters on separate pages makes it rather hard to
> compare the various results.
>
> Alexander.
>