Re: Planner performance extremely affected by an hanging transaction (20-30 times)?

Поиск
Список
Период
Сортировка
От Jesper Krogh
Тема Re: Planner performance extremely affected by an hanging transaction (20-30 times)?
Дата
Msg-id 51CA92A1-7109-4539-8990-0A111E48E943@krogh.cc
обсуждение исходный текст
Ответ на Re: Planner performance extremely affected by an hanging transaction (20-30 times)?  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Дерево обсуждения

On 21/09/2013, at 00.01, Jeff Janes <jeff.janes@gmail.com> wrote:
See "In progress INSERT wrecks plans on table" and "Performance bug in prepared statement binding in 9.2" also on this list

This feels like the same




The issues are:

1) The planner actually queries the relation to find the end points of the variable ranges, rather than using potentially out-of-date statistics.


In my app i would prefer potentially out-of-date statistics instead.

Jesper

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Planner performance extremely affected by an hanging transaction (20-30 times)?
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Planner performance extremely affected by an hanging transaction (20-30 times)?