Clever repeatable benchmarking and bottleneck detection test bench - PostgreSQL Has anyone usefull ideas, inspration or literature for me to design a good test bench for PostgreSQL. I need repeatable results, which are applyable in realworld and production environement (no Journaling off for example ;) ). I need the testbench to see effects on query and/or configuration tuning. Further it would be interessting to detect CPU, Memory or HD bottlenecks. 

I know this question is rather general, but right now I try to understand the process of improving prameters and tuning queries through consistent and repeatable results. Down the road it is about tuning and optimizing a routing database for GIS applications.

Thanks for your input!
Martin
While I can't speak to measuring specific metrics like CPU, storage throughput, etc. in your environment, I have found HammerDB to be a good tool for running a good, standardized benchmark against your databases.  This tool runs an unofficial TPC-C benchmark against your database. You can configure for concurrent user connections and workloads.  Using this conjunction with other metric tracking will help you evaluate your system for bottlenecks in an application agnostic manner.

As a note, HammerDB supports the following platforms at this time:


Oracle
SQL Server
MySQL
PostgreSQL
Redis