Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group