Does anyone see a problem with executing something similar to this on a
nightly basis (in a Cron job) to run vacuum on all databases?

----------------------------------------------
#!/usr/bin/perl

while (<`ls -1 /usr/local/pgsql/data/base`>) {
     `/usr/local/pgsql/bin/vacuumdb $_`;
}
----------------------------------------------

(It could probably be done equally as well in a shell script--I'm just more
familiar with perl)

-Jason Vasquez


Reply via email to