NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitb7f2dd9

Amit Kapila

committed

Update parallel BTree scan state when the scan keys can't be satisfied.

For parallel btree scan to work for array of scan keys, it should reachBTPARALLEL_DONE state once for every distinct combination of array keys.This is required to ensure that the parallel workers don't try to seizeblocks at the same time for different scan keys. We missed to update thisstate when we discovered that the scan keys can't be satisfied.Author: James HunterReviewed-by: Amit KapilaTested-by: Justin PryzbyBackpatch-through: 10, where it was introducedDiscussion:https://postgr.es/m/4248CABC-25E3-4809-B4D0-128E1BAABC3C@amazon.com

1 parent45b9805 commitb7f2dd9Copy full SHA for b7f2dd9

File tree

1 file changed

-0

lines changed

src/backend/access/nbtree
- nbtsearch.c

1 file changed

-0

lines changed

`‎src/backend/access/nbtree/nbtsearch.c`

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -880,7 +880,11 @@ _bt_first(IndexScanDesc scan, ScanDirection dir)`
`880`	`880`	`* never be satisfied (eg, x == 1 AND x > 2).`
`881`	`881`	`*/`
`882`	`882`	`if (!so->qual_ok)`
	`883`	`+{`
	`884`	`+/* Notify any other workers that we're done with this scan key. */`
	`885`	`+_bt_parallel_done(scan);`
`883`	`886`	`return false;`
	`887`	`+}`
`884`	`888`
`885`	`889`	`/*`
`886`	`890`	`* For parallel scans, get the starting page from shared state. If the`

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!

Commitb7f2dd9

File tree

1 file changed

1 file changed

`‎src/backend/access/nbtree/nbtsearch.c`

0 commit comments