"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 indexscan on timestamp to substitute for a sort step? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq