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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
