Re: Yet another abort-early plan disaster on 9.3

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Yet another abort-early plan disaster on 9.3
Дата
Msg-id CA+U5nMJqbcveiVL=cMCkzvOzSqPHytPROTbUnw8W6YRC=8T3Vw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Yet another abort-early plan disaster on 9.3  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Yet another abort-early plan disaster on 9.3  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-performance
On 12 December 2014 at 03:22, Simon Riggs <simon@2ndquadrant.com> wrote:

> It's a simple patch, but it solves the test cases I know about and
> does almost nothing to planning time.

Test cases attached. The files marked "pettus_*" are written up from
Christophe Pettus' blog.
The other test case is one of my own devising, based upon recent
customer problems.

The "10 most recent calls" is a restatement of actual problems seen in the past.


Also attached is a new parameter called enable_sortedpath which can be
used to turn on/off the sorted path generated by the planner.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Вложения

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Yet another abort-early plan disaster on 9.3
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: 8xIntel S3500 SSD in RAID10 on Dell H710p