John R Pierce schrieb am 06.12.2017 um 20:34:
>>> 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?
>
> oops, I meant, enable.
You are correct for 9.6 where the default was "disabled", but in 10 the default is, that it's enabled:
https://www.postgresql.org/docs/current/static/runtime-config-resource.html#GUC-MAX-PARALLEL-WORKERS-PER-GATHER
Sets the maximum number of workers that can be started by a single Gather or Gather Merge node [...] The default value is 2
In 9.6 the default was 0
Thomas