truncate dashboard instead of deleting, to avoid dead rows
authorAndrew Dunstan <andrew@dunslane.net>
Mon, 13 Apr 2009 15:15:35 +0000 (15:15 +0000)
committerAndrew Dunstan <andrew@dunslane.net>
Mon, 13 Apr 2009 15:15:35 +0000 (15:15 +0000)
cgi-bin/pgstatus.pl

index 614fcf302099fb1530c1e88086524779fe66bd3b..603e15f2e1be9cdf1bea8000fd1c8540edaf5275 100755 (executable)
@@ -324,7 +324,7 @@ $sth->finish;
 
 
 $db->begin_work;
 
 
 $db->begin_work;
-$db->do("delete from dashboard_mat");
+$db->do("truncate dashboard_mat");
 $db->do("insert into dashboard_mat select * from dashboard_mat_data");
 $db->commit;
 
 $db->do("insert into dashboard_mat select * from dashboard_mat_data");
 $db->commit;