pgsql: Avoid holding vmbuffer pin after VACUUM.

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Avoid holding vmbuffer pin after VACUUM.
Date: 2012-12-03 18:57:54
Message-ID: E1TfbDG-0007a4-Tf@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/c52e0e2afc0c8ca2de4e03fc8478d89b4d5e7fce

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

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2012-12-03 19:28:35 Re: pgsql: Add mode where contrib installcheck runs each module in a separa
Previous Message Simon Riggs 2012-12-03 18:54:11 pgsql: Avoid holding vmbuffer pin after VACUUM.