NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit57a6a72

committed

Enable parallelism for prepared statements and extended query protocol.

Parallel query can't handle running a query only partially rather thanto completion. However, there seems to be no way to run a statementprepared via SQL PREPARE other than to completion, so we can enable itthere without a problem.The situation is more complicated for the extend query protocol.libpq seems to provide no way to send an Execute message with anon-zero rowcount, but some other client might. If that happens, anda parallel plan was chosen, we'll execute the parallel plan withoutusing any workers, which may be somewhat inefficient but should stillwork. Hopefully this won't be a problem; users can always setmax_parallel_degree=0 to avoid choosing parallel plans in the firstplace.Amit Kapila, reviewed by me.

1 parent25924ac commit57a6a72Copy full SHA for 57a6a72

File tree

2 files changed

-2

lines changed

src/backend
- commands
  - prepare.c
- tcop
  - postgres.c

2 files changed

-2

lines changed

`‎src/backend/commands/prepare.c`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -159,7 +159,7 @@ PrepareQuery(PrepareStmt stmt, const char queryString)`
`159`	`159`	`nargs,`
`160`	`160`	`NULL,`
`161`	`161`	`NULL,`
`162`		`-0,/default cursor options /`
	`162`	`+CURSOR_OPT_PARALLEL_OK,/allow parallel mode /`
`163`	`163`	`true);/* fixed result */`
`164`	`164`
`165`	`165`	`/*`

`‎src/backend/tcop/postgres.c`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1381,7 +1381,7 @@ exec_parse_message(const char query_string,/ string to execute */`
`1381`	`1381`	`numParams,`
`1382`	`1382`	`NULL,`
`1383`	`1383`	`NULL,`
`1384`		`-0,/default cursor options /`
	`1384`	`+CURSOR_OPT_PARALLEL_OK,/allow parallel mode /`
`1385`	`1385`	`true);/* fixed result */`
`1386`	`1386`
`1387`	`1387`	`/* If we got a cancel signal during analysis, quit */`

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!

Commit57a6a72

File tree

2 files changed

2 files changed

`‎src/backend/commands/prepare.c`

`‎src/backend/tcop/postgres.c`

0 commit comments