On 2016-11-24 9:06 PM, Yogesh Sharma wrote:
Dear John,
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.
Why do you need to run REINDEX every hour? That sounds like a stopgap
solution for another problem.
If there is any solution like we can add some check before REINDEX operation performed.
If it is possible?
Try to find out why the cron script is there in the first place. Then go
from there - eliminate it, or do it only in down periods.
Regards,
Yogesh
-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of John R Pierce
Sent: Friday, November 25, 2016 10:55 AM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Query regarding deadlock
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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
