On 2017-12-06 10:53:22 -0800, John R Pierce wrote: > 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. "you have to explicitly invoke it" - huh? > 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. It's already been expanded a lot since 9.6. Greetings, Andres Freund
