On Fri, 25 Nov 2016, 10:07 a.m. Yogesh Sharma, < yogesh1.sha...@nectechnologies.in> 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. > 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? > > Regards, > Yogesh > > -----Original Message----- > From: pgsql-general-ow...@postgresql.org [mailto: > pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce > Sent: Friday, November 25, 2016 10:55 AM > To: pgsql-general@postgresql.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Best Regards, *Sameer Kumar | DB Solution Architect* *ASHNIK PTE. LTD.* 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533 T: +65 6438 3504 | www.ashnik.com Skype: sameer.ashnik | T: +65 8110 0350 [image: www.ashnik.com] <http://www.ashnik.com/>
