"Tom Lane" <[EMAIL PROTECTED]> writes:
> "Gregor Roessle" <[EMAIL PROTECTED]> 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 lo
"Gregor Roessle" <[EMAIL PROTECTED]> 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 indexs
The following bug has been logged online:
Bug reference: 3824
Logged by: Gregor Roessle
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Linux - Kernel 2.4.33
Description:Query hangs when result set empty using sort and limit
Details:
The