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

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

2007-12-18 Thread Gregor Roessle
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