Re: BUG #3824: Query hangs when result set empty using sort and limit - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3824: Query hangs when result set empty using sort and limit
Date
Msg-id 29748.1197993807@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3824: Query hangs when result set empty using sort and limit  ("Gregor Roessle" <g.roessle@osram.de>)
Responses Re: BUG #3824: Query hangs when result set empty using sort and limit
List pgsql-bugs
"Gregor Roessle" <g.roessle@osram.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

pgsql-bugs by date:

Previous
From: "Gregor Roessle"
Date:
Subject: BUG #3824: Query hangs when result set empty using sort and limit
Next
From: Zdenek Kotala
Date:
Subject: Re: Bug (#3484) - Invalid page header again