Francesco Pari escreveu: > The query Hangs .... > > can this be a bug or a misconfiguration? > It isn't a bug unless you show us a backend's crash, memory leak, or another misbehavior. I suspect the second query is suffering from a bad plan. Try posting EXPLAIN ANALYZE of both queries to pgsql-performance (this is not the right list for such a question).
-- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs