Re: [GSoC] Summery of pg performance farm - Mailing list pgsql-hackers

From Mark Wong
Subject Re: [GSoC] Summery of pg performance farm
Date
Msg-id 20180821151014.GA2503@2ndQuadrant.com
Whole thread Raw
In response to Re: [GSoC] Summery of pg performance farm  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On Sun, Aug 19, 2018 at 12:20:37PM -0300, Alvaro Herrera wrote:
> On 2018-Aug-19, Hongyuan Ma wrote:
> > 2. Implementation of the data report related to the list page. Compare each
> > metrics whith the previous results. If any of the metrics are a 5%
> > improvement( or regression),  there is one aspect that is progressive (or
> > regressive). This means there may be aspects of "improvement", "regression"
> > and "status quo" in one test result.This is the report List page for an
> > example: http://140.211.168.111/#/machineInfo/pmJEjJjSk3WREM3Q
> 
> Great stuff!
> 
> I think the visualization that many had in mind was that the numbers
> would be displayed in charts there time is the horizontal axis, and the
> numerical performance result number is the other axis.   That way, we
> can see how the results go up or down with commits.
> 
> Individual happy/sad faces for individual commits are not enough to see
> the bigger picture.

I advised Hongyuan to try something simple here at first.  My initial
thought was a quick indicator (to not take up too much space on the
screen) and to drill down into the individual plant specifics to view
more details of history.

pgbench is running read-only and read-write tests with scale factors at
10, 1 x memory, and 2 x memory.  We could reduce the variations of the
tests if folks feel that would make more sense.  I thought the current
number of variations might be too many things to trend on this page, but
we can change that.

Regards,
Mark
-- 
Mark Wong                                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: ALTER TABLE on system catalogs
Next
From: Peter Eisentraut
Date:
Subject: Re: WaitForOlderSnapshots refactoring