NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit4c697d8

committed

Count locked pages that don't need vacuuming as scanned.

Previously, if VACUUM skipped vacuuming a page because it's pinned, itdidn't count that page as scanned. However, that meant that relfrozenxidwas not bumped up either, which prevented anti-wraparound vacuum fromdoing its job.Report by Миша Тюрин, analysis and patch by Sergey Burladyn and Jeff Janes.Backpatch to 9.2, where the skip-locked-pages behavior was introduced.

1 parentf901bb5 commit4c697d8Copy full SHA for 4c697d8

File tree

1 file changed

-0

lines changed

src/backend/commands
- vacuumlazy.c

1 file changed

-0

lines changed

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

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -602,6 +602,7 @@ lazy_scan_heap(Relation onerel, LVRelStats *vacrelstats,`
`602`	`602`	`if (!lazy_check_needs_freeze(buf))`
`603`	`603`	`{`
`604`	`604`	`UnlockReleaseBuffer(buf);`
	`605`	`+vacrelstats->scanned_pages++;`
`605`	`606`	`continue;`
`606`	`607`	`}`
`607`	`608`	`LockBuffer(buf,BUFFER_LOCK_UNLOCK);`

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!

Commit4c697d8

File tree

1 file changed

1 file changed

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

0 commit comments