pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: [PATCH] force_parallel_mode and GUC categories
Date: Fri, 9 Apr 2021 07:39:28 -0400
Message-ID: <20210409113928.GA12919@momjian.us> (raw)
In-Reply-To: <20210409031718.GO6592@telsasoft.com>
References: <CAFj8pRDycZjBLBaEkUcY4B01PS=ojoaBgQnzJaqBROTn8KM7Bg@mail.gmail.com>
	<20210403141651.GI6592@telsasoft.com>
	<CAN0SRDF6ZzxV-+OdgP6B+Zg0TmhrYFSOd3kK8GC5mkfo1icEGQ@mail.gmail.com>
	<20210403151201.GD29125@momjian.us>
	<3972636.1617464359@sss.pgh.pa.us>
	<20210403154114.GJ6592@telsasoft.com>
	<20210403154336.GG29125@momjian.us>
	<20210404012546.GK6592@telsasoft.com>
	<YG+y/eJErKPDUhiS@paquier.xyz>
	<20210409031718.GO6592@telsasoft.com>

On Thu, Apr  8, 2021 at 10:17:18PM -0500, Justin Pryzby wrote:
> On Fri, Apr 09, 2021 at 10:50:53AM +0900, Michael Paquier wrote:
> > On Sat, Apr 03, 2021 at 08:25:46PM -0500, Justin Pryzby wrote:
> > > Forking this thread
> > > https://www.postgresql.org/message-id/20210403154336.GG29125%40momjian.us
> > 
> > Didn't see this one, thanks for forking.
> > 
> > -       {"force_parallel_mode", PGC_USERSET, QUERY_TUNING_OTHER,
> > +       {"force_parallel_mode", PGC_USERSET, DEVELOPER_OPTIONS,
> > And not this one either, as it is mainly a planner thing, like the
> > other parameters in the same area.
> 
> This is the main motive behind the patch.
> 
> Developer options aren't shown in postgresql.conf.sample, which it seems like
> sometimes people read through quickly, setting a whole bunch of options that
> sound good, sometimes including this one.  And in the best case they then ask
> on -performance why their queries are slow and we tell them to turn it back off
> to fix their issues.  This changes to no longer put it in .sample, and calling
> it a "dev" option seems to be the classification and mechanism by which to do
> that.

+1

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.






view thread (18+ messages)  latest in thread

Message-ID: <20210409113928.GA12919@momjian.us>
Permalink:  ../20210409113928.GA12919@momjian.us/
Also on:    postgresql.org/message-id/20210409113928.GA12919@momjian.us

 · 

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-hackers@postgresql.org
  Cc: bruce@momjian.us, pryzby@telsasoft.com, michael@paquier.xyz, tgl@sss.pgh.pa.us, pgsql-hackers@lists.postgresql.org
  Subject: Re: [PATCH] force_parallel_mode and GUC categories
  In-Reply-To: <20210409113928.GA12919@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox