Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL

simonat2ndQuadrant · simonat2ndQuadrant · commit e1dddf3e89ec · 2016-09-09T11:45:16.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
@@ -1441,7 +1441,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
`@@ -1441,7 +1441,7 @@ lazy_truncate_heap(Relation onerel, LVRelStats *vacrelstats)`
`1441`	`1441`	`return;`
`1442`	`1442`	`}`
`1443`	`1443`
`1444`		`- pg_usleep(VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL);`
	`1444`	`+ pg_usleep(VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL * 1000L);`
`1445`	`1445`	`}`
`1446`	`1446`
`1447`	`1447`	`/*`