Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0
Дата
Msg-id CAKJS1f8cZUzzGQnYKSfzeEe-fscQc9s5wPy4ZNPn-Uq=pDcODw@mail.gmail.com
обсуждение исходный текст
Ответ на Query with high planning time at version 11.1 compared versions 10.5and 11.0  (Sanyo Moura <sanyo.moura@tatic.net>)
Ответы Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0
Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0
Список pgsql-performance
Дерево обсуждения 
On Wed, 28 Nov 2018 at 03:16, Sanyo Moura <sanyo.moura@tatic.net> wrote:
> 11.0
> Planning Time: 7.238 ms
> Planning Time: 2.638 ms
>
> 11.5
> Planning Time: 15138.533 ms
> Execution Time: 2.310 ms

Does it still take that long after running ANALYZE on the partitioned table?

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

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0