NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitc7ea68f

committed

Limit maximum parallel degree to 1024.

This new limit affects both the max_parallel_degree GUC and theparallel_degree reloption. There may some day be a use case for usingmore than 1024 CPUs for a single query, but that's surely not the caseright now. Not only do not very many people have that many CPUs, butthe code hasn't been tested at that kind of scale and is very unlikelyto perform well, or even work at all, without a lot more work. Theissue addressed by commit06bd458 isprobably just one problem of many.The idea of a more reasonable limit here was suggested by Tom Lane;the value of 1024 was suggested by Amit Kapila.

1 parent73b9952 commitc7ea68fCopy full SHA for c7ea68f

File tree

2 files changed

-2

lines changed

src/backend
- access/common
  - reloptions.c
- utils/misc
  - guc.c

2 files changed

-2

lines changed

`‎src/backend/access/common/reloptions.c`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -275,7 +275,7 @@ static relopt_int intRelOpts[] =`
`275`	`275`	`RELOPT_KIND_HEAP,`
`276`	`276`	`AccessExclusiveLock`
`277`	`277`	`},`
`278`		`--1,0,MAX_BACKENDS`
	`278`	`+-1,0,1024`
`279`	`279`	`},`
`280`	`280`
`281`	`281`	`/* list terminator */`

`‎src/backend/utils/misc/guc.c`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2662,7 +2662,7 @@ static struct config_int ConfigureNamesInt[] =`
`2662`	`2662`	`NULL`
`2663`	`2663`	`},`
`2664`	`2664`	`&max_parallel_degree,`
`2665`		`-2,0,MAX_BACKENDS,`
	`2665`	`+2,0,1024,`
`2666`	`2666`	`NULL,NULL,NULL`
`2667`	`2667`	`},`
`2668`	`2668`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitc7ea68f

File tree

2 files changed

2 files changed

`‎src/backend/access/common/reloptions.c`

`‎src/backend/utils/misc/guc.c`

0 commit comments