Re: Prepared statements and suboptimal plans

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Prepared statements and suboptimal plans
Дата
Msg-id 9289.1316565395@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Prepared statements and suboptimal plans  (Craig Ringer <ringerc@ringerc.id.au>)
Ответы Re: Prepared statements and suboptimal plans  (Andy Lester <andy@petdance.com>)
Список pgsql-performance
Craig Ringer <ringerc@ringerc.id.au> writes:
> On 21/09/2011 7:27 AM, Royce Ausburn wrote:
>> We've been worst hit by this query on an 8.3 site.  Another site is
>> running 8.4.  Have there been improvements in this area recently?
>> Upgrading to 9.0 might be viable for us.

> Tom just mentioned that 9.1 will be able to re-plan parameterized
> prepared statements, so this issue will go away.

9.2, sorry, not 9.1.  We could use some motivated people testing that
aspect of GIT HEAD, though, since I doubt the policy for when to re-plan
is quite ideal yet.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Royce Ausburn
Дата:
Сообщение: Re: Prepared statements and suboptimal plans
Следующее
От: Andy Lester
Дата:
Сообщение: Re: Prepared statements and suboptimal plans