Re: Performance bug in prepared statement binding in 9.2?

От: Andres Freund
Тема: Re: Performance bug in prepared statement binding in 9.2?
Дата: ,
Msg-id: 20141110190836.GK28007@alap3.anarazel.de
(см: обсуждение, исходный текст)
Ответ на: Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus)
Список: pgsql-performance

Скрыть дерево обсуждения

Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
 Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
 Re: Performance bug in prepared statement binding in 9.2?  (Amit Kapila, )
 Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
  Re: Performance bug in prepared statement binding in 9.2?  (Amit Kapila, )
  Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
   Re: Performance bug in prepared statement binding in 9.2?  (Tom Lane, )
    Re: Performance bug in prepared statement binding in 9.2?  (Kevin Grittner, )
     Re: Performance bug in prepared statement binding in 9.2?  (Tom Lane, )
   Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
   Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
 Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
 Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
 Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
  Re: Performance bug in prepared statement binding in 9.2?  (Jeff Janes, )
   Re: Performance bug in prepared statement binding in 9.2?  (Andrew Dunstan, )
    Re: Performance bug in prepared statement binding in 9.2?  (Bruce Momjian, )
    Re: Performance bug in prepared statement binding in 9.2?  (Andres Freund, )
    Re: Performance bug in prepared statement binding in 9.2?  (Andres Freund, )
     Re: Performance bug in prepared statement binding in 9.2?  (Andrew Dunstan, )
      Re: Performance bug in prepared statement binding in 9.2?  (Andres Freund, )
       Re: Performance bug in prepared statement binding in 9.2?  (Andres Freund, )
        Re: Performance bug in prepared statement binding in 9.2?  (Andrew Dunstan, )
  Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
   Re: Performance bug in prepared statement binding in 9.2?  (Jeff Janes, )
   Re: Performance bug in prepared statement binding in 9.2?  (Andres Freund, )
  Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
   Re: Performance bug in prepared statement binding in 9.2?  (Tom Lane, )
   Re: Performance bug in prepared statement binding in 9.2?  (Tom Lane, )
 Re: Performance bug in prepared statement binding in 9.2?  (Mel Llaguno, )
  Re: Performance bug in prepared statement binding in 9.2?  (Bruce Momjian, )
 Re: Performance bug in prepared statement binding in 9.2?  (Mel Llaguno, )
  Re: Performance bug in prepared statement binding in 9.2?  (Bruce Momjian, )
 Re: Performance bug in prepared statement binding in 9.2?  (Mel Llaguno, )
  Re: Performance bug in prepared statement binding in 9.2?  (Bruce Momjian, )
 Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
  Re: Performance bug in prepared statement binding in 9.2?  (Andrew Dunstan, )
   Re: Performance bug in prepared statement binding in 9.2?  (Andres Freund, )
    Re: Performance bug in prepared statement binding in 9.2?  (Jeff Janes, )
  Re: Performance bug in prepared statement binding in 9.2?  (Andres Freund, )
  Re: Performance bug in prepared statement binding in 9.2?  (Josh Berkus, )
   Re: Performance bug in prepared statement binding in 9.2?  (Tom Lane, )
   Re: Performance bug in prepared statement binding in 9.2?  (Jeff Janes, )

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/
> >>> 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



В списке pgsql-performance по дате сообщения:

От: Josh Berkus
Дата:
Сообщение: Re: Performance bug in prepared statement binding in 9.2?
От: avpro avpro
Дата:
Сообщение: trigger Before or After