Re: [GENERAL] second concurrent update takes forever

2010-02-08 Thread Tom Lane
Janning Vygen writes: > We are running a rather complicated Update statement from time to time which > is only triggered by administrators. The statement updates about 50.000 rows. > It takes usually about 10-30 seconds to execute and that's fine for us. > This time two administrator did run t

[GENERAL] second concurrent update takes forever

2010-02-08 Thread Janning Vygen
Hi folks, I don't need this list very often because postgresql works like a charm! But today we encountered a rather complicated puzzle for us. We really need your help! we are using postgresql 8.4 on a debian lenny with latest security patches applied. We are running a rather complicated Upd