mail/exilog/files/patch-exilog_sql.pm


1
2
3
4
5
6
7
8
9
10
11

--- /usr/local/www/exilog/exilog_sql.pm	Tue Feb 21 16:23:56 2006
+++ exilog_sql.pm	Wed Aug 24 09:22:29 2005
@@ -208,7 +208,7 @@
 sub _pgsql_sql_optimize {
   my $where = shift || "nothing";
 
-  my $sql = "OPTIMIZE TABLE ".$where;
+  my $sql = "VACUUM ANALYZE  ".$where;
   my $sh = $dbh->prepare($sql);
   $sh->execute;
   $sh->finish;