Re: subqueries

----- Original Message -----
From: "Tomasz Grobelny" <tomasz@grobelny.oswiecenia.net>
To: <pgsql-general@postgresql.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