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
--
## List details at http://www.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/
