From: Kevin Kempter <kevin@kevinkempterllc.com>
To: pgsql-performance@postgresql.org
Subject: building a performance test suite
Date: Wed, 10 Oct 2007 16:21:41 -0600
Message-ID: <200710101621.41749.kevin@kevinkempterllc.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kevin@kevinkempterllc.com
Subject: Re: building a performance test suite
In-Reply-To: <200710101621.41749.kevin@kevinkempterllc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox