Re: Performance bug in prepared statement binding in 9.2?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kevin Grittner <kgrittn(at)ymail(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Amit Kapila <amit(dot)kapila(at)huawei(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance bug in prepared statement binding in 9.2?
Date: 2014-11-10 19:04:33
Message-ID: 54610C41.4010504@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 11/10/2014 10:59 AM, Jeff Janes wrote:
> On Mon, Nov 10, 2014 at 10:48 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>
>> On 12/31/2013 09:55 AM, Tom Lane wrote:
>>> Josh Berkus <josh(at)agliodbs(dot)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?
>>
>
> It made it in:
>
> commit 4162a55c77cbb54acb4ac442ef3565b813b9d07a
> Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Date: Tue Feb 25 16:04:09 2014 -0500

Thanks, then the problem I'm seeing now is something else.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2014-11-10 19:08:36 Re: Performance bug in prepared statement binding in 9.2?
Previous Message Jeff Janes 2014-11-10 18:59:36 Re: Performance bug in prepared statement binding in 9.2?