Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever if no data present

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Fahad G(dot)" <Fahad(dot)Gilani(at)anusf(dot)anu(dot)edu(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever if no data present
Date: 2005-01-15 14:06:02
Message-ID: 20050115140602.GA78169@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2005-01-15 17:40:07 Re: rc5: initdb freeze with "selecting default max_connections ..."
Previous Message Phil 2005-01-15 14:01:52 BUG #1403: Failed to create process: 2