From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) |
Date: | 2018-07-09 15:19:28 |
Message-ID: | 20180709151928.GB19710@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
On Fri, Jun 22, 2018 at 02:53:36PM +0530, Amit Kapila wrote:
> On Wed, Jun 20, 2018 at 8:43 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > On Thu, May 24, 2018 at 08:00:25PM -0500, Justin Pryzby wrote:
> >
> > So I did some research on this, particularly to find out how it was
> > missed in the PG 10 release notes. It turns out that
> > max_parallel_workers_per_gather has always defaulted to 2 in head, and
> > this was changed to default to 0 in the 9.6 branch:
> >
> > commit f85b1a84152f7bf019fd7a2c5eede97867dcddbb
> > Author: Robert Haas <rhaas(at)postgresql(dot)org>
> > Date: Tue Aug 16 08:09:15 2016 -0400
> >
> > Disable parallel query by default.
> >
> > Per discussion, set the default value of max_parallel_workers_per_gather
> > to 0 in 9.6 only. We'll leave it enabled in master so that it gets
> > more testing and in the hope that it can be enable by default in v10.
> >
> > Therefore, there was no commit to find in the PG 10 commit logs. :-O
> > Not sure how we can avoid this kind of problem in the future.
> >
> > The attached patch adds a PG 10.0 release note item about this change.
> >
>
> Your proposed text looks good to me.
Done, thanks.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-07-09 15:34:26 | Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 |
Previous Message | Tom Lane | 2018-07-09 15:16:23 | Re: pgsql: Add wait event for fsync of WAL segments |
From | Date | Subject | |
---|---|---|---|
Next Message | Nandakumar M | 2018-07-10 05:36:59 | Re: Need help with optimising simple query |
Previous Message | Tom Lane | 2018-07-09 14:23:47 | Re: Need help with optimising simple query |