truncate dashboard instead of deleting, to avoid dead rows

diff --git a/cgi-bin/pgstatus.pl b/cgi-bin/pgstatus.pl
index 614fcf302099fb1530c1e88086524779fe66bd3b..603e15f2e1be9cdf1bea8000fd1c8540edaf5275 100755 (executable)
--- a/cgi-bin/pgstatus.pl
+++ b/cgi-bin/pgstatus.pl
@@ -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;