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: (view raw or whole 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

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-2015 The PostgreSQL Global Development Group