"Rodrigo Hjort" <rodrigo(dot)hjort(at)gmail(dot)com> wrote
>- How often do you REINDEX your databases?
> - What do you verify on the database to know that it is time to reindex?
>
There is no unique answer to the first one. You can binary search your
optimal reindex rate. Suppose the workload is steady, then you first set
reindex rate at, say, one time per week, then try twice per week, if it gets
better, then try more frequent reindex. If not, then you can try 1 time per
two-weeks and so on.
Regards,
Qingqing