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

Поиск
Список
Период
Сортировка
От Sanyo Moura
Тема Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0
Дата
Msg-id CAO698qZDi8ycdTKnXAEOPV+e+YA60YPUM7-ETX68q23Rzzv9Fg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения
Hello Tom,

Both versions 10.5 and 11.1 are running on the same test server.
What I did was migrate the database from 10.5 to 11.1 via pg_upgrade. After successful execution, I performed "vacuumdb --all --analyze-in-stages".

Thanks,

Sanyo Capobiango

Em ter, 27 de nov de 2018 às 13:00, Tom Lane <tgl@sss.pgh.pa.us> escreveu:
Sanyo Moura <sanyo.moura@tatic.net> writes:
> And below are the times generated by EXPLAIN ANALYZE:

> 10.5
> Planning time: 126.080 ms
> Execution time: 2.306 ms

> 11.0
> Planning Time: 7.238 ms
> Planning Time: 2.638 ms

> 11.5        (I assume you mean 11.1 here)
> Planning Time: 15138.533 ms
> Execution Time: 2.310 ms

There were no changes between 11.0 and 11.1 that look like they'd affect
planning time.  Nor does it seem particularly credible that planning time
would have dropped by a factor of 15 between 10.x and 11.x, especially
not given that the resulting plan didn't change.  I think you've got some
external factor causing long planning times --- maybe something taking an
exclusive lock on one of the tables, or on pg_statistic?

                        regards, tom lane

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

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