Add a 'parallel_degree' reloption

Enterprise / PostgreSQL - Robert Haas [postgresql.org] - 8 April 2016 10:14 UTC

The code that estimates what parallel degree should be uesd for the scan of a relation is currently rather stupid, so add a parallel_degree reloption that can be used to override the planner's rather limited judgement.

Julien Rouhaud, reviewed by David Rowley, James Sewell, Amit Kapila, and me. Some further hacking by me.

25fe8b5 Add a 'parallel_degree' reloption.
doc/src/sgml/ref/create_table.sgml | 13 +++++++
src/backend/access/common/reloptions.c | 17 +++++++--
src/backend/optimizer/path/allpaths.c | 64 ++++++++++++++++++++++----------
src/backend/optimizer/util/plancat.c | 3 ++
src/backend/optimizer/util/relnode.c | 1 +
src/bin/psql/tab-complete.c | 1 +
src/include/nodes/relation.h | 1 +
src/include/utils/rel.h | 9 +++++
8 files changed, 86 insertions(+), 23 deletions(-)

Upstream: git.postgresql.org


  • Share