Re: [PERFORM] Can postgresql plan a query using multiple CPU cores? - Mailing list pgsql-performance

From David G. Johnston
Subject Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?
Date
Msg-id CAKFQuwbejKAQ8+-vRK4Wk3XDHOjpX33-CG4BnCP_Rb7jG_31EQ@mail.gmail.com
Whole thread Raw
In response to [PERFORM] Can postgresql plan a query using multiple CPU cores?  (Clemens Eisserer <linuxhippy@gmail.com>)
List 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 by date:

Previous
From: Clemens Eisserer
Date:
Subject: [PERFORM] Can postgresql plan a query using multiple CPU cores?
Next
From: Mark Kirkwood
Date:
Subject: Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?