| public vacuumDB ( $table = '', $analyze = false, $full = false, $freeze = false ) | ||
| $table | The table to vacuum | |
| $analyze | If true, also does analyze | |
| $full | If true, selects "full" vacuum | |
| $freeze | If true, selects aggressive "freezing" of tuples | |
function vacuumDB($table = '', $analyze = false, $full = false, $freeze = false)
{
$sql = "VACUUM";
if ($full) {
$sql .= " FULL";
}
if ($freeze) {
$sql .= " FREEZE";
}
if ($analyze) {
$sql .= " ANALYZE";
}
if ($table != '') {
$f_schema = $this->_schema;
$this->fieldClean($f_schema);
$this->fieldClean($table);
$sql .= " \"{$f_schema}\".\"{$table}\"";
}
return $this->execute($sql);
}