]> granicus.if.org Git - postgresql/commit
Avoid holding vmbuffer pin after VACUUM.
authorSimon Riggs <simon@2ndQuadrant.com>
Mon, 3 Dec 2012 18:54:52 +0000 (18:54 +0000)
committerSimon Riggs <simon@2ndQuadrant.com>
Mon, 3 Dec 2012 18:54:52 +0000 (18:54 +0000)
commit17ee02ea1c87b96a4d687d3319f6f4602450d6cb
tree041772537369d906227ccfd65ec02b617af2ae22
parent6a8b9987c63bc88b3a4fd56a644d250e7113dd7f
Avoid holding vmbuffer pin after VACUUM.
During VACUUM if we pause to perform a cycle
of index cleanup we drop the vmbuffer pin,
so we should do the same thing when heap
scan completes. This avoids holding vmbuffer
pin across the main index cleanup in VACUUM,
which could be minutes or hours longer than
necessary for correctness.

Bug report and suggested fix from Pavan Deolasee
src/backend/commands/vacuumlazy.c