Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever if no data present - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever if no data present
Date
Msg-id 20050115140602.GA78169@winnie.fuhr.org
Whole thread Raw
In response to Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever if no data present  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Tree view 
On Fri, Jan 14, 2005 at 11:18:15AM -0700, Michael Fuhr wrote:
>
> Since you say the query takes forever to return, it might be useful
> to see the output of pg_locks.

Reminder to self: "takes forever to return" might mean "eventually
returns, but takes a long time".  Should have asked for clarification
and EXPLAIN or EXPLAIN ANALYZE output.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever
Next
From: "Magnus Hagander"
Date:
Subject: Re: rc5: initdb freeze with "selecting default max_connections ..."