Re: Performance degradation in commit 6150a1b0

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Noah Misch <noah(at)leadboat(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Performance degradation in commit 6150a1b0
Date: 2016-04-14 18:09:51
Message-ID: CA+TgmoaXihLgsAhq6=pp=aLBoG9NpZk1ipoBVEcBiSrghMu+eA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Apr 13, 2016 at 11:22 PM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> Yes, I also think that this particular issue can be closed. However I felt
> that the observation related to performance variation is still present as I
> never need to perform prewarm or anything else to get consistent results
> during my work in 9.5 or early 9.6. Also, Andres, Alexander and myself are
> working on similar observation (run-to-run performance variation) in a
> nearby thread [1].

Yeah. My own measurements do not seem to support the idea that the
variance recently increased, but I haven't tested incredibly widely.
It may be that whatever is causing the variance is something that used
to be hidden by locking bottlenecks and now no longer is.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-04-14 18:14:37 Re: Pglogical questions and problems
Previous Message Robert Haas 2016-04-14 18:05:35 Re: [COMMITTERS] pgsql: Code cleanup in the wake of recent LWLock refactoring.