Re: [exim] exilog query

Jeremy Harris wrote:
> I'll post diffs once running.


This seems to work fine:

*** 196,202 ****
   sub _pgsql_sql_optimize {
     my $where = shift || "nothing";

!   my $sql = "OPTIMIZE TABLE ".$where;
     my $sh = $dbh->prepare($sql);
     $sh->execute;
     $sh->finish;
--- 196,202 ----
   sub _pgsql_sql_optimize {
     my $where = shift || "nothing";

!   my $sql = "VACUUM ANALYZE ".$where;
     my $sh = $dbh->prepare($sql);
     $sh->execute;
     $sh->finish;

(I've not checked other DBMS' for breakage, mind)

Cheers,
    Jeremy