Re:PostgreSQL 9.6 Beta 1 Released
by rpedela on Thursday May 12, 2016 @12:26PM
(#11684627)
Does anyone know if parallel query execution just happens by default or do you have to tell PG that you want it?
[ Parent
| on HN ]
You have to enable it by configuring the maximum number of workers per query, and then the query planner tries to figure out if the query would benefit from a parallel execution. This is the first release with parallelism so I would not be surprised if the query planner gets this wrong in some cases.