Re: Some info to share: db_STRESS Benchmark results - Mailing list pgsql-performance

From Dimitri
Subject Re: Some info to share: db_STRESS Benchmark results
Date
Msg-id 5482c80a0705311319k359a3cbbm20795385a8d46f87@mail.gmail.com
Whole thread Raw
In response to Re: Some info to share: db_STRESS Benchmark results  ("Alexander Staubo" <alex@purefiction.net>)
List 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@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.
>

pgsql-performance by date:

Previous
From: "Alexander Staubo"
Date:
Subject: Re: Some info to share: db_STRESS Benchmark results
Next
From: Vivek Khera
Date:
Subject: Re: max_fsm_pages, shared_buffers and checkpoint_segments