Re: Query hangs when getting too complex... - Mailing list pgsql-general

From Tom Lane
Subject Re: Query hangs when getting too complex...
Date
Msg-id 29545.1008774852@sss.pgh.pa.us
Whole thread Raw
In response to Query hangs when getting too complex...  (Paulo Jan <admin@digital.ddnet.es>)
List pgsql-general
Paulo Jan <admin@mail.ddnet.es> writes:
>     I have here a query that hangs everytime I try to execute it, even
> though IMO it isn't *that* complicated (nor is the database *that* big).

Very bizarre.  Can you attach to the backend process with gdb and get a
backtrace to see where it's hung up?

            regards, tom lane

pgsql-general by date:

Previous
From: Paulo Jan
Date:
Subject: Re: Query hangs when getting too complex...
Next
From: Lee Kindness
Date:
Subject: Outputting select into file.