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