Postgres Pro
Downloads
Home   >   mailing lists

Re: Dead Lock problem with 8.1.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: Dead Lock problem with 8.1.3
Date
Msg-id 25460.1159280830@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dead Lock problem with 8.1.3  (Kai Hessing <kai.hessing@hobsons.de>)
Responses Re: Dead Lock problem with 8.1.3  (Kai Hessing <kai.hessing@hobsons.de>)
List pgsql-general
Tree view 
Kai Hessing <kai.hessing@hobsons.de> writes:
> No one any idea? *sigh*

What makes you think it's a deadlock and not a very slow query?  I'd be
checking if the tables were all ANALYZEd and comparing EXPLAIN output
to the old database ...

            regards, tom lane

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Dead Lock problem with 8.1.3
Next
From: "Thomas Peter"
Date:
Subject: Re: change the order of FROM selection to make query work