pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSome info to share: db_STRESS Benchmark results
3+ messages / 2 participants
[nested] [flat]
* Some info to share: db_STRESS Benchmark results
@ 2007-05-31 19:28 Dimitri <dimitrik.fr@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Dimitri @ 2007-05-31 19:28 UTC (permalink / raw)
To: pgsql-performance
Folks,
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). Oracle
results are removed (of course :), but other are quite interesting...
Findings are presented as it, following step by step learning and
tuning curve :)
So well, you may find:
- http://dimitrik.free.fr/db_STRESS.html - Benchmark kit description
- http://dimitrik.free.fr/db_STRESS_BMK_Part1.html -- first main part
- http://dimitrik.free.fr/db_STRESS_BMK_Part2_ZFS.html -- second
part including ZFS specific tuning
Tests were executed in Mar/Apr.2007 with latest v8.2.3 on that time.
Due limited spare time I was able to publish results only now...
Any comments are welcome! :)
Best regards!
-Dimitri
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Some info to share: db_STRESS Benchmark results
@ 2007-05-31 19:48 Alexander Staubo <alex@purefiction.net>
parent: Dimitri <dimitrik.fr@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Alexander Staubo @ 2007-05-31 19:48 UTC (permalink / raw)
To: Dimitri <dimitrik.fr@gmail.com>; +Cc: pgsql-performance
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Some info to share: db_STRESS Benchmark results
@ 2007-05-31 20:19 Dimitri <dimitrik.fr@gmail.com>
parent: Alexander Staubo <alex@purefiction.net>
0 siblings, 0 replies; 3+ messages in thread
From: Dimitri @ 2007-05-31 20:19 UTC (permalink / raw)
To: Alexander Staubo <alex@purefiction.net>; +Cc: 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.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-05-31 20:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-31 19:28 Some info to share: db_STRESS Benchmark results Dimitri <dimitrik.fr@gmail.com>
2007-05-31 19:48 ` Alexander Staubo <alex@purefiction.net>
2007-05-31 20:19 ` Dimitri <dimitrik.fr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox