| From: | Yogesh Sharma <Yogesh1(dot)Sharma(at)nectechnologies(dot)in> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Query regarding deadlock |
| Date: | 2016-11-25 02:06:45 |
| Message-ID: | 8F86F8F397DDD345B25EA2EF3E2164829ECC8601@EXCH-MB02-U1.nectechnologies.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
If there is any solution like we can add some check before REINDEX operation performed.
If it is possible?
Regards,
Yogesh
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of John R Pierce
Sent: Friday, November 25, 2016 10:55 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sameer Kumar | 2016-11-25 02:14:26 | Re: Query regarding deadlock |
| Previous Message | John R Pierce | 2016-11-25 01:55:20 | Re: Query regarding deadlock |