Re: Selecting from a Subquery Fails

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Francesco Pari <pari(at)cidimu(dot)it>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Selecting from a Subquery Fails
Date: 2009-01-24 18:31:24
Message-ID: 497B5E7C.6060909@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Martin Pitt 2009-01-24 22:44:59 Re: Fall back to alternative tsearch dictionary directory
Previous Message Alvaro Herrera 2009-01-23 18:22:56 Re: BUG #4626: postgresql recovery problem