On Mon, Jun 12, 2006 at 04:58:49PM +0200, Ruben Rubio Rey wrote: > $DIREC/vacuumdb -f -v --analyze vacadb 2>&1 | $LOGBIN > $DIRLOGS/%Y-%m-%d_limpieza.log > echo "reindex database vacadb;" | $DIREC/psql vacadb 2>&1 | $LOGBIN > $DIRLOGS/%Y-%m-%d_limpieza.log > date | $LOGBIN $DIRLOGS/%Y-%m-%d_limpieza.log Ugh. Is there some reason you're not using the built-in autovacuum? If you enable it and cut the thresholds in half you'll most likely never need to vacuum manually, let alone reindex. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
