distributed performance testing

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: distributed performance testing
Date: 2005-08-13 18:24:02
Message-ID: 42FE3AC2.3090802@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


A little while ago I rather rashly opined that we could extend the
buildfarm to do (optional) performance testing. After thinking about it
for some time I now think that might not be such a good idea. We can
certainly leverage a lot of the technology used and experience gained in
building the buildfarm to create a distributed performance testing
system, and we know that many among the buildfarm members would be
willing to join such an effort, but I now think it probably needs to be
a separate beast.

Buildfarm tests correctness on various code branches, for a fairly
static config set per member, triggered by code changes. It has a
number of hoops to jump through, each of which has a well defined set
of success criteria. By contrast, performance testing to be useful
needs to be more flexible in several ways - including the code tested
(ideally, we'd be able to try out several patch sets) and the tests
performed. What is more, measurement is on a continuous scale rather
than a set of boolean flags. And the trigger to run tests needs to be
something other than changes in code on a well known branch.

Incidentally, use of a different SCM system might well make
constructing test sets more simple. Imagine, say, in SVN, you would
create a branch called "test-set-yyyy-mm-dd" or some such, make your
changes there, add a test script under some well known name, and commit
the branch. Then you might put an entry on the server that contains the
name of the branch and a date/time after which we would consider the
tests stale. The performance-farm member would periodically check with
the server for new entries, switch to the named branch, build, run the
tests, and upload the results.

If someone wants to have a go at implementing such a system, I can give
them some help and advice. Otherwise I will put it on my list of things
to do, but the earliest I could devote any time to it would be very late
this year.

cheers

andrew

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-08-13 19:34:28 Re: win32 _dosmaperr()
Previous Message Stefan Kaltenbrunner 2005-08-13 18:22:20 Re: Changes improve the performance of INSERT and UPDATE