Re: Does Postgresql 10 query partitions in parallel?

On 12/6/2017 5:11 AM, Maltsev Eduard wrote:
> I'm curious if the new feature of Postgresql allows to take advantage
> of multiple cpus on server, and multiple servers (fdw), for larger
> read only queries (Data mining). In general there should be some
> worker that queries partitions and merges the results, and I expect it
> to be done in parallel. This becomes critical when foreign tables are
> used, I suppose.

PostgreSQL 10 does indeed have a parallel query feature that will use
multiple cores.  you have to explicity invoke it.   As this is a first
implementation, its fairly limited as to the sorts of queries that can
be parallized, but this will be enhanced in future versions.

https://www.postgresql.org/docs/current/static/parallel-query.html (read
the whole chapter)

--
john r pierce, recycling bits in santa cruz