Re: [exim] exilog query

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Jeremy Harris
Ημερομηνία:  
Προς: exim-users
Αντικείμενο: 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