Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eExqn-0005TR-VO for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Nov 2017 13:35:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eExqn-00049P-A4 for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Nov 2017 13:35:33 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eExqn-00049F-1i for pgsql-hackers@lists.postgresql.org; Wed, 15 Nov 2017 13:35:33 +0000 Received: from mail-qt0-f180.google.com ([209.85.216.180]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eExqj-0000ib-IY for pgsql-hackers@postgresql.org; Wed, 15 Nov 2017 13:35:31 +0000 Received: by mail-qt0-f180.google.com with SMTP id v41so34238636qtv.12 for ; Wed, 15 Nov 2017 05:35:28 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:reply-to:subject:to:cc:references:from :organization:message-id:date:user-agent:mime-version:in-reply-to :content-language; bh=WF/IXBooFLH1c3zu8J3DA6tr7iwjDE4CFqmklOs6mLo=; b=tulP4sIgEo5LqaZOsy3ry587AFdFG1R8qB7kA+oS7ZcUsel+9qvY335JvQz4lGCw8D qzhiLM2owbdj2LFgnOIURnnSJ1npo3Cj7Ty0geuTplnK7D/EQSnVkOvoIsq5WxxMbqMQ K3KwVXPdX8FnCSF0QLNEg/9WGjBtc+EcecIYRCvLg9ng9pcAteGLuMmH3ZasucCPqy3E M1n4sz5h+gcJI4aFsMnCo+MAxUsGumAgH5gAlAPTpVlH/u/Dpd/wpQiW/icYIvL3nto2 ldDoJOita1S1nwk7s+zizJrq3T6tp8h77SwBIJn0tXvIdr/2rJ0R9G3f+oTIovh3tnO6 4+cA== X-Gm-Message-State: AJaThX4NtcYE5BObSs7zWP8NYVAB8o5xK2Qqyy31Gy2pjdc1wnORMT48 ksiPV5CmqjBHDphWmi35kfCBlhnHgqE= X-Google-Smtp-Source: AGs4zMZWESi8GCn9gI5ziIPMDBwtRbUnjJV9Jw89dTkCtf6zQvQanoJkCez3IcP3YJoHPnNHE4jrGA== X-Received: by 10.55.158.6 with SMTP id h6mr23142568qke.355.1510752927583; Wed, 15 Nov 2017 05:35:27 -0800 (PST) Received: from localhost.localdomain (c-24-61-8-151.hsd1.ma.comcast.net. [24.61.8.151]) by smtp.gmail.com with ESMTPSA id x40sm6320904qtb.77.2017.11.15.05.35.26 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 15 Nov 2017 05:35:26 -0800 (PST) Reply-To: jesper.pedersen@redhat.com Subject: Re: [HACKERS] A GUC to prevent leader processes from running subplans? To: Robert Haas Cc: Thomas Munro , Pg Hackers References: From: Jesper Pedersen Organization: Red Hat Message-ID: <000f92d6-f623-95a5-b341-46e2c0495cea@redhat.com> Date: Wed, 15 Nov 2017 08:35:26 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/mixed; boundary="------------D06B20C63799A2C5481E9AD8" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------D06B20C63799A2C5481E9AD8 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit On 11/15/2017 08:28 AM, Robert Haas wrote: > On Tue, Nov 14, 2017 at 12:28 AM, Thomas Munro > wrote: >> Thanks. You're right. Rebased and updated to describe what "off" does. > > Committed. I noticed that you didn't add the new GUC to > postgresql.conf.sample, so I did that. But then I thought it didn't > really belong in the section you put it, so I moved it to > RESOURCES_ASYNCHRONOUS. > Small typo. Best regards, Jesper --------------D06B20C63799A2C5481E9AD8 Content-Type: text/x-patch; name="typo.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="typo.patch" diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index c7cd72ade2..63b8723569 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -163,7 +163,7 @@ #effective_io_concurrency = 1 # 1-1000; 0 disables prefetching #max_worker_processes = 8 # (change requires restart) #max_parallel_workers_per_gather = 2 # taken from max_parallel_workers -#parallel_leader_particulation = on +#parallel_leader_participation = on #max_parallel_workers = 8 # maximum number of max_worker_processes that # can be used in parallel queries #old_snapshot_threshold = -1 # 1min-60d; -1 disables; 0 is immediate --------------D06B20C63799A2C5481E9AD8--