Re: Quality and Performance - Mailing list pgsql-hackers

From Stefan Kaltenbrunner
Subject Re: Quality and Performance
Date
Msg-id 474D0FF8.5090304@kaltenbrunner.cc
Whole thread Raw
In response to Re: Quality and Performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> Josh Berkus wrote:
>>> ... DW operations aren't 
>>> really testable without 18 hours to generate data ... but we could test a 
>>> lot of things.
> 
>> Performance isn't just about humungous DW apps.
> 
> Indeed.  I think the real take-home lesson from these past few days'
> discussion is that *any* particular view of performance is going to
> miss things that don't affect that case, but do affect somebody else.

yep - but the "do not affect somebody else" might be one that could be
actually catched by something like a benchfarm.

> 
> What I find most worrisome about the notion of setting up a
> performance-farm is that it will encourage us to optimize with blinkers
> on --- that is, that we will consider only the specific cases measured
> by whatever tests are included in the farm, and will happily pessimize
> other cases.  We can ameliorate that a bit if we can get a sufficiently
> wide variety of test cases, but it will always be a concern.  And
> dogmatic positions like "only cases involving terabytes of data are
> worth testing" are definitely not going to help.

agreed - I don't think having the tests itself in core (at least
initially) is such a good idea(neither am I sure tacking it on top of
the buildfarm really is).
There are a LOT of things we could do with such a farm/infrastructure
but it will take time to exactly figure out what we can reasonably do on
an automated/regular base and in a common framework.


Stefan


pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: Time to update list of contributors
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: PG 7.3 is five years old today