Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL

simonat2ndQuadrant · simonat2ndQuadrant · commit 3ed7f54bc46a · 2016-09-09T11:46:03.000+01:00
lazy_truncate_heap() was waiting for
VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL, but in microseconds
not milliseconds as originally intended.

Found by code inspection.

Simon Riggs
diff --git a/src/backend/commands/vacuumlazy.c b/src/backend/commands/vacuumlazy.c
@@ -1163,7 +1163,7 @@ lazy_truncate_heap(Relation onerel, LVRelStats *vacrelstats)
 				return;
 			}
 
-			pg_usleep(VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL);
+			pg_usleep(VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL * 1000L);
 		}
 
 		/*

Original file line number	Diff line number	Diff line change
`@@ -1163,7 +1163,7 @@ lazy_truncate_heap(Relation onerel, LVRelStats *vacrelstats)`
`1163`	`1163`	`return;`
`1164`	`1164`	`}`
`1165`	`1165`
`1166`		`- pg_usleep(VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL);`
	`1166`	`+ pg_usleep(VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL * 1000L);`
`1167`	`1167`	`}`
`1168`	`1168`
`1169`	`1169`	`/*`