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 suspect I should look at grabbing these things for load: # of queries running # of IDLE connections and these things for performance how long the queries run difference between the runs for # of queries running What do you'all think? are these valid metrics? 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? Thanks in advance... /Kevin ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
