Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?
Дата
Msg-id CAKFQuwbejKAQ8+-vRK4Wk3XDHOjpX33-CG4BnCP_Rb7jG_31EQ@mail.gmail.com
обсуждение исходный текст
Ответ на [PERFORM] Can postgresql plan a query using multiple CPU cores?  (Clemens Eisserer <linuxhippy@gmail.com>)
Список pgsql-performance
On Monday, May 22, 2017, Clemens Eisserer <linuxhippy@gmail.com> wrote:
Hi,

I have a letancy-sensitive legacy application, where the time consumed
by query planning was always causing some headaches.
Currently it is running on postgresql-8.4 - will postgresql-10 support
generating plans using multiple CPU cores to reduce the time required
to generate a single plan?


My understanding, from both list monitoring and the release notes, is that query parallelization happens only during execution, not planning.  A single process is still responsible for evaluating all (possibly partial) plans and picking the best one - flagging those plan steps that can leverage parallelism for possible execution.

David J.
 

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

Предыдущее
От: Clemens Eisserer
Дата:
Сообщение: [PERFORM] Can postgresql plan a query using multiple CPU cores?
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?