How do I vacuum safely? And how often should I reindex

Hi!

> > 2: how often should I reindex my db, are there any standards
> >    or accepted practices out there
>
> I recreate my indices every week, or after any extensive updates or
> deletes.  Again, I believe that 7.2 has some new stuff to deal with this
> issue.

This brings me to another point. Is it really necessary to recreate indices
if you vacuum analyze your database regulary (say, every once in a week)?

Cheers,
Florian