Re: [PERFORM] Re: recently and selectively slow, but very simple, update query....

g of postgres. wish you all have a great day. my apology and best regards, /mstelios Stelios Mavromichalis Cytech Ltd. - http://www.cytech.gr/ Science & Technology Park of Crete fax: +30 2810 31 1045 tel.: +30 2810 31 4127 mob.: +30 697 7078013 skype: mstelios On Tue, May 6, 2014 at 4

Re: [PERFORM] Re: recently and selectively slow, but very simple, update query....

et) JOIN c ON (c.requested = blocked.mode AND c.current = blocker.mode) ), r AS ( SELECT blocker_target, blocker_pid, blocker_mode, '1'::intAS depth, target, pid,

Re: [PERFORM] Re: recently and selectively slow, but very simple, update query....

light you think? best regards, /mstelios Stelios Mavromichalis Cytech Ltd. - http://www.cytech.gr/ Science & Technology Park of Crete fax: +30 2810 31 1045 tel.: +30 2810 31 4127 mob.: +30 697 7078013 skype: mstelios On Tue, May 6, 2014 at 12:51 AM, David G Johnston < david.g.johns

Re: [PERFORM] recently and selectively slow, but very simple, update query....

hello list, since i got no reply i am afraid i'll go the dump/restore cycle path hopping this will solve my problem. best regards, /mstelios Stelios Mavromichalis Cytech Ltd. - http://www.cytech.gr/ Science & Technology Park of Crete fax: +30 2810 31 1045 tel.: +30 2810 31 4127 mob.