Re: subqueries

----- Original Message -----
From: "Tomasz Grobelny" <tomasz(at)grobelny(dot)oswiecenia(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, June 19, 2005 6:12 PM
Subject: [GENERAL] subqueries

>I have such a statement:
> select * from (subquery1) as foo, (subquery2) as bar;
> Both subqueries are reasonably fast (<0.5s) and generate results that have
> several (<10) rows but the whole query takes forever to execute. Moreover
> if
> I simplify those subqueries (limiting functionality) the whole select
> clause
> works just fine. It seems that those subqueries are not executed
> separately.
> What am I doing wrong?

This is calling out for some EXPLAIN output (perhaps from the two subqueries
individually and then the full query).

Sean