----- Original Message -----
From: "Tomasz Grobelny" <tomasz@xxxxxxxxxxxxxxxxxxxxxxx>
To: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Sunday, June 19, 2005 6:12 PM
Subject: 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
