Thanks for your support. I mean to say, the REINDEX calls hourly and insert query executes every minute to update. So, it might be race condition that these queries can call at same time.
Reindex every hour? How did you end up with that. Looks like you got another problem while fixing one with a dirty solution. Why do you need to reindex every hour?
If there is any solution like we can add some check before REINDEX operation performed. If it is possible?
On 11/24/2016 5:44 PM, Yogesh Sharma wrote: > I cannot change calling of REINDEX and insert query sequence because it is execute automatically through some cron script.
any cron scripts are your own doing, so this statement makes no sense at all.