Re: [PERFORM] deadlock under load

2012-11-30 Thread Bob Jolliffe
On 30 November 2012 15:57, Tom Lane wrote: > Bob Jolliffe writes: > > We am running a web application on ubuntu 10.10 using postgres 8.4.3. > > Current release in that branch is 8.4.14. (By this time next week > it'll be 8.4.15.) You are missing a lot of bug fixes: > http://www.postgresql.org/

Re: [PERFORM] deadlock under load

2012-11-30 Thread Tom Lane
Bob Jolliffe writes: > We am running a web application on ubuntu 10.10 using postgres 8.4.3. Current release in that branch is 8.4.14. (By this time next week it'll be 8.4.15.) You are missing a lot of bug fixes: http://www.postgresql.org/docs/8.4/static/release.html > Trying to interpret this

[PERFORM] deadlock under load

2012-11-30 Thread Bob Jolliffe
Hello We am running a web application on ubuntu 10.10 using postgres 8.4.3. We are experiencing regular problems (each morning as the users come in) which seem to be caused by deadlocks in the postgres database. I am seeing messages like: 2012-11-30 10:24:36 GMT LOG: sending cancel to blocking