Re: Performance bug in prepared statement binding in 9.2? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Performance bug in prepared statement binding in 9.2?
Date
Msg-id 51A6A45D.9070105@agliodbs.com
Whole thread Raw
In response to Performance bug in prepared statement binding in 9.2?  (Josh Berkus <josh@agliodbs.com>)
List 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


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Performance bug in prepared statement binding in 9.2?
Next
From: itishree sukla
Date:
Subject: Check Pointer