Re: pgsql: Add parallel-aware hash joins.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, pgsql-committers <pgsql-committers(at)postgresql(dot)org>
Subject: Re: pgsql: Add parallel-aware hash joins.
Date: 2018-01-22 23:53:10
Message-ID: 24384.1516665190@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

I wrote:
> Anyway, it looks like we should write off these longfin timings as
> ambient noise :-(

Here's a possibly more useful graph of regression test timings over
the last year. I pulled this from the buildfarm database: it is the
reported runtime for the "installcheck-C" step in each successful
build of HEAD on dromedary, going back to Jan. 2017. I picked dromedary
because I know that that machine hasn't gotten any software updates
nor is there anything else very interesting going on on it. I dropped
three or four obvious outlier reports (possibly those ran during the
machine's nightly backup cron job). The reported runtime is only
precise to 1s, and a couple seconds jitter is hardly surprising, so
there's a good deal of noise. Still, it's possible to discern when
I put some effort into test runtime reduction back in April, and
it can be seen that things have gotten notably slower since the
beginning of November.

regards, tom lane

Attachment Content-Type Size
image/png 5.2 KB

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Haribabu Kommi 2018-01-23 07:23:35 Re: pgsql: Move handling of database properties from pg_dumpall into pg_dum
Previous Message Tom Lane 2018-01-22 21:56:07 Re: pgsql: Move handling of database properties from pg_dumpall into pg_dum

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2018-01-22 23:57:49 Re: [HACKERS] Adding column_constraint description in ALTER TABLE synopsis
Previous Message Stephen Frost 2018-01-22 23:47:53 Re: [HACKERS] [PATCH] Call RelationDropStorage() for broader range of object drops.