"Rodrigo Hjort" <rodrigo.hjort@xxxxxxxxx> 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
