Re: subqueries
От | Sean Davis |
---|---|
Тема | Re: subqueries |
Дата | |
Msg-id | 000a01c5751f$3db81f80$5179f345@WATSON обсуждение исходный текст |
Ответ на | subqueries (Tomasz Grobelny <tomasz@grobelny.oswiecenia.net>) |
Ответы |
Re: subqueries
|
Список | pgsql-general |
----- 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
В списке pgsql-general по дате отправления: