Hi,
thanks for your feedback regarding the PostgreSQL documentation. I'll
leave it up to Bruce.
Emmanuel Cecchet wrote:
You can look at slides #63 & 64 in
http://www.continuent.org/uploads/sequoia/Resources/2006-08-15Cecchet_ApacheConAsia2006.pdf
It shows the response time with a single database and with a cluster of
2 dbs. Response time remains constant until you go beyond the sweet spot
of a single node.
Thanks for the link.
We did not publish any official results with hard numbers. Note that you
can always build/tune a benchmark to show what you want to show. So
there is nothing better than testing with your application and see for
yourself. We have few recipes for performance but they are part of the
expertise we use for our commercial services.
May I ask what you use for automatic testing and benchmarking? I'm
currently stuck testing 90% of the time. Starting up the GCS, two
Databases and attaching the debugger to every process which could
possibly go havoc really takes a F***ING lot of time!
We have developed a complete automated distributed testing framework
(probably more code there than in the software to test itself!).
Yeah, I know what you mean. I'm about to start a rewrite of my own test
suite - the third generation... (well, the second was not too bad, but
I unfortunately lost source code due to a harddrive crash :-( )
Software, databases and clients are deployed automatically with the
proper configuration, tests are run and outputs are captured for
diagnosis. On the failover side, some scenarios can be automatically
generated (about 7000 failover scenarios are possible with a simple MST
in a 4 nodes cluster ...).
Sounds cool!
On the benchmarking side we use a couple of different benchmarks that
are available in the open source. It is good to have both
microbenchmarks and also more 'real' macro workloads such as TPC-*.
This whole test infrastructure is proprietary code that we have not
decided yet to open source.
Too bad. But well, nether did I open source my improvements on
Postgres-R, so I'm the last one to have the right to complain...
Regards
Markus
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
