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

2007-12-18 Thread Gregory Stark
"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

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

2007-12-18 Thread Tom Lane
"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