I have a DB is PostgreSQL 8.2 running on UltraSparc T2 Processor ( SUN T5120). All applications connecting to this DB will be using Store Porcedures. We have SPs for INSERT, DELETE, SELECT ,etc.
What would be the best way of:
1) Test all the SPs and their performance
2) Run the most complex one, or the ones we expect more concurrency, from a tool, so we can measure degradation, performance issues etc, when they run at the same time, multiple times.
I've been looking at Stress test solutions, from Hardware so software, It seems I can not find a solutions that allosw me to run the SP and take parameters from text files (for example, for INSERTS)
What would be the best strategy here?
Thanks for the help.