On Wed, Dec 21, 2016 at 8:43 AM, Yogesh Sharma <yogeshraj95(at)gmail(dot)com>
wrote:
> I have responded on previously mail.
>
>
apparently you started two separate threads...
> In my production system, there are lot of read write operation performed
> every hour.
>
That still doesn't answer why you feel you need to run reindex every hour.
Do you have some measurements that show the index is bloating, or not
performing well?
I have a database that does hundreds of millions of insert/update per day,
and I *never* run reindex because it is unnecessary.