Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL

simonat2ndQuadrant · simonat2ndQuadrant · commit f3b3e871ee69 · 2016-09-09T11:43:46.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
@@ -1484,7 +1484,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
`@@ -1484,7 +1484,7 @@ lazy_truncate_heap(Relation onerel, LVRelStats *vacrelstats)`
`1484`	`1484`	`return;`
`1485`	`1485`	`}`
`1486`	`1486`
`1487`		`- pg_usleep(VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL);`
	`1487`	`+ pg_usleep(VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL * 1000L);`
`1488`	`1488`	`}`
`1489`	`1489`
`1490`	`1490`	`/*`