News for hackers. Stuff that matters.
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?
Re:PostgreSQL 9.6 Beta 1 Released by jeltz on Thursday May 12, 2016 @12:41PM (#11684774)
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.