public inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedFrom: Bruce Momjian <bruce@momjian.us>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))
Date: Wed, 20 Jun 2018 11:13:49 -0400
Message-ID: <20180620151349.GB7500@momjian.us> (raw)
In-Reply-To: <20180525010025.GT30060@telsasoft.com>
References: <CA++JNSeCW1BSRVS7N--OmVOMDiMVA61_DFMA24fFbM2R7JdQjQ@mail.gmail.com>
<CAFj8pRDnW+bD5OmWjawxryv_=BctsE8HF5Y1n=oxgQ+xwrVqUQ@mail.gmail.com>
<CA++JNScUoxYKBhURxbG_DzoUfgKJup4a4TXUTiG1FFjuq8X-VQ@mail.gmail.com>
<CA++JNSfTEifSiBq73zpGCQuDNGr9yYcjmkx_=LtAbnadKLY_vg@mail.gmail.com>
<20171026194515.GV21735@telsasoft.com>
<20180128235310.GA5024@momjian.us>
<20180525010025.GT30060@telsasoft.com>
On Thu, May 24, 2018 at 08:00:25PM -0500, Justin Pryzby wrote:
> Moving to -hackers;
>
> On Sun, Jan 28, 2018 at 06:53:10PM -0500, Bruce Momjian wrote:
> > On Thu, Oct 26, 2017 at 02:45:15PM -0500, Justin Pryzby wrote:
> > > Is it because max_parallel_workers_per_gather now defaults to 2 ?
> > >
> > > BTW, I would tentatively expect a change in default to be documented in the
> > > release notes but can't see that it's.
> > > 77cd477c4ba885cfa1ba67beaa82e06f2e182b85
> >
> > Oops, you are correct. The PG 10 release notes, which I wrote, should
> > have mentioned this. :-(
>
> I just saw your January response to my October mail..
>
> Maybe it's silly to update PG10 notes 9 months after release..
> ..but, any reason not to add to v10 release notes now (I don't know if the web
> docs would be updated until the next point release?)
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@postgresql.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.
I put it at the bottom since it is newly added.
--
Bruce Momjian <bruce@momjian.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 +
Attachments:
[text/x-diff] parallel.diff (694B, 2-parallel.diff)
download | inline diff:
diff --git a/doc/src/sgml/release-10.sgml b/doc/src/sgml/release-10.sgml
new file mode 100644
index ea86b5e..5862cd8
*** a/doc/src/sgml/release-10.sgml
--- b/doc/src/sgml/release-10.sgml
*************** Branch: REL_10_STABLE [5159626af] 2017-1
*** 4065,4070 ****
--- 4065,4081 ----
</para>
</listitem>
+ <listitem>
+ <!--
+ This was disabled in the PG 9.6 branch so there is no commit here.
+ -->
+ <para>
+ Enable parallelism by default by changing the default setting
+ of <xref linkend="guc-max-parallel-workers-per-gather"/> to
+ <literal>2</literal>.
+ </para>
+ </listitem>
+
</itemizedlist>
</sect4>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bruce@momjian.us, pryzby@telsasoft.com, pgsql-hackers@lists.postgresql.org
Subject: Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))
In-Reply-To: <20180620151349.GB7500@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox