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
