Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group