Fabrício dos Anjos Silva wrote:
> Is there any automated test tool? A can compile a list of real-world
> queries, and provide an exact copy of my db server just for testing.
> But how do I do it? Write a bunch of scripts? Is there any serious
> tool that try different parameters, run a load test, process results
> and generate reports?
There's a list of tools for playing back a test workload at
http://wiki.postgresql.org/wiki/Statement_Playback
I'm not aware of anyone beyond some academic research that has taken
that idea and built something to test many database parameter
combinations. They did that at
http://www.cs.duke.edu/~shivnath/papers/ituned.pdf but I don't think
that code went public; I asked about it at one point and never heard
anything really useful back.
--
Greg Smith, 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance" Pre-ordering at:
https://www.packtpub.com/postgresql-9-0-high-performance/book