| 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-0007a2-TV@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_1_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/3c4eec4488fef07675db85e73445f410dac732dd
Modified Files
--------------
src/backend/commands/vacuumlazy.c | 16 +++++++++-------
1 files changed, 9 insertions(+), 7 deletions(-)
| 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. |