Postgres Pro
Downloads
Home   >   mailing lists

Re: Selecting from a Subquery Fails - Mailing list pgsql-bugs

From Euler Taveira de Oliveira
Subject Re: Selecting from a Subquery Fails
Date
Msg-id 497B5E7C.6060909@timbira.com
Whole thread Raw
In response to Selecting from a Subquery Fails  (Francesco Pari <pari@cidimu.it>)
List pgsql-bugs
Tree view 
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/

pgsql-bugs by date:

Previous
From: Francesco Pari
Date:
Subject: Selecting from a Subquery Fails
Next
From: Martin Pitt
Date:
Subject: Re: Fall back to alternative tsearch dictionary directory