Re: Performance bug in prepared statement binding in 9.2?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Performance bug in prepared statement binding in 9.2?
Дата
Msg-id 51A6A45D.9070105@agliodbs.com
обсуждение исходный текст
Ответ на Performance bug in prepared statement binding in 9.2?  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Performance bug in prepared statement binding in 9.2?
Следующее
От: itishree sukla
Дата:
Сообщение: Check Pointer