Skip site navigation (1) Skip section navigation (2)

Re: Some info to share: db_STRESS Benchmark results

From: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>
To: "Alexander Staubo" <alex(at)purefiction(dot)net>
Cc: "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Some info to share: db_STRESS Benchmark results
Date: 2007-05-31 20:19:15
Message-ID: 5482c80a0705311319k359a3cbbm20795385a8d46f87@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)purefiction(dot)net> wrote:
> On 5/31/07, Dimitri <dimitrik(dot)fr(at)gmail(dot)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.
>

In response to

pgsql-performance by date

Next:From: Vivek KheraDate: 2007-05-31 21:23:55
Subject: Re: max_fsm_pages, shared_buffers and checkpoint_segments
Previous:From: Alexander StauboDate: 2007-05-31 19:48:26
Subject: Re: Some info to share: db_STRESS Benchmark results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group