From 6a10f0f74957190b093f1b1147b1f2767548db90 Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Mon, 10 Sep 2007 21:40:03 +0000 Subject: [PATCH] Release the exclusive lock on the table early after truncating it in lazy vacuum, instead of waiting till commit. --- src/backend/commands/vacuumlazy.c | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) diff --git a/src/backend/commands/vacuumlazy.c b/src/backend/commands/vacuumlazy.c index 25e0e071a9..f9167699fa 100644 --- a/src/backend/commands/vacuumlazy.c +++ b/src/backend/commands/vacuumlazy.c @@ -36,7 +36,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/commands/vacuumlazy.c,v 1.92 2007/09/10 17:58:45 alvherre Exp $ + * $PostgreSQL: pgsql/src/backend/commands/vacuumlazy.c,v 1.93 2007/09/10 21:40:03 alvherre Exp $ * *------------------------------------------------------------------------- */ @@ -802,6 +802,9 @@ lazy_truncate_heap(Relation onerel, LVRelStats *vacrelstats) */ RelationTruncate(onerel, new_rel_pages); + /* Now we're OK to release the lock. */ + UnlockRelation(onerel, AccessExclusiveLock); + /* * Drop free-space info for removed blocks; these must not get entered * into the FSM! @@ -834,10 +837,6 @@ lazy_truncate_heap(Relation onerel, LVRelStats *vacrelstats) vacrelstats->rel_pages = new_rel_pages; vacrelstats->pages_removed = old_rel_pages - new_rel_pages; - /* - * We keep the exclusive lock until commit (perhaps not necessary)? - */ - ereport(elevel, (errmsg("\"%s\": truncated %u to %u pages", RelationGetRelationName(onerel), -- 2.40.0