>> Is there a way to completely regenerate all indices in a database
>> without running through the full backup/restore cycle? It's been my
>> experience that over months or years, the database keeps getting slower
>> and slower, but a backup and immediate restore fix it to run at
>> full-speed again. I would like to achieve the same result without having
>> to stop all other work. What I tried so far:
>>
> Are you sure that the index stuff is your problem and not transaction
> related? What's the output of gstat -h at the time you think the
> database is getting slow?

No, I am not sure. I will try to get gstat -h for the slow database (I
can't do it right away as I am only getting backups from my users, not
the production databases themselves). What should I be looking for?

Pepak