Re: BUG #3824: Query hangs when result set empty using sort and limit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gregor Roessle" <g(dot)roessle(at)osram(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3824: Query hangs when result set empty using sort and limit
Date: 2007-12-18 16:03:27
Message-ID: 29748.1197993807@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Gregor Roessle" <g(dot)roessle(at)osram(dot)de> writes:
> The Server hangs when executing a query like this:

> select * from messwerte where pknr = 28315178 and isproducing = 't' order by
> timestamp desc limit 1;

I seriously doubt that it's hung. Takes a long time, maybe so. Is it
trying to use an indexscan on timestamp to substitute for a sort step?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Zdenek Kotala 2007-12-18 16:24:19 Re: Bug (#3484) - Invalid page header again
Previous Message Gregor Roessle 2007-12-18 15:46:38 BUG #3824: Query hangs when result set empty using sort and limit