pgsql: Avoid holding vmbuffer pin after VACUUM. - Mailing list pgsql-committers

From Simon Riggs
Subject pgsql: Avoid holding vmbuffer pin after VACUUM.
Date
Msg-id E1TfbDG-0007a6-Td@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
REL8_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/9f3558af8acf0c909ca824d0aa93152680ec3967

Modified Files
--------------
src/backend/commands/vacuumlazy.c |   16 +++++++++-------
1 files changed, 9 insertions(+), 7 deletions(-)


pgsql-committers by date:

Previous
From: Simon Riggs
Date:
Subject: pgsql: Avoid holding vmbuffer pin after VACUUM.
Next
From: Simon Riggs
Date:
Subject: pgsql: Avoid holding vmbuffer pin after VACUUM.