Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZCnPG-0007g4-Eo for pgsql-performance@arkaria.postgresql.org; Wed, 08 Jul 2015 11:20:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZCnPF-00086V-IZ for pgsql-performance@arkaria.postgresql.org; Wed, 08 Jul 2015 11:20:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZCnPD-00085v-Vb for pgsql-performance@postgresql.org; Wed, 08 Jul 2015 11:20:48 +0000 Received: from mail.anarazel.de ([217.115.131.40]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1ZCnPB-0002ZP-0I for pgsql-performance@postgresql.org; Wed, 08 Jul 2015 11:20:47 +0000 Received: from intern.anarazel.de (p548954B9.dip0.t-ipconnect.de [84.137.84.185]) (Authenticated sender: andres@anarazel.de) by mail.anarazel.de (Postfix) with ESMTPSA id 5050B860002; Wed, 8 Jul 2015 13:20:44 +0200 (CEST) Date: Wed, 8 Jul 2015 13:20:43 +0200 From: Andres Freund To: "Graeme B. Bell" Cc: Merlin Moncure , postgres performance list Subject: Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Message-ID: <20150708112043.GK10242@alap3.anarazel.de> References: <53BADEB5-F63D-476E-B0E1-CBD826574977@skogoglandskap.no> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <53BADEB5-F63D-476E-B0E1-CBD826574977@skogoglandskap.no> X-Pg-Spam-Score: -4.9 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 2015-07-08 11:13:04 +0000, Graeme B. Bell wrote: > I'm guessing you are maybe pressed for time at the moment because I > already clearly included this on the last email, as well as the links > to the alternative benchmarks with the same problem I referred to on > both of my last emails which are also trivial to drop into pgbench > (cut/paste). You realize that you want something here, not Merlin, right? > e.g. did you see these parts of my previous email > > "To clear up the issue I build a little test harness around your comment below." > "http://github.com/gbb/ppppt" Well, that requires reviewing the source code of the run script and such. I think we shouldn't discuss this on two threads (-performance, -bugs), that makes it hard to follow. Given Tom's more detailed answer I think the -bugs thread already contains more pertinent information. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance