[Bizgres-general] Performance page (alpha)

[Jim C. Nasby]

On Thu, Jul 21, 2005 at 12:10:54AM -0700, Luke Lonergan wrote:
> Johnny Soedomo and Ken Bell are building a performance reporting page, a
> very early version of which is here:
>   http://www.bizgres.org/assets/performance/index.php?server=stinger4
> 
> This version is static, the next version will be dynamic, with the ability
> to do multiple plot variations.  Also, the data we're generating is now only
> for the COPY and loader performance on the 3 supported platforms (32/64-bit
> Linux and 64-bit Solaris 10).  Next we'll be generating performance data
> within the same reporting system for queries.
> 
> Comments, suggestions welcome.

An idea that I've been toying with is comming up with some way to
correlate different input variables to how they actually impact
performance. The specific case that brought this on was looking at how
much heap correlation impacts the index scan penalty, though I was also
looking at some things like how much sort_mem affects sort speed with an
on-disk sort. I suspect that the best way to find out about this info is
to do performance testing while changing one variable at a time.

Probably not directly related, but possibly food for thought.
-- 
Jim C. Nasby, Database Consultant               decibel at decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"