Re: [PERFORM] building a performance test suite

2007-10-11 Thread Dimitri Fontaine
Hi, Le jeudi 11 octobre 2007, Kevin Kempter a écrit : > I'm preparing to create a test suite of very complex queries that can be > profiled in terms of load and performance. The ultimate goal is to define a > load/performance profile during a run of the old application code base and > then again w

Re: [PERFORM] building a performance test suite

2007-10-10 Thread Greg Smith
On Wed, 10 Oct 2007, Kevin Kempter wrote: should I be looking at others like pg_statio or pg_stat_all_tables ? If so, what should I look for in these (or other) tables? There are a good set of monitoring scripts for performance-oriented things included with the dbt2 benchmarking package, htt

[PERFORM] building a performance test suite

2007-10-10 Thread Kevin Kempter
Hi List; I'm preparing to create a test suite of very complex queries that can be profiled in terms of load and performance. The ultimate goal is to define a load/performance profile during a run of the old application code base and then again with changes to the application code base. I suspe