Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XnuKR-0001Ax-2u for pgsql-performance@arkaria.postgresql.org; Mon, 10 Nov 2014 19:08:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XnuKQ-0006MY-EK for pgsql-performance@arkaria.postgresql.org; Mon, 10 Nov 2014 19:08:42 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XnuKP-0006MO-IB for pgsql-performance@postgresql.org; Mon, 10 Nov 2014 19:08:41 +0000 Received: from mail.anarazel.de ([217.115.131.40]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XnuKM-0003Fk-7c for pgsql-performance@postgresql.org; Mon, 10 Nov 2014 19:08:39 +0000 Received: from intern.anarazel.de (p549F2DF8.dip0.t-ipconnect.de [84.159.45.248]) (Authenticated sender: andres@anarazel.de) by mail.anarazel.de (Postfix) with ESMTPSA id EE393460002; Mon, 10 Nov 2014 20:08:36 +0100 (CET) Date: Mon, 10 Nov 2014 20:08:36 +0100 From: Andres Freund To: Josh Berkus Cc: Tom Lane , Kevin Grittner , Andrew Dunstan , Jeff Janes , Amit Kapila , "pgsql-performance@postgresql.org" Subject: Re: Performance bug in prepared statement binding in 9.2? Message-ID: <20141110190836.GK28007@alap3.anarazel.de> References: <523120E9.6020300@agliodbs.com> <24236.1383940000@sss.pgh.pa.us> <1384014645.82057.YahooMailNeo@web162903.mail.bf1.yahoo.com> <19685.1384307200@sss.pgh.pa.us> <5283D433.3040406@agliodbs.com> <27642.1388512538@sss.pgh.pa.us> <54610878.3060203@agliodbs.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <54610878.3060203@agliodbs.com> X-Pg-Spam-Score: -2.6 (--) 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 2014-11-10 10:48:24 -0800, Josh Berkus wrote: > On 12/31/2013 09:55 AM, Tom Lane wrote: > > Josh Berkus writes: > >> Tom, > >>> There's an abbreviated version of this argument in the comments in > >>> my proposed patch at > >>> http://www.postgresql.org/message-id/11927.1384199294@sss.pgh.pa.us > >>> What I'm hoping will happen next is that the complainants will hot-patch > >>> that and see if it fixes their problems. We can't really determine > >>> what to do without that information. > > > >> Unfortunately, the original reporter of this issue will not be available > >> for testing for 2-3 weeks, and I haven't been able to devise a synthetic > >> test which clearly shows the issue. > > > > Ping? I've been waiting on committing that patch pending some real-world > > testing. It'd be nice to resolve this question before we ship 9.3.3, > > which I'm supposing will be sometime in January ... > > Did this patch every make it in? Or did it hang waiting for > verification? src/tools/git_changelog is your friend. Author: Tom Lane Branch: master Release: REL9_4_BR [fccebe421] 2014-02-25 16:04:06 -0500 Branch: REL9_3_STABLE Release: REL9_3_4 [4162a55c7] 2014-02-25 16:04:09 -0500 Branch: REL9_2_STABLE Release: REL9_2_8 [00283cae1] 2014-02-25 16:04:12 -0500 Branch: REL9_1_STABLE Release: REL9_1_13 [3e2db4c80] 2014-02-25 16:04:16 -0500 Branch: REL9_0_STABLE Release: REL9_0_17 [1e0fb6a2c] 2014-02-25 16:04:20 -0500 Use SnapshotDirty rather than an active snapshot to probe index endpoints. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance