From: Andres Freund <andres@2ndquadrant.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kevin Grittner <kgrittn@ymail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: Jeff Janes <jeff.janes@gmail.com>
Cc: Amit Kapila <amit.kapila@huawei.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Performance bug in prepared statement binding in 9.2?
Date: Mon, 10 Nov 2014 20:08:36 +0100
Message-ID: <20141110190836.GK28007@alap3.anarazel.de> (raw)
In-Reply-To: <54610878.3060203@agliodbs.com>
References: <WM!c3606120c0bb347c33db79557781a3bddaeb55ccb41e40a3859a4dc0d258d194010ad0001617c701ce31e795a28cb6ca!@asav-2.01.com>
<523120E9.6020300@agliodbs.com>
<24236.1383940000@sss.pgh.pa.us>
<1384014645.82057.YahooMailNeo@web162903.mail.bf1.yahoo.com>
<19685.1384307200@sss.pgh.pa.us>
<WM!53245515c260eb3f3ebba35fd7da76a6c4d81274ee6f204f23312f2e9a8487c869ace190beab2dada668e213a6b65dd7!@asav-2.01.com>
<5283D433.3040406@agliodbs.com>
<27642.1388512538@sss.pgh.pa.us>
<WM!4667f3cb5dc47231ae35b8e8536208e1377cd80dc7752b6791aae9904e622051fd053c46bc2f2a0a00de258290b6e155!@asav-1.01.com>
<54610878.3060203@agliodbs.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 2014-11-10 10:48:24 -0800, Josh Berkus wrote:
> On 12/31/2013 09:55 AM, Tom Lane wrote:
> > Josh Berkus <josh@agliodbs.com> 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 <tgl@sss.pgh.pa.us>
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
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: andres@2ndquadrant.com, josh@agliodbs.com, tgl@sss.pgh.pa.us, kgrittn@ymail.com, andrew@dunslane.net, jeff.janes@gmail.com, amit.kapila@huawei.com
Subject: Re: Performance bug in prepared statement binding in 9.2?
In-Reply-To: <20141110190836.GK28007@alap3.anarazel.de>
* 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