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