From c934fc3e45e82a26b3bf87039e99dd3364c58f1a Mon Sep 17 00:00:00 2001
From: alvherre <alvherre>
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 | 7 +++----
 1 file changed, 3 insertions(+), 4 deletions(-)

diff --git a/src/backend/commands/vacuumlazy.c b/src/backend/commands/vacuumlazy.c
index 5545796e97..fc9497b473 100644
--- a/src/backend/commands/vacuumlazy.c
+++ b/src/backend/commands/vacuumlazy.c
@@ -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.11.4.GIT