Re: Performance bug in prepared statement binding in 9.2?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance bug in prepared statement binding in 9.2?
Date: 2013-05-30 00:59:09
Message-ID: 51A6A45D.9070105@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 05/29/2013 05:14 PM, Josh Berkus wrote:
> Here's timings overall for 29 test cycles (cycle 1 has been omitted).
> As you can see, parse+execute times are pretty much constant, as are
> application think times, but bind times vary quite a lot. In 8.4, the
> 29 cycles are constantly 4.5min to 5.75min long. In 9.2, which is the
> chart below, they are all over the place.

To be clear, the TOTAL times for 8.4 are 4.5 to 5.75 minutes long. Bind
times in 8.4 are a more-or-less constant 0.75 minutes.

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message itishree sukla 2013-05-30 12:09:12 Check Pointer
Previous Message Josh Berkus 2013-05-30 00:14:30 Performance bug in prepared statement binding in 9.2?